Analyst, Strategy & Business Dev.

Bombardier Transportation GmbH; Saint-Laurent-de-l'Île-d'Orléans; On-site; CAD 70,000 - 95,000; Full time

Job summary

Bombardier Transportation GmbH is seeking an inventory analytics specialist to optimize procurement and inventory levels. You will build automated dashboards, monitor KPI performance, and support AI-driven planning enhancements.

The role requires 2+ years in supply chain analytics, a related bachelor’s degree, and strong data skills with SQL, Python, Excel, and Power BI. You will collaborate with diverse teams in a global environment.

Qualifications

• At least 2 years in inventory analysis, supply chain analytics, or related field.
• Bachelor’s degree in a related discipline as listed.
• Experience with ERP systems, planning tools, and operational data sources.
• Ability to develop dashboards, management reports, and scorecards.
• Advanced Excel skills including pivot tables and data modeling.
• Knowledge of Power BI, trend analysis, KPI monitoring, and automated reporting.

Responsibilities

• Determine inventory levels per family and product class.
• Analyze procurement strategies and suggest mitigations to impacts.
• Monitor production rate changes and inventory fluctuations.
• Develop and maintain automated dashboards, Power BI reports, and KPIs.
• Apply SQL, Python, Excel, Power Query to extract and transform data.
• Support transition to automated, predictive, AI-assisted planning.
• Present findings clearly to technical and non-technical stakeholders.
• Stay current on AI, forecasting, and inventory optimization advances.

Skills

Inventory analysis

Supply chain analytics

Data analysis

Excel

Power BI

SQL

Python

Power Query

Data visualization

Education

Bachelor’s degree in Supply Chain, Logistics, Industrial Engineering, Business Analytics, Data Science, Computer Science, Mathematics, Statistics

Tools

Power BI

SQL

Microsoft Azure Synapse Analytics

Azure Data Lake

Databricks

ERP systems

Job description

What are your contributions to the team?

• Determine the required inventory levels per family and product class
• Analyze and communicate on the impacts linked to the different procurement strategies, makes suggestions to mitigate the impact of those strategies.
• Monitor production rate changes in relation to the procurement strategy and anticipate inventory fluctuations.
• Monitor the different components of inventory, as well as their different Locations.
• Autonomously drive problem solving in your own specialty field
• Develop and maintain automated dashboards, Power BI reports, executive scorecards and inventory KPIs to monitor inventory levels, forecast accuracy, excess and obsolete inventory, shortages, turns, service levels and material flow performance.
• Apply SQL, Python, Excel, Power Query and other analytical tools to extract, transform, analyze and automate inventory data processes.
• Support Bombardier’s transition from manual or rule-based planning activities toward more automated, predictive and AI-assisted ways of working.
• Participate in pilots and continuous improvement initiatives related to demand forecasting, inventory optimization, exception management, anomaly detection and digital inventory control.
• Present analytical findings, model outputs, risks, trade-offs and recommended actions clearly to technical and non-technical stakeholders.
• Stay current on advancements in AI, machine learning, supply chain analytics, forecasting and inventory optimization, and help identify practical use cases for Bombardier.

How to thrive in this role?

• Bring at least 2 years of experience in inventory analysis, supply chain analytics, business analytics, data analysis, logistics, planning, finance analytics, or a related field.
• Hold a bachelor’s degree in Supply Chain, Logistics, Industrial Engineering, Business Analytics, Data Science, Computer Science, Mathematics, Statistics, or a related discipline.
• Have experience working with ERP systems, planning tools, business databases, and operational data sources.
• Develop dashboards, management reports, automated reporting flows, and performance scorecards.
• Demonstrate advanced Excel skills, including pivot tables, Power Query, Power Pivot, formulas, data modeling, and dashboard development.
• Demonstrate Power BI skills, including interactive dashboards, executive scorecards, trend analysis, KPI monitoring, and automated reporting.
• Have basic to intermediate SQL knowledge, including data extraction, transformation, joins, query development, and validation of large datasets.
• Have basic to intermediate knowledge of data warehouses and cloud-based analytics platforms such as Microsoft Azure Synapse Analytics, Azure Data Lake, and Databricks.
• Understand artificial intelligence and machine learning concepts, including predictive analytics, anomaly detection, forecasting models, and recommendation logic.
• Apply Microsoft Copilot and Generative AI tools responsibly to support data analysis, reporting, documentation, and process improvement.
• Have exposure to forecasting, inventory management, material planning, replenishment, master data, logistics, or supply chain planning.