Intermediate Quality Assurance (QA) Analyst (5+) to establish and govern QA for analytics reporting
- Contractor
Our public sector client is seeking an Intermediate Quality Assurance (QA) Analyst (5+) to establish and govern QA for analytics reporting using Power BI and SQL
Lead the build-out of a formal QA function for Power BI analytics that underpins business operations, regulatory compliance, resource planning, and performance management. Scope includes defining QA standards, templates, quality gates, and release governance, plus structured test planning, functional/regression testing, end-to-end data validation, defect management, and release sign-off. Contract, hybrid role in Vancouver with an initial one-year term (option to extend), approximately 20 hours per week minimum, and a potential start as early as Dec 21, . Assignments will be offered based on project demand and resource requirements.
Contract, hybrid role in Vancouver with an initial one-year term (option to extend), approximately 20 hours per week minimum, and a potential start as early as Dec 21, . Assignments will be offered based on project demand and resource requirements.
Must Haves
- Data validation and testing methodologies for analytics reporting across Power BI
- SQL and data querying across SQL Server, ETL pipelines, and semantic models
- DAX for validating measures and calculations; data modeling concepts (semantic models, relationships, measures)
- Test management and defect tracking tools such as Azure DevOps and Jira
- Star schema and snowflake schema design; data profiling, data quality assessment, and downstream impact assessment of data/model changes
Nice to Have
- Power Query (M)
- Microsoft Fabric
Responsibilities
- Develop and execute test strategies, plans, and cases for Power BI solutions
- Perform functional and regression testing across analytics components
- Ensure end-to-end data validation and source-to-report accuracy
- Establish and enforce a formal QA gate and provide release sign-off
- Manage defects using standard tools and collaborate with developers for timely resolution
- Assess downstream impacts of data model changes on dependent reports and dashboards
- Develop and maintain reusable test assets, including regression test suites and data validation scripts