Quality Assurance (QA) Analyst

• 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

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

Job Number: 14133