Job : Data Engineering Specialist
Location: Montreal/ C te-de-liesse (ST-LAURENT)
Hours per Week: 40
Does the position allow for the worker to be virtual/remote?: Hybrid
(a percentage of time can be split between on-site and remote)
Job Description:
** Bilingualism is required**
Job Description
Our engineers are the technical visionaries driving our innovative
solutions. Renowned globally for designing, integrating, and
delivering state-of-the-art simulation and training systems, you'll
tackle complex challenges, collaborate across functions, and lead
advancements that shape the future of our industry. Supported by a
culture that fosters flexibility, growth, and technological
excellence, our engineers are empowered to make a meaningful impact
every day. Whether your passion lies in data, mechanical, or aerospace
engineering, Client provides the environment to refine your skills and
create a lasting legacy in safety and simulation
Responsibilities:
Platform Architecture and Data Engineering
Build and maintain data solutions in Microsoft Fabric across Bronze,
Silver, and Gold layers using CAE's data platform framework.
Support and improve the enterprise data platform, including data
warehouses and data lakes.
Design, build, and maintain data pipelines using SQL and big data
tools such as Spark, Kafka, or Hadoop.
Develop reliable processes to ingest, transform, and deliver data from
a variety of sources.
Integrate data from internal, external, and IoT sources to support
business needs.
Build and maintain backend data solutions that support analysts, data
scientists, and other business users.
Operations, Quality, and Delivery
Apply DevOps practices to improve the development and deployment of
data solutions.
Identify opportunities to automate manual work and improve data
delivery processes.
Follow data governance, architecture, and security standards.
Monitor data pipelines and provide support when issues arise.
Collaboration and Technical Leadership
Work closely with product teams, data experts, architects, and other
stakeholders to solve technical issues and support data platform
needs.
Help guide technical decisions, review code, and share best practices
with the team.
Collaborate with cross-functional teams on data and AI initiatives.
Skills Matrix - Top 3 Must Have Skills:
Bachelor's degree in Computer Science, Engineering, or a related
field. A master's degree is an asset.
At least 6 years of experience in data engineering with strong
hands-on coding in Python, Spark, SQL, and related scripting
languages.
Experience using Visual Studio Code and Git in modern development workflows.
Required hands-on experience with Microsoft Fabric, including
Lakehouses, OneLake, pipelines, notebooks, and medallion architecture
across Bronze, Silver, and Gold layers.
Strong understanding of computer science fundamentals, including
data structures and algorithms.
Experience with Terraform.
Experience with relational and NoSQL databases, including SQL
Server, PostgreSQL, and Cosmos DB.
Skills Matrix - Top 3 Nice to Have Skills
Experience with workflow and orchestration tools such as Azure Data
Factory and Airflow.
Experience with DevOps and Github and infrastructure deployment
tools such as ARM.
Experience with Microsoft cloud and data platforms such as Fabric,
Azure, Databricks, and Purview.
Experience with stream-processing technologies such as Spark Streaming.
Familiarity with Kubernetes.
Proficiency in Power BI for reporting and data visualization.