Quality Assurance

Quality Assurance (QA) Analyst

• Pay Rate: $50.00 – $60.00/hour, depending on experience
• Contract: for a one-year term
• The role is expected to require approximately 20 hours per week minimum, although actual hours may vary based on project requirements and business needs
• Location: Burnaby, British Columbia -This is a hybrid role, combining remote work with regular in-office attendance.

Raise is currently hiring a Quality Assurance (QA) Analyst on behalf of our client. They're expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader. Our Client,a partnership of 12 municipalities - one Electoral Area and one treaty First Nation. That collaboratively plans for and delivers regional-scale services with its core services being drinking water, wastewater treatment and solid waste management.

Note: The primary pay rate is based on T4 classification; however, we will also consider applications from candidates interested in an INC classification, where applicable.

Description

Quality Assurance (QA) Analyst in this role will establish, mature, and sustain a formal QA function for Power BI reports, dashboards, data models, and related analytics products supporting the Liquid Waste Services Business and Improvement Team.

In this role, you will lead the development and execution of end-to-end data validation frameworks, quality gates, defect management, and release governance. Working closely with business units and technical teams, you will ensure analytics solutions are accurate, reliable, traceable, auditable, and fully aligned with operational decision-making, regulatory compliance, resource planning, and key performance indicator (KPI) monitoring.

Responsibilities

Key responsibilities

• 1. QA Strategy, Governance & Process Standardization
• Establish and mature a formal QA function for Power BI solutions, data models, and downstream analytics products.
• Develop, document, and implement QA standards, templates, methodologies, release checklists, and formal quality gates prior to production deployment.
• Standardize QA practices and introduce repeatable testing frameworks, reusable test assets, and regression suites to improve reporting reliability and reduce rework.
• Identify and recommend opportunities for test automation, reusable validation scripts, and continuous QA process improvements.
• 2. Functional, Regression & Data Quality Testing
• Develop and execute comprehensive test strategies, test plans, and test cases tailored to complex Power BI analytics environments.
• Perform functional and regression testing across all analytics components (SQL Server, ETL pipelines, semantic models, reports, and dashboards).
• Execute end-to-end data validation and source-to-report reconciliation to confirm data accuracy, completeness, consistency, and traceability.
• Validate data integrity across shared Power BI semantic models and downstream reports, assessing the impact of model changes on dependent assets.
• Profile data to detect anomalies, inconsistencies, missing values, and data quality risks.
• 3. Defect Management & Developer Collaboration
• Log, document, prioritize, track, and manage defects through resolution using standard ALM/test management tools (e.g., Azure DevOps).
• Collaborate directly with BI developers and data engineers to facilitate timely defect resolution and re-test fixes prior to release sign-off.
• 4. Requirements Validation & Business Alignment
• Review business requirements, user stories, acceptance criteria, and reporting specifications for clarity, completeness, testability, and alignment with operational goals.
• Verify that dashboards and reports accurately reflect approved business rules, operational processes, regulatory obligations, and KPI calculations.
• Identify data quality, process, or reporting gaps that impact compliance, resource allocation, or operational efficiency, and propose actionable mitigation strategies.
• Key Deliverables
• QA Framework & Governance: QA standards, test strategy documents, release checklists, and quality gate guidelines.
• Test Documentation: Detailed test plans, test cases, test execution logs, and acceptance validation records for Power BI products.
• Data Validation & Regression Assets: Source-to-target reconciliation scripts (SQL/DAX), reusable validation suites, and regression test repositories.
• Defect Management & Reporting: Documented defect logs, root-cause summaries, and release sign-off recommendations in Azure DevOps/Jira.
• Requirements Traceability Matrix (RTM): Mapping of business requirements and regulatory criteria to test cases and validation results.

Qualifications