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

• HOOPP Pension Plan (Defined Benefits Pension)
• Retirement Planning Program
• Generous vacation days for permanent and long-term contracts
• Work-life balance
• Career Planning Program
• 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 Senior Analyst - Back-end ETL Testing, Quality Assurance (QA) plays a critical role in ensuring the quality of CIHI’s deliverables by working closely with ITS staff and business units. This role involves acting as the QA representative on projects, designing and executing complex test scripts, coordinating test efforts, and contributing to the evolution of CIHI’s QA methodologies. The Senior Analyst serves as a subject matter expert in test automation and quality assurance best practices, providing guidance and support to team members.

What you'll do

• Represent QA on project teams, collaborating with business and development groups to understand product functionality and testing impacts.

• Design test strategies, create and execute test plans, cases, and scripts for product releases; identify or create test data; log defects; and sign off on product quality.

• Lead and coordinate test efforts on projects and development activities, including automation initiatives.

• Investigate bugs and issues during testing and recommend solutions.

• Develop and maintain ETL data pipeline test plans, test script and automation test framework development and execution in a complex data heavy environment.

• Promote adherence to CIHI’s Software Development Life Cycle (SDLC) and QA methodologies.

• Participate in impact assessments for change requests and review deliverables for compliance with quality standards.

• Maintain and administer automated test tools and provide training and support to users.

• Contribute to continuous improvement of QA processes, policies, and metrics.

• Support testing of data warehousing, business intelligence solutions, and cloud-based data structures.

• Collaborate effectively within the QA team and across the organization to ensure high-quality outcomes.

What you'll bring to the table

• Undergraduate degree in Computer Science, Management Information Systems (MIS) or related field, or equivalent combination of education and related experience.

• Further specialization in Quality Assurance methodologies is preferred.

• 3-5 years of experience in a technical analytical QA role within software development cycles.

• Demonstrated experience in test planning, test case development and execution, test data management, and defect tracking.

• Experienced in ETL Testing Tools in Cloud (preferred AWS platform and environment) besides strong knowledge of PySpark and Python based framework for data pipeline testing and automation.

• Experience with black-box testing techniques including functional, security, regression, usability, and user acceptance testing.

• API integrations tests and any front-end automation testing knowledge is considered an asset.

• Expertise in Pyspark and Python libraries and strong knowledge of RDBMS, SQL for ETL data pipeline Testing.

• Familiarity with cloud-based data transformation and data warehousing concepts is preferred. Experience with AWS services such as S3, Redshift, Athena, CloudWatch, and related technologies is considered an asset.

• Knowledge of systems development methodologies (UML, RUP, CMM, TMMi) is preferred.

• Knowledge of performance testing tools for ETL pipelines and backend data infrastructure is an asset.

• Excellent interpersonal, facilitation, verbal, and written communication skills.

• Strong team player with a client/user orientation.

• Ability to plan, coordinate, and manage workload effectively.

• Must comply with all CIHI workplace policies, including privacy and confidentiality.

• Fluency in English is required, bilingualism in both official languages is an asset.

Closing Statement

To find out more about this role and other exciting opportunities visit our website at www.cihi.ca and check out our 'Careers' section.

We thank all those who apply, however, only candidates selected for an interview will be contacted.

As part of CIHI’s applicant screening process, we complete a comprehensive pre-employment background check for all potential hires. This includes a criminal record check, credit report, social media, and education verification.

Employment Equity

At CIHI we are committed to fostering an inclusive, barrier-free and accessible environment. Part of this commitment includes arranging accommodations to ensure an equitable opportunity to participate in the recruitment and selection process. If you require an accommodation, we will work with you to meet your needs.