Data Engineer

CAE Inc; Halifax; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work environment

Flexible schedules

Attractive employee benefits

Variety of projects

Job summary

CAE Inc. is seeking a data engineer to join our global team focused on safety and simulation. You will develop and maintain data pipelines, optimize ETL workflows, and ensure data quality to empower business analysts and reporting teams.

The role requires strong SQL, ETL concepts, and collaboration with analytics groups. A CS degree and data science coursework, plus experience with SSIS/Fabric or BI tools, are preferred. We offer a hybrid work environment and comprehensive benefits.

Qualifications

• Bachelor's degree in CS with data science/analytics focus or equivalent.
• Strong SQL skills with ability to optimize complex queries.
• Understanding ETL concepts and data pipelines.
• Ability to collaborate with analytics and business teams.
• Completed Data Science coursework or certification.

Responsibilities

• Develop and maintain ETL processes using Microsoft SSIS and/or 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 modeled data, dashboards, and reports.
• Troubleshoot and support existing data pipelines and integrations.

Skills

SQL

ETL concepts

Data pipeline design

Collaboration with analytics teams

Python basics

Education

Bachelor's degree in Computer Science (Data Science/Analytics focus) or equivalent

Tools

Microsoft SSIS

Microsoft Fabric

Power BI

IBM Cognos

Python

Job description

Our engineers are the technical visionaries behind our innovative solutions. Globally recognized for delivering cutting‑edge systems, you’ll tackle complex challenges, collaborate across functions, and lead advancements that shape our industry. Supported by a culture of flexibility, growth, and innovation, join us to create a lasting legacy in safety and simulation.

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

• Bachelor's 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

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.

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.

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.