Explore more
About the role
- 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.
Requirements
- 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).
Benefits
- Remote Job 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Power BIDAXSQLdata modelingstar schemaSnowflakeRow-Level Security (RLS)QA documentationtest casesperformance testing