Program, Analyst

Bombardier Transportation GmbH; Mississauga; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Insurance plans (Dental, medical, life

retirement savings plan

Employee Assistance Program

Job summary

Bombardier Transportation GmbH is seeking a data integration professional to build and optimize ETL/ELT processes, design scalable data models, and support analytics initiatives. You will work with SQL Server, SAP S/4HANA, cloud platforms and Databricks, implementing governance and security while ensuring high-quality data products for self-service analytics.

The role involves Agile collaboration, data quality monitoring, and ongoing maintenance within a hybrid work environment.

Qualifications

• 2+ years in data integration, analytics, reporting or BI.
• Strong SQL and T-SQL skills, including query optimization and stored procedures.
• Experience with Databricks and cloud-based data platforms.
• Understanding of data warehousing and lakehouse architectures.
• Experience integrating enterprise applications such as SAP S/4HANA or ERP systems.

Responsibilities

• Build and optimize ETL/ELT processes that integrate data from SQL Server, SAP S/4HANA, cloud platforms, and other enterprise applications.
• Develop and maintain database objects including stored procedures, views, functions, indexes, and queries.
• Design scalable data models using dimensional modeling techniques, including star and snowflake schemas.
• Develop and support data pipelines and transformation processes using SSIS, Databricks, and SQL-based technologies.
• Implement data governance, security, and access controls to ensure trusted and compliant data assets.
• Monitor and optimize data pipelines, reporting solutions, and database performance.
• Support self-service analytics through curated datasets and reusable data products.
• Collaborate with business and technical teams to gather requirements and deliver practical solutions.
• Participate in Agile delivery practices using Azure DevOps.
• Support data quality through testing, validation, monitoring, and ongoing maintenance.
• Contribute to the evolution of modern enterprise data platforms.

Skills

SQL / T-SQL

Databricks

Cloud platforms

Data warehousing

Dimensional modeling

ETL/ELT

Data governance

Power Apps

Agile / Azure DevOps

Communication

Tools

Azure DevOps

Job description

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

What are your contributions to the team?

• Build and optimize ETL/ELT processes that integrate data from SQL Server, SAP S/4HANA, cloud platforms, and other enterprise applications.
• Develop and maintain database objects including stored procedures, views, functions, indexes, and queries.
• Design scalable data models using dimensional modeling techniques, including star and snowflake schemas.
• Develop and support data pipelines and transformation processes using SSIS, Databricks, and SQL-based technologies.
• Implement data governance, security, and access controls to ensure trusted and compliant data assets.
• Monitor and optimize data pipelines, reporting solutions, and database performance.
• Support self-service analytics through curated datasets and reusable data products.
• Collaborate with business and technical teams to gather requirements and deliver practical solutions.
• Participate in Agile delivery practices using Azure DevOps.
• Support data quality through testing, validation, monitoring, and ongoing maintenance.
• Contribute to the evolution of modern enterprise data platforms.

How to thrive in this role?

• 2+ years of experience delivering data integration, analytics, reporting, or business intelligence solutions.
• Strong SQL and T-SQL skills, including query optimization, performance tuning, stored procedures, views, and functions.
• Experience with Databricks and cloud-based data platforms.
• Understanding of data warehousing and lakehouse architectures, including dimensional modeling, data marts, semantic layers, medallion architecture, and enterprise analytics solutions.
• Experience building and supporting data pipelines for analytics, reporting, and operational processes.
• Experience integrating enterprise applications such as SAP S/4HANA, ERP platforms, or other large-scale business systems.
• Familiarity with Power Apps, Power Platform solutions, and business process automation.Understanding of data governance, security, master data management, and data quality best practices.
• Strong analytical and problem-solving skills with an inquisitive mindset and a passion for continuous improvement.
• Excellent communication and collaboration skills.

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.