Team Lead, Quality Assurance- Data Warehouse Testing

Team Lead, Quality Assurance - Data Warehouse Testing

Who we are

We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we provide essential information on Canada’s health systems, enabling decisions that lead to healthier Canadians. As a valued member of the CIHI team, you and your work will have a pivotal role in the evolution of Canada’s health care systems.

CIHI is recognized as an exceptional place to work that embraces diversity, respect, integrity, collaboration and innovation. Learn about our Equity, Diversity and Inclusion Strategy and the work being done to create a more inclusive and welcoming organization by focusing on how we learn, govern and practise.

At CIHI, we recognize what matters to our employees. Some of the benefits of working at CIHI include

• Retirement Planning Program
• Generous vacation days for permanent and long‑term contracts
• Work‑life balance
• Learning and Professional Development Program
• Flexible benefits program from your first day on the job for permanent and long‑term contracts

Why is this role important?

The Team Lead, Quality Assurance is responsible for working with ITS staff and business units to oversee the implementation of quality assurance and quality control processes to ensure delivery of high quality, error‑free applications to CIHI’s internal and external users operating within specified availability parameters. The Team Lead, QA develops and maintains the ITS Quality Assurance processes and supporting standards, guidelines and documentation.

What you’ll do

• Provides leadership and guidance to staff. Supervises, coaches, coordinates, and monitors daily work, workload and performance of staff to ensure quality is maintained and that learning opportunities are provided. Provides feedback on performance to QA Manager and leadership.
• As the QA representative on project initiatives, leads and participates in the design and development of test automation and test frameworks for data pipelines and ETL testing contributing to the evolution of CIHI’s QA methodology around process and technology.
• Leads and participates in visualization of End to End (E2E) testing pipeline and planning involving back‑end data testing, API and integration with front‑end user perspective both functional, performance and automation testing capability and planning.
• Researches and liaises with ITS Management and staff as well as business units to assist in the development of QA policies, procedures and best practices for all systems development activities, including standard templates, testing protocols, sign‑off and acceptance procedures and criteria. Responsible for test infrastructure and architecture including long‑term maturity of test practices, automated regression testing, scheduling and monitoring.
• Leads and contributes to all Data Warehousing and Front‑end testing initiatives for projects including Test Strategy/Plan creation, QA test case creation and execution, defect management process and User Acceptance Testing (UAT) with internal business units.
• Acts as a visionary to help advance technology, approach and implementation strategies in‑line with latest trends in Quality Engineering and Assurance.
• Liaises with ITS staff and business units to review development plans for adherence to quality assurance processes. Working with project teams, ensures project plans allow for sufficient time and activities for quality assurance and testing, and ensures the delivery of high‑quality applications that meet the needs of internal/external users.
• Works with technical users and business units to ensure thorough, systematic, customized testing activity plans are developed for each application. Monitors, moderates and signs off on test plans and results in accordance with the agreed‑upon quality assurance process and plan.
• Ensures deliverables meet requirements for quality assurance and provide guidance on actions/scenarios that may cause error messages within CIHI products.
• Participates as a Quality Assurance (QA) representative with project teams, business groups and development teams. Consults with teams to understand product functionality and the impact of requirements and change requests to software testing.
• Oversee the creation of test strategies, review requirements, assist in the development of test plans, cases and scripts for product releases, executes test scripts, identifies and/or creates test data, logs defects, and provides input on product quality.
• Participates in impact assessments for change requests.

What you’ll bring to the table

• University degree in Computer Science, Management Information Systems (MIS), or related discipline. A combination of equivalent experience and education may be considered.
• 6 - 8 years of experience in a senior technical analytical position or Software Development Engineer in Test (SDET) responsible for Data Warehouse testing as primary skill throughout the development life cycle.
• Minimum of three (3) years of experience leading a QA team or a Team Lead role and assisting implementation of test strategies, planning, execution and reporting across the company.
• Solid Project Management, Software Development Lifecycle (SDLC) experience alongside understanding of TMMi with a focus on QA Policies and Procedures including test strategy & planning, test case creation and execution.
• Ability to plan and coordinate workload effectively and to work as part of the larger QA team is essential.
• Expert knowledge of RDBMS systems and experience writing SQL queries and test data management for data testing.
• Knowledge of API testing using Postman, Swagger or integrated frameworks is required.
• Demonstrated knowledge of ETL and BI components/tools (like Qlik) with preferred experience in Cloud based solutions, data lakes and other data and file structures in AWS eco‑system (S3, Redshift), AWS EMR clusters and utilities like Glue, Hive, Apache Airflow or similar products.
• Strong experience in Python framework based automated ETL data testing and DataOps.
• Ability to showcase QA success stories across multiple stakeholders including internal ITS team and business areas to create the visualization of quality engineering excellence and vision towards larger quality assurance across the organization.
• Excellent interpersonal, presentation, facilitation and verbal and written communication skills. Ability to communicate complex ideas in simple terminology.
• Fluency in English is required, bilingualism in both official languages is an asset.
• Ability to meet occasional travel requirements (approximately 1-2 times a year)

Seniority level: Mid‑Senior level

Employment type: Full-time

Job function: Information Technology

Industries: IT Services and IT Consulting, IT System Testing and Evaluation, and Software Development