Job Description:
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, British Columbia, requiring approximately 20 hours per week minimum, with an anticipated start date of December 21, 2026, and an initial contract term of one year.
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
