CAE

Data Engineer

Ottawa Full time

About This Role

                                                                                                         

Position Overview

We are looking for a Data Engineer to join our team and play a key role in building and supporting data pipelines that power our analytics solutions. The ideal candidate will have experience—or a strong interest—in data engineering and analytics, with a focus on transforming raw data into structured, modelled datasets for business insights.

*This position is an existing role*

 

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 for 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.

 

 

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  

  • The possibility to work from home occasionally  

  • Flexible schedules  

  • Attractive employee benefits 

 

About CAE

At CAE, we equip people in critical roles with the expertise and solutions to create a safer world. As a technology company, we digitalize the physical world, deploying software-based simulation training and critical operations support solutions. Above all else, we empower pilots, cabin crew, airlines, and defence and security forces to perform at their best every day and when the stakes are the highest. Around the globe, we’re everywhere customers need us to be with more than 13,000 employees in approximately 250 sites and training locations in over 40 countries. CAE represents more than 75 years of industry firsts—the highest-fidelity flight and mission simulators as well as training programs powered by digital technologies. We embed sustainability in everything we do. Today and tomorrow, we’ll make sure our customers are ready for the moments that matter.

Read our Read our FY24 Global Annual Activity and Sustainability Report.

Follow us on Twitter: @CAE_Inc
Facebook: 
www.facebook.com/cae.inc
LinkedIn: www.linkedin.com/company/cae

Pay Range

$65,400 CAD - $98,200 CAD

 

Position Type                       

Regular

CAE thanks all applicants for their interest. However, only those whose background and experience match the requirements of the role will be contacted.

Equal Opportunity Employer 

CAE is an equal opportunity employer committed to providing equal employment opportunities to all applicants and employees without regard to race, nationality, colour, religion, sex, gender indentity and expression, sexual orientation, disability, neurodiversity, veteran status, age, or other characteristics protected by local laws.

If you don't see yourself fully reflected in every job requirement listed in the job posting, we still encourage you to reach out and apply. At CAE, everyone is welcome to contribute to our success. 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 CAECarrieres-Careers@cae.com