Req ID
Posted
Function
Location
Amsterdam, NH, NL, 1082VA
Demand Planning Analyst
Job Description Demand Planning Analyst COTY
____________________________________________________________________________________
SUPPLY CHAIN SERVICE: Division (CB) Demand Planning Location: Amsterdam
__________________________________________________________________________________
Key Responsibilities & Tasks
Category Forecast Reasonability and Sufficiency
Ensure overall reasonability of sales forecasts for the category and individual houses:
- Develop and retain an in depth understanding of the 24-month rolling forecast for the category with market trends, business targets & key innovation building blocks (at house/product level).
- Provide forecast reasonability recommendations to regional S&OP leaders for BU discussion.
- Perform some interventions/work with specific BUs as aligned with regional S&OP Leader.
- Represent the divisional demand team in the category Weekly & Monthly Hub Performance Reviews – maintaining an in depth understanding of the supply chain set-up for the category.
- Provide input and message tracks for the Divisional S&OP meetings.
KPI reporting
Calculate and publish results at BU and Division/House level for the different Output and In-process measures, with special focus on:
- Sales Plan Performance (SPP1/SPP3) measuring overall bias for relevant category and houses.
- Mean Absolute Percentage Error (MAPE90/OFC/UFC) measuring mix accuracy for relevant category and houses.
Gap analysis and action plans definition with ownership defined; by leveraging category ad-hoc analysis as well as root-cause consolidation from Market KPI Reviews.
Demand Capability building
- Work with the demand planning community to identify needs and deliver training.
- Manage improvement projects (ie. processes, tools, systems) including cross-department and cross-BU interactions at a category basis.
Global Brand Demand Planning responsibilities:
For the Brands under your responsibility, bring visibility to the Global & Regional Teams (Marketing, Trade, Finance, Initiative Management, Lifecycle, etc.). regarding the monthly « Sales & Operations Planning » cycle (S&OP). Own the monthly/quarterly Brand Demand Review where Sales Forecast from our worldwide markets is reconciled, and brand performance is analysed, focusing on the top markets, product lines & IRCs, as well as the latest IMP launches (e.g. focus on key deviations between forecast and Markets actual shipments, root-cause forecast volatility, ensure forecast reasonability and adherence with discontinuation processes, Phase-in/Phase-out transitions, new products launches performance vs original commitments, evaluating potential of the Launch through internal and external benchmarking, etc.). Help Global & Regional Teams to identify the gaps vs targets and list of Risk & Opportunities from BU’s to facilitate decision-making at Total Brand level and strategy execution.
Plan/LE updates
Own the generation of the demand latest estimate for the category:
- Connect with NPD (new launches not yet in JDA), with Brands Finance (Strat Plan), Trade Marketing & Lifecycle to obtain all relevant building blocks for the category demand plan.
- Build projection for category with validated sourcing plan.
Initiative forecasting & performance
Collaborate with Innovations Team to align and monitor innovation category forecast and performance.
- Collaborate with lifecycle to align and validate initiative sizing.
- Upload Operational Forecast in JDA for Giftsets and Y1 Innovations before markets forecast upload.
- Track forecast evolution versus Execute gate; and versus previous S&OP submissions.
Key Competencies
- Fluent in English (written and spoken).
- Excellent business communication skills (written and verbal) and collaborative skills.
- Strong business understanding – ability to ask the right questions to identify and solve a problem.
- Inspiring communicator towards various backgrounds attendance/departments.
- Ability to work self-sufficiently - organized and energized to drive a monthly drumbeat.
- Problem-solving & scenario-building facilitator.
- Strong understanding and experience of the Demand & S&OP processes including key metrics.
- Strong analytical skills including good working knowledge of Excel and company demand planning software (JDA, MFR).
- VBA, Power BI knowledge will be an advantage.
- Passion for process standardization and continuous improvement.
- Very good understanding of Supply Chain (Planning, Procurement, Manufacturing, Logistics).