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
4+ years of dedicated experience as a QA Analyst, Data Quality Analyst, or Business Intelligence QA Specialist.
Proven track record of testing enterprise BI solutions, specifically Power BI dashboards, reports, and data models.
Demonstrated experience validating data across complex pipelines (SQL Server, ETL, semantic models, data warehouses).
Hands-on experience establishing QA standards, quality gates, and regression test suites for analytics products.
Experience in public sector, municipal utilities, liquid waste, or high-governance/regulatory environments is considered a strong asset.
Technical Skills
Advanced proficiency in writing SQL queries for source-to-target data reconciliation, aggregation, and validation.
Deep knowledge of Power BI architecture, data modeling (Star and Snowflake schemas), semantic model relationships, and measures.
Strong working knowledge of DAX to validate calculations, measures, and complex business logic.
Proficient with Azure DevOps (ADO) or Jira for logging, tracking, and managing defects and user stories.
Experience assessing data completeness, accuracy, lineage, and downstream change impacts.
Preferred Technical Extras: Experience with Power Query (M) and Microsoft Fabric environment is highly desirable.
Soft Skills & Core Competencies
Exceptional precision in spotting data anomalies, logic discrepancies, and downstream impacts.
Ability to build strong working relationships with technical teams and non-technical business owners.
Skill in translating complex business/regulatory requirements into testable quality criteria.
Clear verbal and written communication skills; ability to present technical findings in plain language to support decision-making.
Autonomy & Discretion: Ability to work effectively with minimal supervision in a hybrid environment while maintaining confidentiality of sensitive operational data.
Education and certifications
Bachelor’s Degree in Computer Science, Data Analytics, Software Engineering, Information Technology, Business Information Systems, or a related quantitative field.
Microsoft Certified: Power BI Data Analyst Associate (Exam PL-300)
Microsoft Certified: Fabric Analytics Engineer Associate (Exam DP-600)
ISTQB Certified Tester – Foundation Level (CTFL) or Advanced Level Test Analyst
NOTE: Candidates will be required to provide 2 professional referernces in order to be considered for this role at the time of application
Looking for meaningful work? We can help!
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or any other Raise job posting (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com.
#WES
Ready to apply for Quality Assurance (QA) Analyst?
Opens Raise’s official LinkedIn application page in a new tab. No TargetQA account required.
