Analyste, Assurance qualité l

CAE; Montreal (administrative region); On-site; CAD 80,000 - 110,000; Full time

Benefits offered by this job

Group Insurance

Telemedicine and Employee and Family 1

Group RRSP

CAE Pension Plan/Defined Benefit Plan

Sabbatical Leave

Flex Time

Enhanced Parental Leave

Job summary

CAE is seeking a Data Quality Analyst to ensure data products on the Microsoft Fabric platform are accurate, reliable, and aligned with business goals via the GQM model. You will validate data across Bronze, Silver, and Gold layers and apply the Data Platform Coding Framework for end-to-end testing.

You will bridge business and technical teams, manage defects, verify performance, and drive improvements to ensure analytics outputs are trusted, auditable, and support data-driven decisions.

Qualifications

• Bachelor’s degree in computer science, Engineering, or related field.
• 3+ years of experience in data QA, data validation, or analytics testing.
• Proficiency in Python and SQL.
• Experience with modern SDLC tools (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 traceable from source to Power BI.
• Validate data quality across bronze, silver, and gold layers; confirm Fabric data products are complete and production ready.
• Test Power BI reports end-to-end for 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 with teams.
• Provide quality insights to improve data reliability and trust in analytics.

Skills

Python

SQL

Data QA

Data validation

Power BI

Git

Version control

Data warehousing

Medallion architecture

Microsoft Fabric

Azure

Education

Bachelor’s degree in computer science, Engineering, or related field

Tools

Git

Power BI

Microsoft Fabric

Azure

Job description

À propos de CAE

À CAE, notre mission est claire : contribuer à rendre le monde plus sécuritaire. Depuis près de 80 ans, nous faisons progresser l’innovation en simulation, en formation et en préparation aux missions afin de soutenir des opérations critiques partout dans le monde. Grâce à des technologies avancées, nous aidons nos clients à travailler plus intelligemment, plus rapidement et de façon plus durable. Joignez‑vous à une organisation guidée par sa raison d’être, où les idées audacieuses sont encouragées, où la collaboration fait avancer les choses et où votre développement alimente notre réussite commune.

À propos de ce poste

Who We Are

• CAE Vision: Our vision is to be the worldwide partner of choice in defense and security, and civil aviation by revolutionizing our customers’ training and critical operations with digitally immersive solutions to elevate safety, efficiency and readiness.
• CAE Defense & Security Mission: CAE's Defense and Security business unit focuses on helping prepare military customers to develop and maintain the highest levels of mission readiness.
• CAE Values: Empowerment, Innovation, Excellence, Integrity and OneCAE make us who we are, and we strive to make a difference in the world while helping each other succeed.

Summary

The Data Quality Analyst is responsible for ensuring that all data products delivered on the Microsoft Fabric platform are accurate, reliable, and fully aligned with business objectives defined through the Goal–Question–Metrics (GQM) model. This role validates data quality across the Medallion architecture (Bronze, Silver, and Gold) by applying CAE’s Data Platform Coding Framework to perform end-to-end testing of data acquisition flows. It also ensures that data products comply with governance standards through Microsoft Purview, including the evaluation of metadata, lineage, and data security controls.

Acting as a key bridge between business and technical teams, the Data Quality Analyst manages defects, verifies performance and data integrity, and drives continuous improvement to ensure that analytics outputs are trusted, auditable, and enable effective data-driven decision-making.

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.

Minimum 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 (eg: 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

Technical Skills

• Python, SQL and data validation techniques
• Data quality frameworks (accuracy, completeness, consistency, timeliness)
• ETL/ELT pipeline validation
• Power BI testing and data reconciliation
• Testing methodologies (functional, integration, regression)

Nice-to-Have

• Experience with Goal–Question–Metrics (GQM) methodology
• Exposure to data mesh / data product approach
• Familiarity with Microsoft Purview governance capabilities
• Experience in regulated environments (e.g., defense, aviation, public sector)

What You’ll Bring

• Attention to detail and strong data validation mindset
• Ability to translate business requirements into testable scenarios
• Strong collaboration with end-users, data engineers, data analysts, and governance teams
• Ownership mindset for data quality and trust

Benefits

• Group Insurance
• Telemedicine and Employee and Family Assistance Program
• Group RRSP
• CAE Pension Plan/Defined Benefit Plan
• Sabbatical Leave
• Flex Time
• Enhanced Parental Leave

À propos de CAE

À CAE, notre mission est claire : contribuer à rendre le monde plus sécuritaire. Depuis près de 80 ans, nous faisons progresser l’innovation en simulation, en formation et en préparation aux missions afin de soutenir des opérations critiques partout dans le monde. Grâce à des technologies avancées, nous aidons nos clients à travailler plus intelligemment, plus rapidement et de façon plus durable. Joignez‑vous à une organisation guidée par sa raison d’être, où les idées audacieuses sont encouragées, où la collaboration fait avancer les choses et où votre développement alimente notre réussite commune.

Type d'emploi

Régulier

Égalité des chances et mesures d’adaptation

CAE s’engage à offrir des chances égales à tous les candidats, sans égard à la race, à la nationalité, à la couleur, à la religion, au sexe, à l’identité ou à l’expression de genre, à l’orientation sexuelle, au handicap, à la neurodiversité, au statut d’ancien combattant, à l’âge ou à toute autre caractéristique protégée par la loi. Nous encourageons les personnes qui ne répondent pas à tous les critères à poser leur candidature. Des mesures d’adaptation raisonnables sont offertes au besoin — communiquez avec votre recruteur ou écrivez à CAECarrieres‑[e-mail].

Protection des données

Nous utilisons parfois des outils appuyés par l’IA pour soutenir l’évaluation des candidatures, tout en gardant une prise de décision entièrement humaine. CAE remercie tous les candidats de leur intérêt. Toutefois, seules les personnes dont le profil et l’expérience répondent aux exigences du poste seront contactées.