Sr. Forecast Analyst

This position is responsible for maintaining the monthly demand planning process (primarily via generating statistical forecasts and KPI tracking, along with input via cross-department collaboration). This individual will monitor and update incoming datasets used for statistical forecasts and update the design/use of input data as the commercial requirements evolve. This person also contributes to the cross-functional inventory planning and customer demand review processes.Pay Range $85,450 - $104,700Principle ResponsibilitiesValidate and organize demand data from multiple sources and load it into the forecasting system.Cleanse input data as needed to maximize forecast accuracy and minimize bias.Design/Redesign forecasting processes to adjust for frequent customer-driven changes in demand structure.Maintaining forecasting structural data to ensure proper categorizationAnalyze, develop, and maintain a monthly forecast for all finished goods parts using order and shipment history, customer point of sale data, market intelligence, and industry trends to anticipate the projected demand.Lead the program(s) monthly collaborative demand review as part of the S&OP process.Work with sales, marketing, and product management to understand product life cycles, demand patterns, and short-, medium-, and long-term forecasts.Develop means to detect exceptions in large datasets and design rational responses.Contribute to continuous improvement efforts to advance the demand planning and forecasting process capabilities.Maintain forecast vs. actual history data by customer, product family, channel, geography, and SKU.Update/Create standard work process documents as the procedure evolves.CompetenciesAble to develop and design a statistical forecasting process and standards for high sku-count seasonal products.Develop, design, apply, and validate safety stock strategies. Understand the impact of safety stock on customer fill rates and the organization’s inventory position.3+ years’ experience directly utilizing enterprise planning software (e.g., SAP, JDA, IBP, Oracle, etc.) to create statistical forecasts for high SKU-count customers (2000 to 10,000+ SKUs).Lead multiple medium and large projectsExperience using and interacting with MRP systems.Experience comparing, implementing, and validating forecasting methodologies, techniques, and approaches (e.g., moving averages, exponential smoothing, holt-winters, discrete probability, etc.).Detail-oriented and ability to organize work activities in highly ambiguous situations.Advanced Excel Skills applied to large multi-variable datasets to extract/compile/analyze/interpret results. Advanced Access skills are a plus.Calculate and track forecast MAPE and bias to measure performance.Strong problem-identification and analytical skills.Experience with process management skills.Action-oriented.