Quality Assurance (QA) Analyst

Raise - find a more meaningful working experience; Burnaby; Híbrido; CAD 69.000 - 83.000; Jornada completa

Descripción de la vacante

Ian Martin Group is partnering with a public-sector client to hire a QA Analyst who will establish, mature, and sustain a formal QA function for Power BI reports, dashboards, data models, and related analytics products supporting Liquid Waste Services.

You will lead end-to-end data validation, quality gates, and defect management, collaborating with BI developers to ensure accuracy, traceability, and regulatory alignment, while maintaining release governance in a hybrid Burnaby, BC role.

Formación

• 4+ years of QA/BI QA experience in enterprise environments.
• Experience testing Power BI dashboards, reports, and data models.
• Experience validating data across complex pipelines (SQL Server, ETL, semantic models).

Responsabilidades

• Establish formal QA function for Power BI solutions, data models, and analytics products.
• Develop QA standards, templates, release checklists, and quality gates.
• Perform functional and regression testing across analytics components (SQL Server, ETL, semantic models).
• Execute end-to-end data validation and source-to-report reconciliation.
• Log, track, and manage defects using Azure DevOps/Jira and coordinate fixes.

Conocimientos

SQL queries

Power BI

DAX

Data modeling

QA standards

Azure DevOps

Jira

Regression testing

Educación

Bachelor's Degree in Computer Science or related

Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)

ISTQB Certified Tester – Foundation/Advanced

Agile/DevOps Certifications: CSM or AZ-900

Herramientas

Azure DevOps

Jira

Descripción del empleo

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

• 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
• Agile/DevOps Certifications: Certified ScrumMaster (CSM) or Azure DevOps Engineer / Azure Fundamentals (AZ-900).

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/