Quality Assurance Analyst I

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

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

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

About CAE

At CAE, our mission is clear: to help make the world a safer place. For nearly 80 years, we’ve driven innovation in simulation, training, and mission readiness to support critical operations worldwide. By leveraging advanced technologies, we empower our customers to operate smarter, faster, and more sustainably. Join a purpose-driven organization where bold ideas are encouraged, collaboration drives progress, and your growth fuels our shared success.

Position Type

Regular

Equal Opportunity & Accommodations

CAE is committed to providing equal opportunities to all applicants, regardless of race, nationality, color, religion, sex, gender identity or expression, sexual orientation, disability, neurodiversity, veteran status, age, or other characteristics protected by law. We encourage applicants who may not meet every qualification to apply. Reasonable accommodations are available—contact your recruiter or email [e-mail] if needed.

Data Privacy

Privacy Statement | CAE As part of our process, we may use AI‑supported tools to help review applications, with human decision‑making at every step. CAE thanks all applicants for their interest. However, only those whose background and experience match the requirements of the role will be contacted.

Welcome to CAE

Welcome to CAE! As a global leader in Civil Aviation and Defense & Security across 40 countries, we advance together as One CAE, fueled by thousands of passionate individuals operating in a culture where everyone can thrive. We hold ourselves accountable for building an inclusive community at every level, and our comprehensive benefits support you professionally and personally. Together, we are All For shaping a future where safety, sustainability, and inclusivity lead the way. Join us and be part of something bigger—where your impact reaches beyond CAE and helps shape the world of tomorrow.