Establish and run a formal QA function for Power BI reports, semantic models, and analytics solutions. Develop QA standards, test methodologies, quality gates, and release governance. Validate data from SQL Server, ETL pipelines, and Power BI, perform data profiling, DAX verification, impact analysis, and collaborate with stakeholders and developers to ensure accurate, auditable, and business-ready reporting.
We are seeking an experienced Quality Assurance (QA) Analyst to establish, mature, and sustain a formal QA function supporting Power BI reports, dashboards, data models, and analytics solutions. The successful candidate will be responsible for ensuring reporting solutions are accurate, reliable, traceable, auditable, and suitable for business use. This role involves developing and implementing QA standards, methodologies, templates, quality gates, and release governance processes while working closely with business stakeholders, developers, and data teams to support operational decision-making, regulatory compliance, resource planning, and performance management.
Requirements
Required Qualifications
- Strong understanding of data validation and testing methodologies.
- Hands-on experience with SQL and data querying.
- Solid understanding of data modeling concepts including semantic models, relationships, and measures.
- Experience with test management and defect tracking tools such as Azure DevOps or Jira.
- Experience validating data from SQL Server databases, ETL pipelines, semantic models, and Power BI reports.
- Knowledge of data profiling and data quality assessment techniques.
- Understanding of DAX (Data Analysis Expressions) for validating measures and calculations.
- Strong knowledge of Star Schema and Snowflake Schema design principles.
- Exceptional attention to detail with the ability to identify data inconsistencies and anomalies.
- Ability to evaluate downstream impacts of changes to data models and reporting solutions.
- Structured and methodical approach to testing and validation activities.
Preferred Qualifications
- Experience with Power Query (M).
- Experience with Microsoft Fabric.
- Experience with test automation and data validation scripting.
- Experience supporting enterprise analytics or business intelligence environments.
Required Skills
- Analytical and problem-solving skills.
- Root cause analysis and risk assessment capabilities.
- Excellent verbal and written communication skills.
- Ability to translate business requirements into measurable QA criteria and validation processes.
- Strong stakeholder management and collaboration skills.
- Ability to work independently with minimal supervision while managing multiple priorities.
- Experience presenting technical findings to non-technical stakeholders.
- Ability to maintain confidentiality when working with sensitive business information.
Similar Jobs
Legal Tech
Own the full QA lifecycle for AI-powered legal solutions: design and run unit, integration, system, performance, and scalability tests; integrate automated test suites into Azure DevOps CI/CD; generate and evaluate AI-assisted test cases; track defects and quality metrics; and collaborate on security and reliability testing.
Top Skills:
Ai-Assisted Test Generation ToolsAutomated Test FrameworksAzure DevopsCi/Cd PipelinesLlms (Ai Platforms)Load Testing Tools
Healthtech • Professional Services • Pharmaceutical • Telehealth
Support laboratory operations and QA by maintaining logs, schedules, specimen handling, basic sample prep, documentation, send-outs, inventory, SOP/document control, data entry, and customer support for clinical lab workflows.
Top Skills:
ApvxExcelMs WordOnco EmrOutlookPowerPoint
Information Technology • Insurance • Professional Services • Software
Mid-level QA Analyst embedded on Agile product teams to create and execute manual and automated tests, write SQL to validate data, document and verify defects, support UAT with clients, participate in sprint ceremonies, and improve QA processes and standards.
Top Skills:
Agile/ScrumAutomation FrameworksAzure DevopsSQLTest AutomationWeb Browsers
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.
