Quality Assurance (QA) Analyst

Affinity; Burnaby; Presencial; CAD 70.000 - 110.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Affinity Earn

Descripción de la vacante

Affinity is seeking a QA professional to establish and mature a formal QA function for Power BI reports, dashboards, data models, and related analytics products. You will create QA standards, templates, methodologies, quality gates, and release governance to ensure accurate, auditable reporting used for operations and compliance.

Responsibilities include test strategy development, functional and regression testing, end-to-end data validation, and collaboration with developers to ensure timely

Formación

• Experience applying QA methodologies to BI/reporting solutions.
• Familiarity with data validation from SQL/SsETL pipelines.
• Understanding of dimensional models and reporting requirements.
• Knowledge of test management tools and defect tracking.
• Ability to translate requirements into test criteria.

Responsabilidades

• Develop and execute test strategies and plans for Power BI solutions.
• Perform functional and regression testing across analytics components.
• Ensure end-to-end data validation from source to report.
• Establish formal QA gates prior to release and governance.
• Identify, document, and track defects using standard tools.
• Collaborate with developers to verify issue resolution and validation.
• Validate data integrity across shared Power BI models and reports.
• Assess impact of data/model changes on downstream reports.

Conocimientos

Data validation methodologies

QA testing

SQL and data querying

DAX understanding

Data modeling concepts

Regression testing

Test management

Attention to detail

Communication skills

Power BI

Herramientas

Azure DevOps

Jira

Power BI

Descripción del empleo

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.

Responsibilities

• 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.

Qualifications

• 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

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.

Affinity Earn

Know someone who's great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need. For more information on Affinity, please visit www.affinity-group.ca