Inventory Planner

City of Edmonton•Edmonton, AB

1d•CA$85,978 - CA$107,415•Onsite

About The Position

As a strategic Inventory Planner, you will serve as the architect of the City’s material supply chain, ensuring our frontline teams have exactly what they need to keep Edmonton moving. Reporting to the Supervisor of Inventory Management, you’ll take the reins of our SAP ecosystem—optimizing stock levels, mastering Material Master Data, and maintaining operational stock levels for Fleet Services seasonal and project activities to provide the high-quality service our citizens expect. You are a collaborative problem-solver who balances analytical rigour with the City’s commitment to financial stewardship. By leveraging sophisticated parameter management and building strong partnerships with internal clients, you will protect the City’s investment in parts and materials while ensuring our diverse warehouse locations operate at peak efficiency.

Requirements

Degree in Business Administration or a related discipline. Specialization in operational Inventory Management and Planning would be an asset
2 years progressive experience in Inventory Management or Operational management environment and other area of supply chain management or computerized ERP environment utilizing Inventory planning modules, including forecasting with preference to SAP is required
Demonstrated analytical and negotiation skills
Excellent personal relationship skills, both written and oral
Excellent customer service skills
Demonstrated knowledge of ERP systems related to procurement and inventory applications (SAP preferred)
Superior organizational, follow-up and multitasking skills
Excellent time management skills
Expert user of Microsoft Excel, including pivot tables
Understanding of current best in class inventory principles
Ability to work under pressure and meet required timelines
Work as an effective team member
Demonstrated ability to identify and develop proactive approaches to business requirements
Ability to assess complex situation, resolve or provide guidance and coordinate remedial actions
Ability to establish and maintain cooperative relationships with manufacturers and vendors
Ability to work in and form team environments as well as be able to work independently
Demonstrated knowledge of inventory management, planning and forecasting, and supply chain operations practices, policies, procedures, and controls
Expertise in ERP systems related to procurement and inventory applications; SAP is preferred
Ability to assess complex situations, resolve, or provide guidance and coordinate remedial actions with minimal supervision
Expert user in Excel, including ability to create and use pivot tables and complex formulas; proficiency in Microsoft Word and G Suite applications
Excellent analytical, forecasting and planning, problem solving, time management, organization, communication, negotiation, interpersonal, and customer service skills required

Nice To Haves

Experience in Supply Chain Operations management is an asset
CPIM designation from APICS and/or SCMP designation from SCMA are assets
Strong understanding of a Fleet Maintenance System such as the M5 system and associated processes are assets
Experience working with a variety of operational items such as engines, transmissions, MRO, and direct & indirect components related to Vehicle Fleet Maintenance (assets: Bus, Trains, Snow Plows, Tractors, Graders, Light/Heavy Duty vehicles)

Responsibilities

Control, maintain and monitor SAP Material Requirements Planning (MRP) parameters and transactions for assigned Plants by evaluating the material master data and planning situation, identifying needs based on historical and forecasted demand (i.e. what and how much is required, and when is it needed), and executing the plan to fulfil requirements
Communicate SAP MRP inconsistencies and exceptions to the Supervisor, Inventory Management
Maintain precise inventory data and balances to optimize inventory value and prevent overstatement or understatement of inventory investment
Ensure accuracy of the material master data including Material Master Records (MMR) and MRP settings, review historical demand prior to initiating replenishment orders
Analyze statistical data to determine best replenishment methods to ensure inventory is stocked in locations that have demand and that the appropriate SAP stocking parameters are in place for every inventoried item
Analyze material classifications based on the usage, cost or movement to achieve efficient inventory levels at the Plants while reducing the out of and over stock situations
Consult with the client department to determine priorities and requirements. Assist with dispute or issue resolution
Analyze impacts in inventory stocking decisions, use of critical parts/seasonal parts indicators, impacts of new equipment acquisitions and equipment being retired from service
Run weekly, monthly and yearly reports to ensure service levels and KPI's are being met including, but not limited to, on time in full (OTIF), inventory turns targets and inventory investment levels
Have extensive knowledge of the parameters within the SAP inventory module and the unique COE customized programming
Partner with and work closed with Operational Purchasing, Warehouse Operations, and internal Fleet/City operations clients to analyze requirements, impacts of market conditions, vendor lead times, and key supply chain factors
Ensure the development of comprehensive end-to-end processes, reduce inventory risk, and optimize customer service levels and manage obsolete and surplus inventory
Troubleshoot and resolve issues related to forecasted demand and MRP requirements
Serve as a subject matter expert on issues regarding inventory policies and procedures, SAP, M5, and other ERP applications
Perform other related duties as required