Hybrid Data & Analytics Program Analyst

Bombardier Transportation GmbH; Mississauga; Hybrid; 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

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.