Data Quality Analyst – Power BI & Microsoft Fabric

CAE Inc; Montreal (administrative region); On-site; CAD 70,000 - 90,000; Full time

Benefits offered by this job

Group Insurance

Telemedicine and EAP

Group RRSP CAE Pension Plan/Defined DB

Sabbatical Leave

Flex Time

Enhanced Parental Leave

Job summary

CAE is seeking a Data Quality Analyst to validate data products on the Microsoft Fabric platform and ensure alignment with governance standards. The role emphasizes end-to-end testing across the Medallion architecture (Bronze, Silver, Gold) and collaboration with business and technical teams to secure trusted analytics outputs.

Responsibilities include validating data from source to Power BI, testing reports, managing defects, and driving continuous improvement to ensure data accuracy,

Qualifications

• Bachelor’s degree in computer science, Engineering, or related field.
• 3+ years of experience in data QA, data validation, or analytics testing.
• Experience with Python, SQL is a requirement
• Experience with software development lifecycle management (e.g., Git and version control).
• Strong understanding of data warehousing concepts (Medallion architecture)
• Experience with Microsoft Fabric and Azure.
• Hands-on experience with Power BI (validation/testing perspective)
• Familiarity with data governance concepts

Responsibilities

• Ensure data products align with business goals (GQM) and are fully traceable from source to Power BI.
• Validate data quality across bronze, silver, and gold layers, and confirm Fabric data products are complete, reliable, and production ready.
• Test Power BI reports end-to-end to ensure accurate visuals and metrics.
• Enforce governance standards using Purview, including metadata, lineage and quality scoring.
• Develop and execute test plans, validate performance and refresh reliability, and manage defects by working with teams to identify root causes.
• Continuously provide quality insights to improve data reliability and strengthen trust in analytics.

Job description

CAE is seeking a Data Quality Analyst to validate data products on the Microsoft Fabric platform and ensure alignment with governance standards. The role emphasizes end-to-end testing across the Medallion architecture (Bronze, Silver, Gold) and collaboration with business and technical teams to secure trusted analytics outputs.

Responsibilities include validating data from source to Power BI, testing reports, managing defects, and driving continuous improvement to ensure data accuracy,