Posted on 2021-10-14
Estee Lauder (Hong Kong) Limited

Senior Demand Planning & Inventory Management Executive

Estee Lauder (Hong Kong) Limited


  • Analyze historical sales trends and develop consensus forecast for Brands based on statistical forecast and sales drivers such as promotions and new product launches by closely communicating with sales & marketing team
  • Prepare and lead the Demand Review and SIOP meetings as part of the monthly SIOP process, focus the team on key trends insights and gain full alignment with business team on sales building block and demand plan vs. financial latest estimate
  • Conduct New Product pre & post launch analysis with brands and regional demand planning team and recommend actions for future launches based on historical insights
  • WFA (Weighted Forecast Accuracy) and Bias correction - conduct root-cause analysis for WFA and regular review of Bias to recommend intervention plans with the appropriate teams to drive improvement in forecast accuracy continuously
  • Leverage SAP & BI reporting analytics to correct forecast bias and improve consistency of attainment
  • Maintain the Demand Planning Attributes & Master data such as Characteristics Value Combinations (CVCs), Product lifecycle (PLC), Demand Type (DT), History Start Date (HSD), Phase out profile (PIO)
  • Optimize and monitor the inventory level, minimize excess and aging stock and keep track on stock clearance status with Brand
  • Ensure supply triggered and shipment is on track as per planned forecast and avoid out of stock situation and follow up ad-hoc stock request with demand changes
  • Manage phase in phase out process and minimize residual
  • Conducting analysis and reports on inventory planning and sales results
  • Support Brand and Finance team in the yearly budget preparation process
  • Prepare centralized reports for department
  • Perform ad-hoc SC projects assigned


  • Diploma in Business Administration, Logistics & Supply Chain, Marketing or above
  • 3 -5 years in demand planning and inventory management function in similar industry
  • Data sensitive and strong analytical skills
  • Strong communication skills in both English and Chinese
  • Ability to build strong relationships across functions and levels
  • Basic knowledge of sales strategy and brand positioning
  • Consumer packaged goods industry experience is a plus
  • Advanced computer skills in Excel (pivot tables, vlookups etc.)
  • Proficiency in SAP is a plus 
More job information
Job Function
  • Tsimshatsui
Employment Term
  • Full-time
  • 3 years - 5 years
Career Level
  • Entry level
  • Diploma or equivalent
  • Asso. Deg or High Dip
  • Degree