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: CAEs 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.

What We Have to Offer:

• Comprehensive and competitive benefits package and flexibility that promotes work-life balance

• A work environment where all employees are valued respected and safe

• Freedom to succeed by enabling team members to deliver take initiatives and make decisions

• Recognition professional development advancement and having fun!

Summary

We are seeking an experienced Data Engineer to join our data architecture team and help expand and optimize our modern data lakehouse environment. This role is ideal for someone who thrives in a Microsoftcentric ecosystem and has deep handson experience with Azure Data Factory Snowflake dbt and SQLdriven data engineering. You will collaborate with DBAs analysts and business stakeholders to design scalable data pipelines improve data quality and support enterprise analytics across our cloud data platform.

Essential Duties and Responsibilities

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Build enhance and maintain scalable data pipelines using Azure Data Factory

• Develop test and optimize dbt models for Snowflake and Azurebased lakehouse workloads

• Engineer ingestion transformation and orchestration workflows across Azure Data Lake Storage

• Implement best practices for Snowflake performance tuning cost optimization and data modeling

• Integrate SQL Server data sources and collaborate with DBAs on operational data flows

• Write highquality SQL Python and PowerShell to automate and improve data workflows

• Monitor pipeline performance troubleshoot issues and ensure data reliability and SLA adherence

• Partner with business teams to translate data requirements into robust engineering solutions

• Contribute to data governance documentation and metadata management initiatives

• Participate in code reviews and help establish engineering standards and reusable patterns

Qualifications and Education Requirements

This candidate should have a BS in computer science information technology or related technical/engineering field.

• 3 years of professional experience in data engineering or a related field

• Strong expertise with Azure Data Factory (pipelines triggers integration runtimes) and other

• Handson experience with Snowflake (warehousing Snowpipe RBAC performance tuning)

• Proficiency with dbt (models tests macros documentation)

• Advanced SQL skills and experience working with large complex datasets

• Experience with Azure Data Lake Storage and modern Data Lakehouse architecture

• Scripting experience with Python and/or PowerShell

• Solid understanding of ETL/ELT patterns data modeling and CI/CD workflows

Preferred Skills

• Experience working in Azure GCCHigh IL5 or other highersecurity cloud environments

• Familiarity with SQL Server administration concepts or collaboration with DBA teams

• Experience with Azure DevOps Git or similar version control and deployment tools

• Knowledge of data governance frameworks lineage and cataloging tools

• Background in performance optimization for cloudbased data platforms

Security Responsibilities

Must complywith all company security and data protection / usage policies and procedures. Personally responsible for proper marking and handling of all information and materials in any form. Shall not divulge any information or afford access to other employees not having a need-to-know. Shall not divulge information outside company without management approval. All government and proprietary information will be accessed and stored electronically on company provided resources.

• Incumbent must be eligible for DoD Personal Security Clearance.

Due to U.S. Government contract requirements only U.S. citizens are eligible for this role.

Work Environment

• Duties performed in an office environment and manufacturing facility.

• Must be able to work overtime on and off-shifts as required.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities duties or responsibilities that are required of the employee for their job. Duties responsibilities and activities may change at any time with or without notice.

CAE USA Inc. is an equal opportunity employer and all qualified applicants will be considered for employment without regard to any protected characteristic including disability and protected veteran status as defined under federal state or local laws.

Applicants needing reasonable accommodations should contact their recruiter at any point in the recruitment process. If you need assistance to submit your application because of incompatible assistive technology or a disability please contact us at

About CAE

At CAE our mission is clear: to help make the world a safer place. For nearly 80 years weve 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

Equal Opportunity Employer

CAE is an equal opportunity employer committed to providing equal employment opportunities to all applicants and employees without regard to race color national origin age religion sex disability status protected veteran status or any other characteristic protected by federal state or local CAE everyone is welcome to contribute to our success. Applicants needing reasonable accommodations should contact their recruiter at any point in the recruitment you need assistance to submit your application because of incompatible assistive technology or a disability please contact us at .

Data Privacy

Privacy Statement CAE

As part of our process we may use AIsupported tools to help review applications with human decisionmaking 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.