Analyst III Forecast
ADUSA Procurement is a partner company to Ahold Delhaize USA, providing supply chain services that support the delivery of products from a supplier to the warehouse. ADUSA Procurement is part of the Ahold Delhaize USA family of brands, which includes five leading omnichannel grocery brands: Food Lion, Giant Food, The GIANT Company, Hannaford, and Stop & Shop.
About the role
This position will manage system demand forecasts and plan for all assigned products with up to 10,000 SKUs across all stores at item/warehouse/store/day combination using statistical-based forecasting tools. The demand forecast and plan will be integrated into different legacy systems to drive store and warehouse replenishment as well as support for vendor collaboration, display optimization, promotion optimization, and promotional/events planning.
Responsible for maintaining and managing forecast master data, seasonality, association of products to events, and life cycle of the product line assigned. This position will work closely with In Stock Analysts and Demand Systems Specialists to review sales trends and implement parameters to support seasonal/transitional strategies, as well as advanced statistical forecast accuracy analysis to reduce system forecast error and avoid manual forecast adjustments.
This position will understand the future variability that impacts product movement—from increasing efficiencies, impacting the greater network, troubleshooting root causes, and supporting procurement streams (diverting, forward buy, efficiency programs). Analyst III's will be assigned more involved operational tasks within the structure. This role will handle more complex desk assignments and categories requiring higher analytical skills and experience, and provide backup to the Analyst IV regarding training and coaching support for new analysts.
Responsibilities
- Ensure Forecast & Replenishment (F&R) system forecast accuracy for assigned product line.
- Use advanced statistical forecast accuracy analysis to reduce system errors and avoid manual forecast adjustments.
- Resolve forecasting exceptions and perform daily root cause analysis of underlying issues to improve forecast accuracy for promotional and turn product.
- Manage all Relex (F&R system) daily, weekly, monthly forecast workflows resulting in reduced systemic forecast error.
- Partner with In Stock Analysts and Demand System Specialists to align on trends and strategies in support of forecast accuracy.
- Provide a forecast to vendor partners (private brands team).
- Complete sales correction troubleshooting and analyze where the effective corrected sales are coming from when necessary (e.g., stockout, campaign, or manual correction).
- Collaborate with Category teams on Ad promotions, special programs, and holidays.
- Review Store and Distribution Center baseline forecasts and BIAS, and troubleshoot any forecasts with low forecast accuracy or BIAS.
- Review and, if necessary, update master data and/or parameters for products that will be terminated.
- Follow-up on and review the forecast for new store locations.
- Additional job duties may be assigned as needed to meet the needs of the business and support company values.
Requirements
- Bachelor's Degree in Statistics, Mathematics, or related business field or equivalent relevant work experience.
- 2-4 years of experience in forecasting (Analyst III level).
- Relex knowledge preferred.
- Store Operations/Supply Chain knowledge preferred.
Skills
- Demand management practices.
- Intermediate to advanced Microsoft Excel and Access.
- Working knowledge of Supply Chain processes.
- Oral and written communication skills.
- Presentation skills.
- Experience applying and developing statistical forecasts and demand forecasting.
- Attention to detail.
- Advanced Excel and analytical skills.
- Ability to lead teams to solve small projects.
- Strong team player and collaborator.
- Strong mathematical and statistical aptitude.
- Ability to analyze and decipher large amounts of data.
- Experience with forecasting & replenishment software.
- Ability to analyze complex problems and rule sets.
- Ability to determine root causes and implement solutions.
- Strong critical thinker, autonomous decision-maker.
Schedule
Flexible/hybrid work schedule includes 3 in-person days at one of our core locations and 2 remote days. Core office locations include Salisbury, NC; Chicago, IL; Quincy, MA; Carlisle, PA; Scarborough, ME; Hyattsville, MD; and Mauldin, SC.
Pay
- ME/NC/PA/SC Salary Range: $75,040 - $112,560
- IL/MA/MD/NY Salary Range: $86,320 - $129,480
Actual compensation offered to a candidate may vary based on unique qualifications and experience, internal equity, and market conditions. Final compensation decisions will be made in accordance with company policies and applicable laws.