At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value. How we work together is reflected through our five values: integrity, inspiration, tenacity, humility and care.
What Ontario Health offers:
Achieving your career goals is a priority to us. Benefits of working at Ontario Health may include the following based on employment type:
- Fully paid medical, dental and vision coverage from your first day
- Health care spending account
- Premium defined benefit pension plan
- 3 personal days and 2 float days annually
- Individual contributors start at 3 weeks’ vacation, and 4 weeks at 2 yrs.
- Career development opportunities
- A collaborative values-based team culture
- Wellness programs
- A hybrid working model
- Participation in Communities of Inclusion
Want to make a difference in your career? Consider this opportunity.
The Senior Quality Assurance Engineer is responsible for ensuring the quality of the digital solutions being implemented and building/maintaining automated testing tools and assets. This includes performing Quality Assurance services and executing functional, integration, interface, performance and regression testing, preparing estimates and participating in planning and preparation services along with other testing artifacts in alignment with best practices and OH Quality Assurance standards.
The Senior Quality Assurance Engineer may lead test engineering efforts for complex projects including assess project requirements, provide estimates for testing tasks and deliverables and conduct a variety of tests to assess the quality and efficacy of a range of applications in preparation of deployment and through operations. Also, coordinates with Project/Product Manager and stakeholders to ensure test asset development is integrated into overall project schedule. The Senior Quality Assurance Engineer will research, set up, manage and maintain testing tools and their execution environment.
Here is what you will be doing:
- Assesses project requirements and provide estimates for testing tasks and deliverables with some assistance.
- Creates test scenarios and data for testing.
- Applying risk-based approach to design and communicate a practical testing strategy to the team, considering testing risks and options for their mitigation within the constraints of the project timeline.
- Tracks test planning and execution in the application lifecycle management tool and provide reporting when requested. Documents results and provides updates to project teams and Management as requested.
- Identifies, documents and monitors test results and enhancements from third party vendors.
- Provides support and guidance to project/product team on test case planning and execution approach for Data Warehousing initiatives.
- Create complex SQL scripts to verify ETL and BI back-end database results.
- Perform comprehensive database data analysis using SQL queries to prepare test data.
- Develops the best user experiences possible and is jointly accountable for the quality of the products and services that they test for their customers.
- Engages both internal and external clients to gain a deeper understanding of their product domain and to assist their clients in the identification of the root cause of issues.
- Educates members of the team on QA best practices and advocates implementation of such practices within the team to maintain the quality of the product.
- Collaborates with team members (developers, quality assurance and business analysts, project and product managers) to review available documentation and build a common understanding of the target state of the system under test.
- Adhering to the QA Centre of Excellence standards and to practices of the chosen SDLC methodology (Agile, Waterfall) during all phases of the projects.
- Create, implement and refine a comprehensive QA digital marketing plan to drive quality into the heart of the department.
- Motivates other team members to achieve higher goals and improve the impact of technology initiatives.
- Develop testing protocols to minimize errors across all digital marketing channels and ensure the highest standards for all communications.
- Understand campaign requirements and handle large data tests and IT research requests with proficiency to maximize success.
- Works with a high level of autonomy within a defined project/solution/system scope based on direction from a manager or QA Lead.
- Participates in development of test plan with QA Lead and other technical leads and prepares and execute test cases for responsible system.
- Ensures work aligns to broader project plan.
- Stays abreast of evolving technology, architecture, and design, patterns, practices, and platforms.
- Test all assets of digital communication, including website, landing pages, marketing automation workflows, emails, etc.
- Follow complex BRD/User Stories that aligns to the as-is Digital Marketing Cloud solution, and overall system / integration environments.
- Proven capability to design and execute tests based on high-level overviews of the Digital Marketing Cloud architecture and integration capabilities.
- Makes decisions where results have a major impact across the organization requiring sophisticated solutions and long-term correction.
- Writing positive, negative, smoke and regression test cases and creating corresponding test scripts and testing data to verify product functionality.
- Coordinating preparation of the test environment such as deploying code artefacts in testing environments, requesting database refreshes, setting up testing accounts.
- May be required to work outside of regular business hours based on business needs.
Here is what you will need to be successful:
Education and Experience:
- Bachelor’s or Master’s degree in Computer Science or related technical discipline, or equivalent experience.
- 5 – 7 years of experience in the information technology field particularly in the area of application development, data analysis, data architecture, systems analysis with significant with ETL, Data Warehouse, and back-end data validation.
- QA Certification with ISTQB or QAI, ITIL (or similar substitute) is an asset.
- Agile Certification is an asset.
- AWS and/or Azure Cloud certification is an asset.
- Experience designing, building and maintaining automation test frameworks/scripts for UI, non-UI and web services.
- Strong experience in working independently on reading, modifying existing scripts/programs for which documentation may not be available.
- Experience in all phases of the Software Development Life Cycle and related methodologies such as Agile, Iterative, etc.
- Strong experience with MS SQL Server, Oracle or some other database management.
- Strong experience in reviewing, architecting and defining test data, test environments to accommodate parallel testing for large integrated applications.
- Strong experience with various RDBMS DB technologies such as RDBMS (Oracle, MySQL, SQL Server). NoSQL DBs (DynamoDB, MongoDB).
Knowledge and Skills:
- Excellent database data analysis skills using SQL.
- Technical proficiency in Siebel/CRM is an asset.
- Ability to write complex SQL scripts including joins and aggregations to analyze backend data and verify behaviour of ETL processes.
- Expert understanding of database concepts for SQL Server and/or Oracle, such as PL/SQL, procedures, triggers, packages, views.
- Basic knowledge of Unix/Linux operations (connectivity, navigation, executing basic commands) is a strong asset.
- Extensive knowledge of quality assurance/testing processes, best practices, techniques and tools for different types of testing (functional, GUI, API/web service, integration, regression, performance, hardware, deployment, manual and automated testing).
- Solid understanding of how User Stories, Business Requirements Definition (BRD), Data Models, data mappings and design are used to support QA testing.
- Working knowledge of defect management and tracking tools (e.g., Jira, TFS).
- In-depth knowledge to manage and maintain the testing tools and their execution environment.
- In-depth knowledge of source code control and software configuration management.
- Knowledge of data management and data movement ETL and ELT tools.
- Excellent understanding of database concepts, such as PL/SQL, procedures, triggers, packages, views.
- Understanding of key cloud concepts for one of the major cloud providers (such as Azure or AWS) is an asset.
- Excellent problem solving and analytical skills to track test planning and execution, ensure the quality of the digital solutions being implemented, assess the quality and efficacy of a range of applications, assess project requirements to provides accurate estimates for testing tasks and deliverables, prepare and execute test cases, query databases to verify data, solve complex technical issues inherent in testing and be able to identify potential defects and enhancements.
- Strong written and oral communication skills to communicate testing strategy, discuss and incorporate stakeholder’s feedback, and communicate issues found during testing clearly, develop testing reports and other related documentation, educate members of the team on QA best practices.
- Interpersonal and communication skills to work as a team member across OH, both with clinical leads as well as other technical professionals such as Project Managers, Business Analysts, Business Leads, Development, and IT.
- Ability to work in a fast-paced environment with emphasis on responding to change rather than following the plan.
- Ability to work independently on assigned tasks and ability to meet tight deadlines.
- Ability to motivate other team members to achieve higher goals and improve the impact of technology initiatives.
- Demonstrated ability to understand and discuss technical concepts, manage trade-offs, and evaluate opportunistic innovative ideas with internal and external partners.
- Ability to understand and apply concepts.
- Strong multitasking skills and attention to detail.
- Ability to make decisions where results have a major impact across the organization.
- Capacity to be aware of, control, and express one’s emotions, and to handle interpersonal relationships judiciously and empathetically within product/project teams, and cross-portfolio and external stakeholder interactions.
Employment Type: Permanent Full-time
Salary Band: 6
Location: Ontario (currently hybrid; subject to change)
All applicants must be a resident of Ontario to be considered for roles at Ontario Health.
Internal Application Deadline Date: September 4, 2024
External Application Deadline Date: September 18, 2024
Ontario Health encourages applications from candidates who are First Nations, Métis, Inuit, and urban Indigenous; Francophone; Black and racialized; members of 2SLGBTQIA+ communities; trans and nonbinary; and disabled.
We encourage applicants with accessibility needs to notify us if they have any accommodation needs in the application and/or interview process.
