Demand & Supply Planner

at  Sephora

KEY ACCOUNTABILITIES

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 call-outs 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 evolvement of all Forecasting processes and systems.
• Follow the processes implemented for the Demand planning scope.
• Plan new Stores/re-fit of current stores in line with expectations and brand layout.
• 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 Catman and Negotiation team.
• Ensure roll-out of brands and new stores/re-fits are managed effectively and maximizes utilization of transfers.
• Collaboratively work with Compliance Team to ensure we are shipping items 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 Catman.
• Track the supplier Fill Rate to alert Offer and challenge the brands during the collaboration meeting.
• 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 Catman meetings with brands.
• Contribute to key projects or process improvement related to Supply Chain.

SKILLS, EXPERIENCE AND PERSONALITY

• Master’s degree (preferred) in Supply Chain, Business Administration or Engineering
• 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
• Analytical mind and problem-solving aptitude
• Outstanding organizational ability & flexibility
• Open minded and team-oriented spirit

• Successfully completing all Demand and Supply Planning activities for a Category in an omni-channel environment (Retail and Ecommerce), with a key focus on Ecommerce to ensure always in stock.
• 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, Offer, Commercial team and Master Data.