Manager, Brand DP IBP - APAC

Estee Lauder Cosmetics Pte Ltd; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

Estee Lauder Cosmetics Pte Ltd in Singapore seeks a Forecast Development professional to lead demand planning and forecasting activities for key brands. You will drive alignment with business objectives and ensure accurate data inputs for forecasting systems.

The role involves coordinating monthly reviews, developing robust demand plans, and guiding brand launches and supply alignment across affiliates, channels, and markets.

Qualifications

• Minimum Education level: College degree or equivalent years of experience
• Minimum Years of Experience: 5+ years
• Knowledge of forecasting and replenishment systems such as JDA, JustEnough, SAP, I2
• Strong math and analytical skills
• Ability to analyze and review large amount of data in Excel or MS Access

Responsibilities

• Analyze total Affiliate / Brand demand plan at major category level to identify risks or opportunities and drive actions to close gaps identified.
• Analyze total key launches at the Affiliate / Brand level to ensure sufficiency and reasonability of new launches demand plan.
• Generate demand plans at the Affiliate level for assigned brands aligning with business objectives.
• Validate Affiliate/Cluster demand trends and entering accurate inputs into forecasting systems for modeling and analysis.
• Conduct monthly reviews of demand trends and sales driver assumptions to ensure accuracy across aggregation levels and channels.
• Maintain robust demand plans by optimizing statistical forecasting models and incorporating relevant sales drivers.
• Ensure timely adjustments across affiliates based on new product launches and market fluctuations.

Skills

Self starter

Fast learner

Organizational skills

Time management

Excel analysis

Collaboration

Analytical skills

Inventory planning

Communication

Forecasting knowledge

Retail planning

Data interpretation

System thinking

Education

College degree

Tools

o9

AFO

Power BI

JDA

JustEnough

SAP

I2

MS Access

Job description

Description

Forecast Development

• Analyze total Affiliate / Brand demand plan at the major category level (Skincare, Makeup) to identify any risks or opportunity, and drive decisions to close any gaps identified.
• Analyze total key launches at the Affiliate / Brand level to ensure sufficiency and reasonability of new launches demand plan, and drive actions to close any gaps identified.
• Generate demand plans at the Affiliate level for assigned brands, ensuring alignment with business objectives.
• Validate Affiliate/Cluster demand trends and key sales driver assumptions, entering accurate inputs into forecasting systems for effective modeling and analysis.
• Conduct monthly reviews of demand trends and sales driver assumptions to ensure the accuracy and reasonableness of demand plans across multiple aggregation levels, factoring in different sales channels.
• Maintain robust demand plans by optimizing the use of statistical forecasting models and incorporating relevant sales drivers for assigned brands at the Affiliate/Cluster levels.
• Ensure timely adjustments across affiliates based on emerging sales trends, with a particular focus on new product launches and market fluctuations.

Forecast Alignment

• Accountable for ensuring a comprehensive view of demand across both Basic and New SKUs within the Affiliate.
• Lead Brand Consensus meetings and selected Affiliate IBP, providing insights into demand trends, validating sales driver assumptions, and sharing scenario planning based on risk and opportunity assessments.
• Lead the gap management process during Brand Consensus and selected Affiliate IBP to address variances between demand plans, supply plans, and Latest Estimates (LE) and capturing major differences as part of risk and opportunity management.
• Implement a standardized process for sales driver reviews across affiliates, ensuring the most accurate and current market intelligence is integrated into the demand plans.
• Work closely with Brand General Managers to resolve demand imbalances and shape demand, particularly in scenarios of constrained supply.
• Prepare detailed reports, scenarios, and recommendations to support the Affiliate IBP on a monthly basis, and provide insights to the Regional IBP as needed.
• Escalate key insights and exceptions of Major Category/Heroes/New Launches/Channels at the Affiliate/Brand level to Affiliate and Regional Brand IBP, to drive decisions to close any exceptions.
• Collaborate with Affiliate / Execution planners and brand/commercial teams to manage and shape demand if/when required.

KPI & Process Improvement Management

• Act as a subject matter expert in systems (e.g. o9, AFO, Power BI), leading all systems training and enhancement initiatives within the Brand cluster.
• Act as a subject matter experts in processes (e.g. DP-Retail trend analysis, promo reconciliation), educating cross-functional teams within the Brand cluster.
• Review reasonability of Affiliate/Cluster/Major Category Statistical forecast on a rolling 12 months basis, and partner Global/Regional Stats team to drive ongoing improvements
• Develop and improve processes, tools and reports to drive continuous improvements and collaborations within the Brand cluster.
• Oversee the management of key demand planning metrics such as WFA, Bias, Attainment and FVA for the assigned brands.
• Identify and implement improvement initiatives across affiliates to enhance WFA performance by optimizing the adoption of statistical forecasting and sales drivers, conducting root-cause analyses to address gaps.

Qualifications

• Self starter and ability to work independently
• Fast learner
• Exceptional organizational and time management skills, ability to quickly reprioritize while still meeting deadlines
• Ability to analyze and review large amount of data in Excel or MS Access
• Collaboration across functional and regional teams
• Ability to succinctly summarize analysis results and recommend solutions for optimizing systems and processes
• Strong math and analytical skills
• Strong understanding of allocation and replenishment systems and parameters (safety stock, lead time,review cycle, etc.)
• Strong communication skills
• Knowledge of inventory models and metrics
• Deep understanding of retail planning and inventory management needs
• Prior experience using forecasting and replenishment systems such as JDA, JustEnough, SAP, I2
• Understanding of retail store operations and planning processes
• Minimum Education level: College degree or equivalent years of experience
• Minimum Years of Experience: 5+
• % Travel Time: 5%