Demand Planning Analyst

Shamrock Foods Company•Phoenix, AZ

About The Position

The Demand Analyst is responsible for forecasting activities associated with assigned products and/or sales channels/categories. This is achieved by creating and maintaining forecast models for customers, incorporating business intelligence and forecast information gathered from Sales, Marketing, customers and syndicated consumer data. In addition, this position will support Supply & Demand Managers, Category Management, and Account Management. The Demand Analyst will be responsible for utilizing tools such as Excel, PowerBI, and forecasting tools, to drive efficient business decisions. The Demand Analyst’s focus is to drive improvements in KPIs such as fill rates, risk of waste, and inventory days on hand.

Requirements

Bachelor’s degree (B. S.) from a college or university; preferably in Supply Chain Management, Data Analytics, Information Systems, Logistics, Operations, Statistics, or Economics.
1-3 years of experience in Supply Chain with a focus on demand disciplines or related field.
Demonstrated expertise working with Excel (statistical functions, VLOOKUP’s, Pivot Tables) and Business Intelligence (PowerBI, Databricks, etc.).
Intermediate MS SQL experience (Microsoft Azure, Microsoft 365, etc.).
Ability to work with large data sets (cleaning, auditing, and formatting data) to conduct thorough and accurate analysis.
Strong mathematical background.
Strong ability and desire to work both independently and in group / project settings.
Strong verbal/written communication and group presentation skills.

Nice To Haves

Preferred Industry certification in Supply Chain, i.e.: APICS Certified in Production and Inventory Management (CPIM) or APICS Certified Supply Chain Professional (CSCP).
Preferred experience with demand planning software (i.e.: Anaplan, Logility, Blue Ridge, ForecastPro, Blue Yonder) a plus.
Preferred experience with utilization within RELEX planning environments

Responsibilities

Develop demand statistical forecasts at several levels of aggregation (category hierarchy down to product level detail), for weekly demand planning functions.
Build, maintain, and continue improving demand forecasts based on historical sales, market trends, seasonality, and promotions to support decision-making with the lowest forecast error rate possible.
Work cross-functionally across multiple departments to collect information on promotions, sales/marketing initiatives, category growth and penetration initiatives, market data, and price fluctuations to improve the model and make better educated assumptions.
Lead weekly calls with the designated Account Managers around sales strategy, market updates, obsolete and slow inventory, and other areas as assigned.
Perform both product and customer segmentation analysis to determine appropriate focus areas.
Monitor product detail purchases and sales to create inventory optimization models.
Maintain, automate, and improve reporting functionality across different supply chain departments.
Lead and assist in ad-hoc department projects.
Other duties as assigned.