Quality Assurance (QA) Analyst

Metro Vancouver is currently seeking a contract Quality Assurance (QA) Analyst for a one-year term to support the Liquid Waste Services Business and Improvement Team. The role will establish, mature, and sustain a formal QA function for Power BI reports, dashboards, data models, and related analytics products, including QA standards, templates, testing methodologies, quality gates, and release governance.

The assignment could start as early as December 21, 2026, depending on resource availability. The role is expected to require approximately 20 hours per week minimum, although actual hours may vary based on project requirements and business needs. This is a hybrid role, combining remote work with regular in-office attendance.

Key responsibilities include

• Developing and executing test strategies, test plans, test cases, and regression test suites
• Performing functional, regression, and end-to-end data validation testing
• Validating source-to-report accuracy across SQL Server, ETL pipelines, semantic models, and Power BI reports
• Establishing and enforcing a formal QA gate prior to release
• Identifying, documenting, prioritizing, and tracking defects using Azure DevOps or equivalent tools
• Validating fixes and supporting release sign-off before production deployment
• Assessing the impact of data model changes on dependent reports and dashboards
• Reviewing requirements, user stories, acceptance criteria, and reporting specifications to confirm they are clear, complete, and testable
• Developing reusable test assets, including regression suites and data validation scripts

The ideal candidate will have strong experience with

• Data validation and testing methodologies
• SQL and data querying
• Data modelling concepts (semantic models, relationships, measures)
• Test management and defect tracking tools (Azure DevOps, Jira)
• Data profiling and data quality assessment
• DAX for validating measures and calculations
• Star and snowflake schema design
• Preferred: Power Query (M) and Microsoft Fabric

Strong communication skills are also important, including the ability to work with business stakeholders and explain QA findings in non-technical language.

Submission details

Please submit up to two top candidate resumes, including reference checks, to 16:30 on Friday, November 13, 2026.

Please include

• Number of years and type of relevant experience
• Certifications
• Hourly rate
• Availability
• Maximum number of hours available each week, during and outside regular business hours
• Number of days available to come into the office (weekly or bi-weekly)

Candidates will be evaluated based on experience, skill set, and qualifications at 75%, and hourly rate at 25%. Metro Vancouver reserves the right to interview only the highest-ranked candidates. Resumes will not be reviewed until after the deadline.

Next steps

Interviews are expected to occur during the following two weeks, with a decision following shortly thereafter.

Job Description – Quality Assurance (QA) Analyst

Client

Metro Vancouver

Position Title

Quality Assurance (QA) Analyst

Date

November 2, 2026

Location

Burnaby, BC

Work Arrangement

Hybrid (Remote work with regular in-office attendance)

Expected Start Date

December 21, 2026

Contract Duration

Initial term of one year, subject to budget approval and project work availability, with the option to extend or terminate the contract as required.

Working Hours

Approximately 20 hours per week minimum, although actual hours may vary depending on project requirements and business needs.

Position Overview

Metro Vancouver is seeking statements of qualifications from qualified respondents for a contract Quality Assurance Analyst to provide quality assurance services in support of the Liquid Waste Services Business and Improvement Team. The successful respondent will be responsible for establishing, maturing, and sustaining a formal QA function for Power BI reports, dashboards, data models, and related analytics products that support business operations, regulatory compliance, resource planning, and performance management.

The services will include the development and implementation of QA standards, templates, methodologies, quality gates, and release governance processes to ensure reporting solutions are accurate, reliable, traceable, auditable, and suitable for business use. Working with Metro Vancouver business units, the successful respondent will gather, document, and validate business requirements to confirm that analytics solutions support operational decision-making, compliance obligations, efficient service delivery, resource optimization, and the monitoring and improvement of key performance indicators.

Through structured test planning, functional and regression testing, end-to-end data validation, defect management, validation of fixes, and release sign-off, the successful respondent will support improved release quality, reduced production defects, stronger compliance readiness, increased stakeholder confidence in business reporting, and measurable improvements in operational efficiency and business performance.

This assignment could start as early as Dec 21st, 2026, depending on resource availability. This position is intended to support project-specific initiatives, with assignments offered as required based on project demand and resource requirements. This position requires participation in a hybrid work environment, combining remote work with regular in-office attendance.

Key Responsibilities

The Quality Assurance Analyst will work in collaboration with the Business Strategy and Improvement Team to support reliable business operations, regulatory compliance, resource optimization, and the effective measurement and optimization of key performance indicators through the following activities:

