Data Engineer

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 experienceor a strong interestin 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

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.

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

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

Follow us on Twitter : @CAEInc

Facebook : Range

$65400 CAD - $98200 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 dont 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

Required Experience :

IC

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Employment Type : Full-Time

Experience : years

Vacancy : 1