Quality Assurance (QA) Analyst

Workiy; Burnaby; Híbrido; CAD 70.000 - 110.000; A tiempo parcial

Descripción de la vacante

Workiy is seeking an experienced QA Analyst focused on Power BI and data analytics for a one-year hybrid contract in Burnaby. The role requires establishing a formal QA function, designing test strategies, and executing comprehensive regression suites to ensure accuracy and reliability of Power BI reports and data models.

The ideal candidate will have strong SQL, ETL validation, DAX validation, and data quality skills, with experience in Azure DevOps or Jira for defect tracking and release

Formación

• Experience testing Power BI reports, dashboards, and data models with SQL and ETL validation.
• Ability to design and execute QA strategies, test plans, and regression suites.
• Strong data profiling, data quality assessment, and data integrity skills.

Responsabilidades

• Establish and maintain a formal QA function for Power BI analytics.
• Develop and execute test strategies, plans, cases, and regression suites.
• Perform end-to-end data validation across SQL Server, ETL pipelines, and Power BI outputs.
• Validate source-to-report accuracy, data integrity, and consistency.
• Govern releases with defect management and validation of fixes.

Conocimientos

Power BI testing

SQL data querying

ETL testing

Data validation

DAX measures validation

Data modeling (semantic models)

Test automation

Defect management

Herramientas

Azure DevOps

Jira

Power Query (M)

Microsoft Fabric

Descripción del empleo

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