Intermediate Quality Assurance (QA) Analyst (5+) to establish and govern QA for analytics reporting using Power BI and SQL

S I Systems; Vancouver; Hybrid; CAD 55,000 - 83,000; Full time

Job summary

S.I. Systems Ltd. is seeking an Intermediate QA Analyst to establish and govern QA for analytics reporting using Power BI and SQL.

The role focuses on building a formal QA function for Power BI analytics that underpins operations, regulatory compliance, resource planning and performance management. Hybrid Vancouver contract, ~20 hours per week with potential start in Dec 2026. Responsibilities include test strategy, functional/regression testing, data validation, QA gates, and defect management.

Qualifications

• Data validation and testing methodologies for analytics reporting across Power BI
• SQL and data querying across SQL Server, ETL pipelines, and semantic models
• DAX for validating measures and calculations; data modeling concepts (semantic models, relationships, measures)
• Test management and defect tracking tools such as Azure DevOps and Jira
• Star schema and snowflake schema design; data profiling, data quality assessment, and downstream impact assessment of data/model changes

Responsibilities

• Develop and execute test strategies, plans, and cases for Power BI solutions
• Perform functional and regression testing across analytics components
• Ensure end-to-end data validation and source-to-report accuracy
• Establish and enforce a formal QA gate and provide release sign-off
• Manage defects using standard tools and collaborate with developers for timely resolution
• Assess downstream impacts of data model changes on dependent reports and dashboards
• Develop and maintain reusable test assets, including regression test suites and data validation scripts

Skills

Power BI

SQL

DAX

Data validation

Test planning

End-to-end data validation

Quality gates

Release governance

Defect management

Tools

Azure DevOps

Jira

SQL Server

ETL pipelines

Semantic models

Star schema

Snowflake schema

Job description

Intermediate Quality Assurance (QA) Analyst (5+) to establish and govern QA for analytics reporting using Power BI and SQL

Our public sector client is seeking an Intermediate Quality Assurance (QA) Analyst (5+) to establish and govern QA for analytics reporting using Power BI and SQL

Lead the build-out of a formal QA function for Power BI analytics that underpins business operations, regulatory compliance, resource planning, and performance management. Scope includes defining QA standards, templates, quality gates, and release governance, plus structured test planning, functional/regression testing, end-to-end data validation, defect management, and release sign-off. Contract, hybrid role in Vancouver with an initial one-year term (option to extend), approximately 20 hours per week minimum, and a potential start as early as Dec 21, 2026. Assignments will be offered based on project demand and resource requirements.

Contract, hybrid role in Vancouver with an initial one-year term (option to extend), approximately 20 hours per week minimum, and a potential start as early as Dec 21, 2026. Assignments will be offered based on project demand and resource requirements.

Must Haves

• Data validation and testing methodologies for analytics reporting across Power BI
• SQL and data querying across SQL Server, ETL pipelines, and semantic models
• DAX for validating measures and calculations; data modeling concepts (semantic models, relationships, measures)
• Test management and defect tracking tools such as Azure DevOps and Jira
• Star schema and snowflake schema design; data profiling, data quality assessment, and downstream impact assessment of data/model changes

Nice to Have

• Power Query (M)
• Microsoft Fabric

Responsibilities

• Develop and execute test strategies, plans, and cases for Power BI solutions
• Perform functional and regression testing across analytics components
• Ensure end-to-end data validation and source-to-report accuracy
• Establish and enforce a formal QA gate and provide release sign-off
• Manage defects using standard tools and collaborate with developers for timely resolution
• Assess downstream impacts of data model changes on dependent reports and dashboards
• Develop and maintain reusable test assets, including regression test suites and data validation scripts

Our public sector client is seeking an Intermediate Quality Assurance (QA) Analyst (5+) to establish and govern QA for analytics reporting using Power BI and SQL

Lead the build-out of a formal QA function for Power BI analytics that underpins business operations, regulatory compliance, resource planning, and performance management. Scope includes defining QA standards, templates, quality gates, and release governance, plus structured test planning, functional/regression testing, end-to-end data validation, defect management, and release sign-off. Contract, hybrid role in Vancouver with an initial one-year term (option to extend), approximately 20 hours per week minimum, and a potential start as early as Dec 21, 2026. Assignments will be offered based on project demand and resource requirements.

Contract, hybrid role in Vancouver with an initial one-year term (option to extend), approximately 20 hours per week minimum, and a potential start as early as Dec 21, 2026. Assignments will be offered based on project demand and resource requirements.

Must Haves

• Data validation and testing methodologies for analytics reporting across Power BI
• SQL and data querying across SQL Server, ETL pipelines, and semantic models
• DAX for validating measures and calculations; data modeling concepts (semantic models, relationships, measures)
• Test management and defect tracking tools such as Azure DevOps and Jira
• Star schema and snowflake schema design; data profiling, data quality assessment, and downstream impact assessment of data/model changes

Nice to Have

• Power Query (M)
• Microsoft Fabric

Responsibilities

• Develop and execute test strategies, plans, and cases for Power BI solutions
• Perform functional and regression testing across analytics components
• Ensure end-to-end data validation and source-to-report accuracy
• Establish and enforce a formal QA gate and provide release sign-off
• Manage defects using standard tools and collaborate with developers for timely resolution
• Assess downstream impacts of data model changes on dependent reports and dashboardsDevelop and maintain reusable test assets, including regression test suites and data validation scripts

Disclaimer: AI may be used in evaluating candidates.

This posting is for an existing vacancy.