• Develop and execute test strategies, plans, and cases for Power BI solutions, while maintaining QA standards, regression test suites, release checklists, and other core QA deliverables that support consistent, reliable, and business-ready reporting for operational, compliance, resource planning, and performance management purposes.
• Perform functional testing and regression testing across all analytics components to confirm reporting solutions remain reliable for business operations, compliance reporting, resource optimization, and KPI monitoring.
• Ensure end-to-end data validation, including source-to-report accuracy, to confirm that reporting outputs support operational decisions, regulatory and compliance reporting, resource planning, and KPI measurement and optimization.
• Establish and enforce a formal QA gate prior to release to support reliable business reporting, compliance readiness, and controlled deployment of operational analytics.
• Identify, document, prioritize, and track defects and issues using standard tools (e.g., DevOps or equivalent).
• Collaborate with developers to ensure timely resolution of defects.
• Validate fixes and confirm issues are resolved before production deployment.
• Validate data integrity and consistency across shared Power BI models and downstream reports to support accurate operational reporting, compliance requirements, resource planning, and KPI analysis.
• Assess the impact of changes to data models on dependent reports and dashboards, including potential effects on operational decision-making, regulatory compliance, resource planning, and KPI reporting.
• Ensure high standards of data accuracy, completeness, consistency, and traceability to support operational decision-making, regulatory compliance, audit readiness, resource allocation, and business performance reporting.
• Standardize QA practices and introduce repeatable testing frameworks and regression coverage to improve reporting reliability, reduce rework, and support efficient use of business and technical resources.
• Identify opportunities to improve testing efficiency, reduce rework, optimize resource use, and support more predictable delivery of reporting solutions that enable effective business operations and performance management.
• Review business requirements, user stories, acceptance criteria, and reporting specifications to ensure they are complete, clear, testable, and aligned with operational, regulatory, compliance, resource planning, and KPI reporting requirements.
• Validate that dashboards and reports accurately reflect approved business rules, operational processes, regulatory obligations, resource planning assumptions, and key performance indicators used to monitor service delivery and business performance.
• Support continuous improvement of business operations by identifying data quality, process, control, or reporting gaps that may affect compliance, resource allocation, operational efficiency, or KPI performance, and recommending mitigation or improvement opportunities.
• Identify and recommend opportunities for test automation, reusable validation scripts, and process improvements to support standardized and efficient QA practices.
• Develop and maintain reusable test assets, including regression test suites and data validation scripts, to improve testing consistency and coverage.

Technical Qualifications

The position requires the following technical qualifications to support reliable business operations, compliance reporting, resource optimization, and KPI performance management:

• Strong understanding of:
• Data validation and testing methodologies.
• SQL and data querying.
• Data modeling concepts (semantic models, relationships, measures).
• Experience with test management and defect tracking tools (e.g., Azure DevOps, Jira).
• Experience validating data from SQL Server, ETL pipelines, semantic models, and Power BI reports.
• Experience with data profiling and data quality assessment.
• Understanding of DAX (Data Analysis Expressions) for validating measures and calculations.
• Strong understanding of Star schema & snowflake schema design.
• Strong attention to detail with the ability to identify data inconsistencies and anomalies.
• Ability to assess downstream impacts of data/model changes.
• Structured and methodical approach to testing and validation.

Additional Preferred Qualifications

• Power Query (M).
• Microsoft Fabric.

Additional Skills and Competencies

Respondents should also demonstrate the ability to support business operations by:

• Establishing and maintaining effective working relationships with a variety of internal contacts and business unit owners to understand operational priorities, compliance needs, resource considerations, and performance reporting requirements.
• Documenting, analyzing, and assessing information from business units to identify priorities, resource requirements, operational risks, and opportunities to improve business processes.
• Applying strong analytical, communication, root cause analysis, and risk assessment skills to identify issues, mitigate operational and compliance risks, and support quality outcomes.
• Translating stakeholder requirements into measurable quality assurance criteria, controls, and validation processes to ensure solutions meet business needs, regulatory requirements, compliance standards, resource planning objectives, and KPI reporting expectations.
• Communicating effectively orally and in writing, including presenting proposals and quality findings in non-technical language that supports business decision-making.
• Performing assigned duties with minimal supervision, while working within provided direction to support timely delivery of business, compliance, and performance reporting objectives.
• Maintaining confidentiality when working with operational, compliance, resource planning, and performance reporting information.

Submission Requirements

Please submit your top candidate resumes (maximum 2), including reference checks to:

• Anish.Pokhrel@metrovancouver.org
• Allison.Burton@metrovancouver.org

Please include the following

• Number of years and type of experience.
• Certifications.
• Hourly rate.
• Availability.
• Maximum number of hours available to work each week during business hours and outside regular business hours.
• No of days available to come into office (weekly or bi-weekly).

Candidate Evaluation Criteria

Candidates are evaluated as follows

• Experience, skill set, and qualifications – 75%.
• Hourly Rate – 25%.

The corporation reserves the right to request interviews with only those candidates with the highest-ranked resumes following an evaluation in all other categories.

Resumes will not be reviewed until after the cut-off so please take your time to select the candidates that you believe best fit the position requirements.

Important Dates

• Resume Submission Deadline: 16:30 on Friday, November 13th, 2026.
• Interview Timeline: Interviews are expected to occur during the following two weeks with a decision following shortly thereafter.