Lead Data Engineering

Bombardier Transportation GmbH; Dorval; On-site; CAD 100,000 - 130,000; Full time

Job summary

Bombardier is seeking a Lead Data Engineer to oversee the enterprise data platform, ensuring high performance and compliance with data architecture requirements. Candidates should possess a bachelor's degree in a quantitative field and extensive experience in data engineering practices. The ideal candidate will demonstrate leadership, expertise in SQL, and proficiency in big data technologies like Azure and Python, thriving in a hybrid working environment.

Benefits

Comprehensive insurance plans including dental and medical.

Retirement savings plan.

Employee Assistance Program.

Qualifications

• 10 years of experience in a Data Engineer or Data Specialist role.
• Experience leading a small team and agile delivery.
• Advanced SQL and efficient big data pipeline optimization.

Responsibilities

• Lead and administer the enterprise data platform.
• Create optimal data pipeline architectures for business needs.
• Integrate data sources and manage them as key enterprise assets.

Skills

Leadership

SQL

Data Engineering

ETL

Agile/SCRUM

Root Cause Analysis

Education

Bachelor’s degree in Computer Science/Statistics/Informatics

Tools

Azure Data Factory

Databricks

Python

Spark

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

When applicable, Bombardier promotes flexible and hybrid work policies.

At Bombardier, we design, build and maintain the world’s peak-performing aircraft for the world’s most discerning people and businesses, governments and militaries. We have been successful in setting the highest standards by putting our people at the heart of it all, and defining excellence, together.

Working at Bombardier means operating at the highest level. Every day, you are part of a team that delivers superior experiences and products, pushing the boundaries of what's possible in our industry and beyond. By prioritizing employee growth and development, we empower everyone to reach their full potential on their own terms, because the best work happens when you are free to be yourself and share your unique expertise.

With our employees’ well-being top of mind, we offer a comprehensive and competitive Benefits Program, which includes the following:

• Insurance plans (Dental, medical, life insurance, disability, and more)
• Retirement savings plan
• Employee Assistance Program
• Lead/Administer the enterprise data platform (DWH, Data Lake)
• Create and maintain optimal/reliable data pipeline architecture to meet business needs
• Define and operate the infrastructure required for optimal extraction, transformation and loading (ETL) of data from a wide variety of data sources using SQL and ‘big data’ technologies as needed (Parquet, Delta format, Python, Spark, Kafka, NoSQL, SQL)
• Design and implement life cycle management processes (DevOps) to enable continuous integration and continuous deployment (CICD) of data systems
• Integrate data from various resources (including external data sources and IoT) and manage the big data as a key enterprise asset
• Create and maintain backend data solutions for data analysts and data scientists. Assist them in unlocking insight from enterprise data
• Identify, design, and implement internal process and framework (e.g. elimination of manual processes, optimizing data delivery, evolving data infrastructure capabilities, etc.)
• Work with stakeholders including product, data and architecture SME to assist with data-related technical issues and support their data infrastructure needs
• Ensure compliance to data architecture and security requirements
• Identify data quality issue and make recommendation for addressing root causes
• Setup observability/monitoring to measure reliability of the data pipelines and act quickly (e.g. operational support) in case of incident.
How to thrive in this role?
• You hold a bachelor’s degree in computer science, Statistics, Informatics, Information Systems or another quantitative field
• You have 10 years of experience in a Data Engineer / Data Specialist role
• You have experience coaching/leading a small team (technical leadership)
• You have knowledge of Agile / SCRUM project delivery, DevOps and CICD practices
• You have advanced knowledge of SQL, query authoring and relational databases
• You have experience optimizing ‘big data’ pipelines (storage, file format, partitioning, spark, python, streaming)
• You are efficient at performing root cause analysis to address issues and applying long-term fix
• You have experience designing and building data transformation, data structures, metadata framework and automated workload management
• You have experience in data protection measures, data privacy and collaborating with Cyber team
• You have good knowledge of Azure data services (Azure Data Factory, Synapse, Azure Data Lake Storage, Event Hub, Databricks, Delta lake, Cognitive Services, …)
• You have good knowledge of Object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
• You have good people skills and are a team player, motivated by developing other people
• You are a good communicator, who can simplify complex technical issue for non-technical people. You can work in an environment with a mix of French and English languages.

Now that you can see yourself in this role, apply and join the Bombardier Team!

Please note: You don’t need all the skills, knowledge, and experience listed to apply for this position. We’re not looking for the perfect candidate, we’re looking for great talent and passionate individuals.

Bombardier is an equal opportunity employer and encourages persons of any race, religion, ethnicity, gender identity, sexual orientation, age, immigration status, disability or other applicable legally protected characteristics to apply.


Job Lead Data Engineering

Primary Location Administrative Centre (CA)