Category Demand Supply Planner

Category Demand Supply Planner

OUR VALUE PROPOSITION:

We have a powerful culture that fuses aspirations, uniqueness, authenticity and valued by each and every Sephora member – These are the values:

• Beauty & Beyond: We reimagine beauty by inspiring our customers, empowering people and helping them become the best versions of themselves.
• Creativity Unleashed: We encourage exploration, innovation and having fun.
• Endless Evolution: At Sephora you are empowered to choose your own path and accelerate your growth.
• Boldly Authentic: We celebrate diversity and embrace your unique and winning spirit

POSITION PURPOSE

The Demand & Supply Planner is responsible to ensure that the right products are available in the right quantities at the right time to meet customer demand while minimizing excess inventory and associated costs.

KEY ACCOUNTABILITIES

• Successfully completing all Demand and Supply Planning activities for a Category in an omni-channel environment (Retail and Ecommerce) to ensure stock availability.

• Develop collaboration with Category Management Team and Brands by giving visibility of the forecast and sharing KPI (On Shelf availability, Forecast Accuracy, Stock Cover)
• Manage inventory to ensure replenishment activity related issues are resolved proactively and collaborate with other cross-functional stakeholders such as Logistics, Category Management, Commercial team and Master Data

Demand Planning: Regional omni-channel scope

• Validate and adjust proposed baseline forecast within the Planning System
• Manage Animation & Newness forecasts for all brands for both Retail and Ecommerce:
  • Initialization with Data from Offer or Stores Teams
  • Forecast adjustment based on the initial sales both in stores and online

• Prepare in monthly cross-department collaboration meetings with analysis:
  • Forecast Meetings
  • Launches Review
  • Stock Meetings
  • Supplier evaluation meetings (any key callouts on KPIs/performance)

• Ensures the overall forecast is consistent with historical sales of products, trend, and planned events (Operations, Media Campaigns, Ramadan etc.) and considers the impact of product cannibalization, defined in collaboration with Catman
• Analyze of Forecast Accuracy, monitoring and communicating internally any concerns and managing appropriate corrective actions
• Conduct analysis on Out-of-stock instances after analyzing reports as part of order check and adjustment process that is carried out weekly
• Support the development and evolution of all Forecasting processes and systems
• Follow the processes implemented for the Demand planning scope
• Build strong relationship with internal Category Merchandising Team and external Brand Teams for all interrelated activities
• Analyze reports for over and under forecasting for novelty products, review and analyze the updated plan with Catman and address forecast adjustments

Supply Planning & Purchasing: Lead the regional replenishment of Retail and E-store assortment

• Ensure optimal product availability on shelves in all stores through replenishment order calculations with the replenishment tool
• Manage the purchasing plan through optimum use of the Planning system (Leadtime, frequency of orders, safety stock)
• Calculate stock rebalancing needs between stores through optimum use of parameters (Excess stock, cover stock)
• Manage In & outbound Orders for the brands managed through the warehouse
• Apply stock policy per brand/per ABC/per country
• Support Logistics Team (KSA and Dubai team) with the purchase order process, validating and advising urgent orders
• Optimize stock returns & transfer opportunities between all Stores: Identify overstock and propose action plan to Category Management and Negotiation team
• Ensure stock availability during roll out of new brand/stores with right opening order quantity and effectively managing transfers within the network.
• Collaborate with Regulatory Team to ensure products are in line with regulations & compliance for all Markets
• Communicate with KSA Head office Supply Chain Team to support their local KSA activities
• Share Purchasing plan with defined suppliers after validation with Category Management
• Track the supplier Fill Rate to alert Category Managers and challenge the brands during meetings
• Carry out stock management and transfer activities as per the defined process

Reporting, System Improvement, Stock balancing, and Analysis

• KPI’s: In-Stock, Days of Inventory, Supplier Fill Rate, Forecast Accuracy, Inventory Value, Brand Analysis etc.
• Prepare action plans with Category-Management and Finance Teams for slow movers and obsoletes to secure a good stock quality
• Prepare Supply Chain reports to support brand negotiations by the Category Merchandising Team
• Participate and prepare with Category management meetings with brands
• Contribute to key projects or process improvement related to Supply Chain

SKILLS, EXPERIENCE AND PERSONALITY

• Minimum 5 years in Demand, Supply & Inventory Planning experience required
• Experience in utilizing ERP systems (SAP preferred)
• Expert at utilizing & developing good statistical models and forecasting software
• Strong Excel, PowerPoint, Database, Reporting system skills (Power BI)
• Analytical mind and problem-solving attitude
• Outstanding organizational ability & flexibility
• Collaborative and team-oriented spirit