Analyst, Strategy & Business Dev.

Bombardier; Montreal (administrative region); On-site; CAD 65,000 - 90,000; Full time

Job summary

Bombardier in Montreal is seeking an inventory analytics professional to optimize inventory levels, forecast demand and automate reporting. You will build dashboards, monitor KPIs and collaborate across procurement, operations and finance to drive data-driven decisions.

The role requires 2+ years in supply chain analytics, strong Excel and Power BI skills, and familiarity with ERP systems and SQL. A data-driven mindset and AI awareness are a plus.

Qualifications

• At least 2 years of experience in inventory analysis, supply chain analytics or related field.
• Bachelor’s degree in a relevant discipline as listed above.
• Experience with ERP systems, planning tools and operational data sources.
• Proven ability to develop dashboards, reports and scorecards.
• Advanced Excel skills (pivot tables, Power Query, data modeling).
• Power BI skills for interactive dashboards and KPI monitoring.
• Basic to intermediate SQL knowledge for data extraction and validation.
• Knowledge of data warehouses and cloud analytics platforms (Azure Synapse, Data Lake, Databricks).
• Understanding of AI concepts, predictive analytics and anomaly detection.
• Experience applying Copilot and Generative AI to data analysis and reporting.

Responsibilities

• Determine inventory levels per family and product class.
• Analyze and communicate impacts of procurement strategies; suggest mitigations.
• Monitor production rate changes relative to procurement strategy and forecast inventory fluctuations.
• Track inventory components and their locations.
• Drive problem-solving autonomously in analytics domains.
• Develop and maintain automated dashboards, Power BI reports, executive scorecards and KPIs.
• Apply SQL, Python, Excel and Power Query to extract and transform data for automation.
• Support transition to automated, predictive, AI-assisted planning.
• Participate in pilots and continuous improvement initiatives in forecasting and inventory control.
• Present findings, model outputs, risks and recommendations clearly to stakeholders.
• Stay current on AI, ML, analytics trends and practical use cases for Bombardier.

Skills

Inventory analysis

Supply chain analytics

Data analysis

Dashboard development

Advanced Excel

Power BI

SQL

Python

Process automation

Stakeholder communication

Education

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

Tools

ERP systems

Power Query

Power Pivot

Azure Synapse Analytics

Azure Data Lake

Databricks

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.