Executive Manager-Forecast Analyst-Sector lead-Supply Chain

Overview

The purpose of this role is to lead and coordinate the forecasting analyst team for Sector IBP-Forecasting Markets to generate a sound driver-based forecast as starting point for the Demand Planning process within IBP by ensuring the right data is available for the IBP forecasting engine (PFE), executing the models that generate the forecast. The forecasting analyst roles will collaborate day to day with the Demand Planners to ensure the forecast is as per business needs and with the Data Scientists to continuously improve the forecasting engine and the data to improve the forecast accuracy. The forecasting analyst will work both on Mid-Term (monthly / 24 months) and Short-Term (weekly / 16-20 weeks) depending on the scope assigned within a BU

The scope of this role oversees all the Bus in Sector Forecasting Analyst and will have a dotted line reporting relationship with the Global IBP Forecasting Excellence Lead and a solid line with the Global GCC Forecasting Lead

This is a key role in IBP as Driver Based Forecast and the PFE are key components to enable the One Plan in the IBP/DP process

Responsibilities- Critical role in ownership, execution and improvement of the Driver Based Forecast in IBP or PFE Forecasting markets
- Lead and coordinate the team of forecasting analysts working for Sector BUs
- Be the main point of contact for Sector and Global IBP / S&T teams and support Forecasting Analyst by BU on their BU stakeholder management.
- Main point of contact to coordinate and prioritize improvements to the PFE with Data Science Global teams working on the Sustain and continuous Improvement of the BU Demand Planning Leads and Data Scientist working for that specific BU
- Lead and ensure that the Forecasting Analyst perform their process and tasks in the for Short-Term, Mid-Term Forecasting Models and all the required demand streams in the BU
- Ensure all demand drivers are being captured in the driver-based forecast
- Reconcile data inputs to confirm that all volume driver data is complete and there are no gaps
- Ensure all the Master Data needed to activate, deactivate, substitute DFUs in the Demand Planning systems and all associated lifecycles management activities at the different levels of the hierarchy are consistently executed. Manage the overall/massive master data management.
- Ensure history corrections, outliers corrections and realignments needed to run the models are executed properly and manage events that apply to all BU and history realignments
- Ensure models run correctly and the output is complete and consistent
- Perform small adjustments in the forecasting engine parameters / data inputs to capture demand trends or patterns that are not well reflected based on own findings or feedback from the Demand Planners
- Measure and Report Forecasting KPIs
- Drive overall Forecast Continuous Improvements and Root Cause Analysis with the Demand Planners and perform the analysis on the modelling. Identify improvement areas and recommended actions. Collaborate with Demand Planners and Data Scientists to define an implement an improvement backlog on the models
- Support Data Science in the Experimentation, test and evaluation of the improvements and its validation with the Demand Planners before its implementation
- Coordinate Sector Forecast Accuracy reporting, Demand and Forecast Performance Analysis and Continuous Improvement Plan across Sector, defining the priorities across markets based on overall impact to the business
- Drive segmentation calculations and review and validate with the demand planners for its implementation
- Leverage and share best practice which will impact on the wider PepsiCo ecosystem ensuring the best for PepsiCo and therefore enabling its Better, Stronger and Faster ambitions
- Support Forecasting process and tool improvement initiatives

Qualifications- Holder of both a Bachelors and Master degree (preferably with studies in Business Administration, Engineering, Supply Chain, Finance). Having an MBA is a plus.
- Experience in generating accurate demand statistical forecast and in advanced forecasting models including Machine Learning algorithms at fast moving consumer goods including a collaborative planning, demand sensing, promotions planning, new product introduction planning, demand shaping and demand scenarios management
- Proficiency in Data Analysis and Insights. Ability to navigate across large amounts of data, understand the gaps, identify exception and extract insights to form conclusions and inform decisions, with strong analytical skills.
- High level of understanding on commercial activities and how they driver demand in FMCG and strong understanding of the demand planning and forecasting processes
- Ability to process and resolve complex issues, establish priorities and action plans
years of over all experience with 8+ years in Demand planning or forecasting
- Experience at a middle level in the FMCG industry is a plus
- Experience in managing and organizing teams
- Collaborative and team player
- Strong in both strategic and analytical thinking
- Strong in organizational skills and attention to detail
- Good business acumen with results orientation
- Ability to generate consensus via strong network & collaborations skills
- Fluent in English with Local Language (for Mus assigned is a plus)
- Strong understanding of the IBP processes, demand planning and forecasting.
- Comfortable with process discipline and process adherence, but also able to identify and take opportunities to further develop and strengthen the process without compromising the end state