Demand Planning Analyst

Shamrock Foods Company; Phoenix (AZ); On-site; USD 70,000 - 90,000; Full time

Job summary

Shamrock Foods Company seeks a Demand Analyst to forecast demand for assigned products and channels, building models with Excel and PowerBI, and incorporating inputs from Sales, Marketing, and customers.

The role supports Supply & Demand Managers, Category Management, and Account Management, aiming to improve KPIs like fill rates and inventory days on hand.

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 with Excel (statistical functions, VLOOKUPs, Pivot Tables) and Business Intelligence (PowerBI, Databricks, etc.).

Responsibilities

• Develop demand statistical forecasts at multiple aggregation levels for weekly demand planning.
• Build, maintain, and improve forecasts based on historical sales, trends, seasonality, and promotions.
• Collaborate cross-functionally to collect info on promotions, sales/marketing initiatives, category growth, market data, and pricing.
• Lead weekly calls with Account Managers on sales strategy and inventory management.
• Perform product and customer segmentation analysis to determine focus areas.
• Monitor product purchases and sales to create inventory optimization models.
• Maintain, automate, and improve reporting across supply chain departments.
• Lead and assist in ad-hoc department projects.
• Other duties as assigned.

Skills

Data analysis

Statistical methods

Communication skills

Team collaboration

Problem solving

Education

Bachelor’s degree (B.S.) in Supply Chain, Data Analytics, Economics, or related

Tools

PowerBI

Databricks

Excel

Forecasting tools (Anaplan, Logility, ForecastPro)

Blue Yonder

RELEX planning

Job description

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.

• 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.).
• 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.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.