Demand Planning Analyst

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. Essential Duties: 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. Qualifications: 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.). 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 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. Corporate Summary: At Shamrock Foods Company, people come first – our associates, our customers, and the families we serve across the nation. A privately-held, family-owned and -operated Forbes 500 company, Shamrock is an innovator in the food industry and has been since being founded in Arizona in 1922. Our Mission: At Shamrock Foods Company, we live by our founding family’s motto to “treat associates like family and customers like friends.” Why work for us? Benefits are a major part of your overall compensation, and we believe offering them at an affordable cost is not only the right thing to do, but it helps keep you and your family healthy. That’s why Shamrock Foods pays for the majority of your health insurance, allowing you to take home more of your paycheck. And it doesn’t stop there - our associates also enjoy additional benefits such as 401(k) Savings Plan, Profit Sharing, Paid Time Off, as well as our incredible growth opportunities, continued education and wellness programs. Equal Opportunity Employer Shamrock Foods Company is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, veteran status, sexual orientation, gender identity or any other basis protected by applicable law.