QA Analyst (ID#5600)

New Value Solutions; British Columbia; On-site; CAD 34,000 - 55,000; Part time

Job summary

New Value Solutions is seeking a part-time Quality Assurance Analyst to establish and maintain QA for Power BI reports, dashboards, data models, and analytics products. You will develop QA standards, testing practices, and release controls to ensure accurate reporting for business operations and compliance.

The role emphasizes testing across Power BI solutions, SQL Server data validation, and collaboration with cross-functional teams to govern releases and ensure data integrity.

Qualifications

• Knowledge of QA testing for Power BI reports, dashboards, semantic models, and analytics products.
• Experience with functional, regression, and end-to-end testing.
• Strong SQL and data querying skills across SQL Server, ETL pipelines, and reports.
• Familiarity with data modeling concepts (relationships, measures, star/snowflake schemas).
• Understanding of DAX for validating measures and calculations.

Responsibilities

• Develop and execute test strategies, plans, cases, regression suites, and release checklists for Power BI solutions.
• Perform functional, regression, and end-to-end testing of reports, dashboards, and data models.
• Validate source-to-report data accuracy across SQL Server, ETL pipelines, semantic models, and Power BI reports.
• Establish and maintain QA standards, templates, testing methodologies, and release governance.
• Identify and track defects using Azure DevOps or Jira; collaborate with developers to resolve issues.
• Validate fixes and support release sign-off before production deployment.
• Assess impact of data model changes on reports/dashboards and data integrity.
• Review requirements, user stories, acceptance criteria, and reporting specs for testability.
• Develop reusable test assets and data validation scripts; identify opportunities for automation.
• Communicate quality findings, risks, and recommendations to teams and stakeholders.

Skills

Power BI testing

SQL queries

Data validation

Azure DevOps

Jira

Test management

Communication

Attention to detail

Tools

Power BI

DAX knowledge

Job description

New Value Solutions, a national IT consulting company, is seeking a part-time Quality Assurance Analyst to establish and maintain a formal QA function for Power BI reports, dashboards, data models, and related analytics products. The successful candidate will develop QA standards, testing practices, and release controls to support accurate, reliable reporting for business operations, compliance, resource planning, and performance management.

Responsibilities:

• Develop and execute test strategies, test plans, test cases, regression test suites, and release checklists for Power BI solutions.
• Perform functional, regression, and end-to-end testing across reports, dashboards, and data models.
• Validate source-to-report accuracy across SQL Server, ETL pipelines, semantic models, and Power BI reports.
• Establish and maintain QA standards, templates, testing methodologies, quality gates, and release governance processes.
• Identify, document, prioritize, and track defects using Azure DevOps or equivalent tools; collaborate with developers to resolve issues.
• Validate fixes and support release sign-off before production deployment.
• Assess the impact of data model changes on dependent reports and dashboards, including data integrity and consistency across shared models.
• Review business requirements, user stories, acceptance criteria, and reporting specifications for completeness, clarity, testability, and alignment with business rules and reporting needs.
• Develop reusable test assets and data validation scripts, and identify opportunities for test automation and improved testing efficiency.
• Communicate quality findings, risks, and recommendations to technical teams and business stakeholders.

Requirements:

• Experience performing quality assurance testing for Power BI reports, dashboards, semantic models, and related analytics products.
• Strong understanding of data validation and testing methodologies, including functional, regression, and end-to-end testing.
• Strong SQL and data querying skills, with experience validating data across SQL Server, ETL pipelines, semantic models, and reports.
• Knowledge of data modelling concepts, including relationships, measures, star schemas, and snowflake schemas.
• Understanding of DAX for validating measures and calculations.
• Experience with data profiling and data quality assessment, including identifying inconsistencies, anomalies, and downstream impacts of data changes.
• Experience using test management and defect tracking tools such as Azure DevOps or Jira.
• Strong analytical, root cause analysis, risk assessment, and communication skills, with a structured approach and strong attention to detail.
• Ability to translate stakeholder requirements into measurable QA criteria and explain quality findings in non-technical language.
• Ability to collaborate effectively with business and technical teams, work with minimal supervision, and maintain confidentiality.
• Power Query (M) and Microsoft Fabric experience preferred.

If you have the necessary expertise and are able to work in Canada, While we thank all candidates in advance for their application, only those shortlisted will be contacted.