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
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 RegularEqual 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 [email protected] if needed.
Data PrivacyPrivacy 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.
Skills Required
- Bachelor's degree in Computer Science, preferably focused 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 collaborate with analytics and business teams
- Completed Data Science coursework or certification
- 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 valid work permit holder
- 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 Pandas, NumPy, and Scikit-learn
- Knowledge of data modeling and data warehouse concepts
- Interest in data analytics and visualization
What We Do
CAE is a high technology company, at the leading edge of digital immersion, providing solutions to make the world a safer place. Backed by a record of 75 years of industry firsts, we continue to reimagine the customer experience and revolutionize training and operational support solutions in civil aviation, defense and security, and healthcare. We are the partner of choice to customers worldwide who operate in complex, high-stakes and largely regulated environments, where successful outcomes are critical. Testament to our customers’ ongoing needs for our solutions, over 60 percent of CAE’s revenue is recurring in nature. We have the broadest global presence in our industry, with approximately 13,000 employees, 180 sites and training locations in over 35 countries
