Strategic Inventory Demand Planner & Item Data Specialist

American-Iron-; Montreal (administrative region); On-site; CAD 70,000 - 90,000; Full time

Benefits offered by this job

Competitive salary and benefits

Group insurance and RRSP

Free on-site gym

Dynamic work environment

Job summary

American Iron & Metal Company (AIM) is seeking an Inventory Demand Planning & Item Master Data Specialist to own SKU lifecycle across multiple sites and optimize BOM mapping in Maximo. The role emphasizes data integrity, analytics-driven demand planning, and close collaboration with maintenance and engineering.

Ideal candidates have 3–5 years in supply chain with strong Excel/Access/VBA and ERP experience. Join AIM to help reduce stockouts and improve working capital in a dynamic metals

Qualifications

• 3–5 years of dedicated supply chain experience with at least 2 years in inventory/item modules.
• Experience with asset-intensive environments like metal recycling or heavy manufacturing.
• Advanced Excel skills (VLOOKUP, Power Query, Pivot Tables), Access, VBA coding and SQL.
• Bachelor’s degree or professional college diploma in SCM, Operations Logistics, or Data Analytics.
• Strong attention to detail and ability to negotiate priorities between data standards and urgent needs.

Responsibilities

• Direct full lifecycle (creation, validation, modification, archiving) of inventory SKU numbers across a multi-site environment.
• Enforce naming conventions, asset hierarchies, UOM conversions, Min-EOQ, and commodity classifications.
• Build and audit BOMs and rotating item links in Maximo to map components to shredders and fleets.
• Run data-quality audits to eliminate duplicates and ensure vendor cross-references are pristine.
• Compute and adjust ROP, Safety Stock, and Min/Max levels in Maximo based on lead times and seasonality.
• Forecast spare parts demand with Maintenance Planners and Engineering ahead of major overhauls.
• Own automated reorder process; generate/validate PRs based on system triggers.
• Track KPIs like inventory turnover, dead-stock, and stock-out frequencies.
• Identify cost-saving opportunities by flagging slow-moving or duplicate items.

Skills

ERP systems

SQL

Excel mastery

Data analytics

Education

Bachelor's degree in SCM

Tools

IBM Maximo

MS Excel

MS Access

SQL

Job description

American Iron & Metal Company (AIM) is seeking an Inventory Demand Planning & Item Master Data Specialist to own SKU lifecycle across multiple sites and optimize BOM mapping in Maximo. The role emphasizes data integrity, analytics-driven demand planning, and close collaboration with maintenance and engineering.

Ideal candidates have 3–5 years in supply chain with strong Excel/Access/VBA and ERP experience. Join AIM to help reduce stockouts and improve working capital in a dynamic metals