Data Engineer

Key Responsibilities

• Develop and maintain ETL processes using Microsoft SSIS and/or Microsoft Fabric Data Pipelines
• Design and optimize workflows to extract transform and load data from various sources.
• Ensure data quality integrity and availability for business analysts and reporting teams.
• Collaborate with analysts to deliver modelled data dashboards and reports.
• Troubleshoot and support existing data pipelines and integrations

Required Skills/Qualifications & Experience

• Bachelors degree in Computer Science (preferably with a focus on Data Science and Analytics) or equivalent experience.
• Strong experience with SQL including writing and optimizing complex queries.
• Understanding of ETL concepts and data pipeline design.
• Ability to work collaboratively with analytics and business teams.
• Completed Data Science coursework or certification

Preferred Skills

• Hands-on experience with Microsoft SSIS Microsoft Fabric or similar ETL tools.
• Familiarity with IBM Cognos Power BI or other BI/reporting tools.
• Proficiency in Python and familiarity with common Data Science libraries (e.g. Pandas NumPy Scikit-learn)
• Knowledge of data modelling and data warehouse concepts.
• Interest in data analytics and visualization.

Minimum Qualifications:

• 2-3 years of data engineering experience
• Eligibility to obtain and maintain Controlled Goods Clearance and Level II NATO Secret security clearance
• Legal authorization to work in Canada as a Canadian Citizen Permanent Resident or holder of a valid Work Permit

CAE offers:

• An environment where your initiatives will be recognized and valued
• The opportunity to work on a variety of projects on a multidisciplinary team
• A hybrid work environment
• Flexible schedules
• Attractive employee benefits

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.

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 availablecontact your recruiter or email if needed.

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.