Validate the accuracy, reliability, and governance compliance of Power BI dashboards and semantic models.
Validate KPIs and calculations against Snowflake source data.
Reconcile aggregates, filters, and dimensional logic to ensure data accuracy.
Test drill-through functionality, slicer interactions, and filter propagation.
Identify discrepancies between report logic and documented business requirements.
Document validation outcomes and report defects.
Review semantic models for adherence to star schema and snowflake schema standards.
Validate DAX calculations, ensuring correctness and edge-case coverage.
Conduct regression testing for dashboard enhancements and model updates.
Identify performance bottlenecks at the report and semantic model level.

5+ years of experience working with Power BI (development or QA).
Strong understanding of data modeling concepts, especially star schema design.
Advanced knowledge of DAX, including context transition and time intelligence.
Strong SQL skills for source-to-report data validation and reconciliation.
Experience validating dashboards connected to Snowflake or other cloud data warehouses.
Experience testing Row-Level Security (RLS) and Power BI App Audience configurations.
Familiarity with Dev/Test/Prod deployment workflows.
Experience working within structured QA or testing processes.
Prior experience in BI Quality Assurance or Data QA roles (preferred).
Exposure to dbt-based data transformation environments (preferred).
Familiarity with CI/CD pipelines and automated release workflows (preferred).
Experience in Power BI dataset performance testing and optimization (preferred).
Experience creating and maintaining test cases, QA documentation, and validation artifacts (preferred).

BI QA Engineer

Key skills