Job Description

On behalf of our public sector client, Affinity is seeking a Business Intelligence 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.

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

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

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

Job Number: 13697