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 be assigned more complex desk assignments and categories requiring higher analytical skills and experience. They will also provide backup to the Analyst IV regarding training and coaching support for new analysts.
Our flexible/ hybrid work schedule includes 3 in-person days at one of our core locations and 2 remote days. Our core office locations include Salisbury, NC , Chicago, IL, Quincy, MA, Carlisle, PA, Scarborough, ME, Hyattsville, MD and Mauldin, SC.
Duties and Responsibilities:
Essential job functions:
- Responsible for ensuring 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 trouble shooting and analyze where the effective corrected sales are coming from when necessary, i.e. which sales correction type is the effective one (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 Product 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 our Values.
Qualifications:
Knowledge:
- 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
- Leading teams to solve small projects.
- Team player and collaborator
- Strong Mathematical and Statistical aptitude
- Ability to analyze and decipher large amounts of data.
- Working knowledge of supply chain processes; responsible for larger more complex desk assignments
- Experience applying statistical forecasts and demand forecasting.
- 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.
Education:
- Bachelor's Degree in Statistics, Mathematics or related business field or equivalent relevant work experience
- Analyst III Forecast: 2-4 Years
- Relex knowledge preferred
- Store Operations: Supply Chain knowledge preferred.
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 their unique qualifications and experience, internal equity, and market conditions. Final compensation decisions will be made in accordance with company policies and applicable laws.
#LI-ES1
