Full Description

BI Quality Assurance & Data Quality Engineer (Microsoft Fabric & Power BI)

Role Summary

We are looking for a skilled BI Quality Assurance & Data Quality Engineer to support and strengthen BI quality practices within a Microsoft Fabriccentric analytics environment. This role will focus on validating data accuracy, testing Power BI reports and semantic models, and building automation to ensure reliable and trusted analytics delivery.

The ideal candidate has hands-on experience in BI testing, SQL-based validations, and Power BI semantic model testing, with exposure to automation frameworks and data quality practices.

Key Responsibilities

BI QA & Data Validation

Perform end-to-end BI testing across data ingestion, transformation, semantic models, and reporting layers. Validate Power BI datasets, reports, dashboards, and DAX measures. Ensure consistency of KPIs and metrics across dashboards and reporting periods. Execute reconciliation checks between source systems and BI outputs. Support release validation and production readiness checks for BI assets.

Data Quality Assurance

Perform data quality validations including accuracy, completeness, consistency, and timeliness checks. Execute SQL-based validation queries across Fabric SQL, Lakehouse, or Azure SQL environments. Identify and troubleshoot data discrepancies and work with Data Engineering and BI teams for resolution.

Automation & Tooling

Develop and maintain automated validation scripts using SQL and Python (or similar scripting languages). Support implementation of BI automation testing (including UI validations such as filters, slicers, and drill-through scenarios). Contribute to integrating BI QA checks into CI/CD pipelines. Assist in creating reusable validation frameworks and regression test packs for high-impact dashboards.

Microsoft Fabric & Power BI Support

Work within Microsoft Fabric components such as OneLake, Lakehouse, Dataflows, and Semantic Models. Validate data transformations and ensure proper logic implementation in reports. Leverage metadata and lineage tools for traceability and root-cause analysis.

Collaboration & Communication

Partner with BI developers and data engineers to ensure high-quality deliverables. Document test cases, validation results, and data quality findings. Participate in requirement reviews to identify test scenarios early in the lifecycle.

Required Qualifications

47 years of experience in BI testing, data quality, or analytics validation roles. Strong experience with Power BI (reports, datasets, DAX validation). Proficiency in SQL (advanced querying, joins, aggregations, reconciliation). Experience testing data pipelines and transformations. Exposure to automation scripting (Python or similar). Understanding of BI release cycles and production validation processes.