Share this Job

Req ID




Req ID:  87692
Function:  Supply Chain
Posted:  Mar 16, 2023

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).


Country/Region:  NL
City:  Amsterdam