Quality Assurance (QA) Analyst

Job Summary

We are seeking an experienced Quality Assurance (QA) Analyst - Power BI Data Analytics for a one-year contract to establish, develop, and maintain a formal QA function for Power BI reports, dashboards, data models, and related analytics products. The successful candidate will be responsible for developing and executing comprehensive test strategies, test plans, test cases, and regression test suites to ensure the accuracy, reliability, consistency, and quality of reporting solutions. The role involves performing functional, regression, and end-to-end data validation testing across SQL Server databases, ETL pipelines, semantic models, and Power BI reports, including validating source-to-report accuracy, data integrity, completeness, and consistency. The candidate will establish QA standards, templates, testing methodologies, quality gates, and release governance processes, identify and manage defects using Azure DevOps, Jira, or equivalent tools, collaborate with technical teams to validate fixes, and support release sign-off before production deployment. The role also requires assessing the downstream impact of data model changes on dependent reports and dashboards, validating DAX measures and calculations, reviewing business requirements, user stories, acceptance criteria, and reporting specifications, and developing reusable regression test suites and data validation scripts. The ideal candidate will have strong experience in SQL, Power BI testing, ETL validation, data profiling, data quality assessment, semantic models, relationships, measures, and Star and Snowflake Schema design. Experience with Power Query (M) and Microsoft Fabric is considered an asset. Strong analytical, problem-solving, root cause analysis, and communication skills are essential, along with the ability to translate business requirements into measurable QA criteria, communicate technical findings to non-technical stakeholders, and work independently with minimal supervision. This is a hybrid contract opportunity based in Burnaby, requiring approximately 20 hours per week minimum, with an initial contract term of one year.

Responsibilities

• Developing and executing comprehensive test strategies, test plans, test cases, and regression test suites to ensure the accuracy, reliability, consistency, and quality of reporting solutions.
• Performing functional, regression, and end-to-end data validation testing across SQL Server databases, ETL pipelines, semantic models, and Power BI reports, including validating source-to-report accuracy, data integrity, completeness, and consistency.
• Establishing QA standards, templates, testing methodologies, quality gates, and release governance processes.
• Identifying and managing defects using Azure DevOps, Jira, or equivalent tools.
• Collaborating with technical teams to validate fixes, and supporting release sign-off before production deployment.
• Assessing the downstream impact of data model changes on dependent reports and dashboards, validating DAX measures and calculations, reviewing business requirements, user stories, acceptance criteria, and reporting specifications, and developing reusable regression test suites and data validation scripts.

Requirements

• Power BI Report Dashboard Testing
• SQL Server SQL Data Querying
• ETL Pipeline Testing
• End-to-End Data Validation
• Source-to-Target Data Reconciliation
• Data Quality Assessment Data Profiling
• DAX Measures Calculations Validation
• Power BI Semantic Models Relationships
• Star Schema Snowflake Schema
• Functional, Regression Integration Testing
• QA Test Strategy, Test Plans Test Case Development
• QA Framework Quality Gate Establishment
• Azure DevOps / Jira - Test Defect Management
• Defect Tracking, Retesting Release Sign-off
• Data Integrity, Accuracy Consistency Validation
• Data Model Impact Analysis
• Business Requirements Acceptance Criteria Review
• Test Automation Reusable Data Validation Scripts
• Power Query (M) - Preferred
• Microsoft Fabric - Preferred

Qualifications

• The ideal candidate will have strong experience in SQL, Power BI testing, ETL validation, data profiling, data quality assessment, semantic models, relationships, measures, and Star and Snowflake Schema design.
• Experience with Power Query (M) and Microsoft Fabric is considered an asset.
• Strong analytical, problem-solving, root cause analysis, and communication skills are essential, along with the ability to translate business requirements into measurable QA criteria, communicate technical findings to non-technical stakeholders, and work independently with minimal supervision.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.