Demand Planner Senior Executive / Assistant Manager

ELITE BEAUTY ASIA (MALAYSIA) SDN. BHD; Kuala Lumpur; On-site; MYR 70,000 - 100,000; Full time

Job summary

ELITE BEAUTY ASIA (MALAYSIA) SDN. BHD is seeking a Demand Planner Senior Executive / Assistant Manager in Kuala Lumpur.

The role focuses on accurate sales forecasting, inventory planning, and replenishment to optimize product availability while minimizing risk. You will coordinate with Sales, Marketing, E-commerce and Supply Chain, leverage ERP, Excel modelling, and data analysis to improve forecast accuracy and inventory performance.

Qualifications

• Bachelor’s degree or above in Statistics, Mathematics, SCM, Economics, Business Administration or related discipline.
• Around 4 years (minimum 3) of experience in demand planning, supply chain planning or sales operations; experience in consumer goods preferred.
• Proficient in Excel and standard office software: pivot tables, VLOOKUP/XLOOKUP, SUMIFS, INDEX-MATCH; Power Query or Power BI is an advantage.
• Working knowledge of ERP/WMS; SAP or comparable system preferred.
• High attention to detail and data accuracy; able to spot anomalies and ensure data quality.
• Strong cross‑functional communication; English as working language.
• Willing to work extended hours during month-end closing, campaigns, stocktakes.

Responsibilities

• Sales Forecasting: Build rolling demand forecasts by SKU, channel and month; track forecast accuracy and bias; refine monthly.
• S&OP Process: Chair monthly demand–supply balancing meetings; align teams on forecasts and campaigns; track actions to closure.
• Inventory Planning: Set safety stock levels and replenishment; monitor stock health; drive stock reductions to minimise risk.
• Replenishment & Inbound Planning: Issue PO quantities; confirm lead times; track in-transit and inbound schedules.
• 3PL Data Coordination: Reconcile inbound/outbound stock data; support stock variance analysis and root cause attribution.
• Campaign & New Product Planning: Size stock for campaigns; prepare launch stock plans.
• Data & Reporting: Use Excel for monthly forecasts and ERP parameter maintenance.

Skills

Forecasting

Demand planning

S&OP

Cross-functional communication

Excel advanced

Data accuracy

English proficiency

Education

Bachelor’s degree or above in Statistics, Mathematics, SCM, Economics, Business Admin or related

Tools

SAP

Power BI

Power Query

SQL

Python

ERP/WMS

Job description

Demand Planner Senior Executive / Assistant Manager

The Demand Planning position is responsible for driving accurate sales forecasting, inventory planning, and replenishment activities to ensure optimal product availability while minimizing inventory risk. This role coordinates cross-functionally with Sales, Marketing, E-commerce, Supply Chain, suppliers, and 3PL partners to balance demand and supply, support commercial campaigns and new product launches, and maintain healthy inventory levels. The position plays a key role in the S&OP process, leveraging data analysis and ERP systems to improve forecast accuracy, inventory performance, and overall supply chain efficiency.

Responsibilities

Sales Forecasting: Build rolling demand forecasts by SKU (stock keeping unit), channel and month, based on historical sales, seasonality, promotional activities, new product launches and channel trends; track forecast accuracy (MAPE (Mean Absolute Percentage Error)) and bias, review monthly and refine continuously.

S&OP (Sales & Operations Planning) Process: Prepare and chair the monthly demand–supply balancing meeting; align Sales, Marketing, E-commerce and Supply Chain on forecasts, stock build, new launches and campaign plans; issue minutes and track action items to closure.

Inventory Planning: Set safety stock levels and replenishment parameters per SKU; monitor inventory health (days of inventory, slow-moving and near-expiry risk); drive clearance and stock reduction actions to minimise scrap and expiry losses (aligned with FEFO (First-Expiry-First-Out) practices).

Replenishment & Inbound Planning: Issue purchase recommendations (suggested PO (purchase order) quantities); confirm lead times with suppliers and factories; track in-transit and inbound schedules; balance stock-out risk against capital tied up in inventory and avoid over-stocking.

3PL Data Coordination: Work with the Warehouse & Distribution Manager to reconcile inbound, outbound, in-transit and on‑hand stock data from Swift and YFL; support stock variance analysis (variance thresholds 0.03%–0.15%) and root‑cause attribution for stocktake discrepancies.

Campaign & New Product Planning: Size stock requirements for key campaign periods (11.11, 12.12, Ramadan/Raya, Chinese New Year); prepare launch distribution and first-order stock plans for new products.

Data & Reporting: Use Excel (pivot tables, functions, data modelling) as the primary tool to produce monthly demand forecasts, inventory health and supply–demand gap reports; maintain forecast and replenishment parameters in the ERP (Enterprise Resource Planning) system.

Job Specification / Requirements

Bachelor’s degree or above in Statistics, Mathematics, Supply Chain Management, Economics, Business Administration or a related discipline.

Around 4 years (minimum 3) of experience in demand planning, supply chain planning or sales operations; experience in consumer goods (beauty, personal care, FMCG (Fast-Moving Consumer Goods)) is preferred.

Proficient in Excel and standard office software: pivot tables, common functions (VLOOKUP/XLOOKUP, SUMIFS, INDEX-MATCH), charts and data modelling; Power Query or Power BI is an advantage.

Working knowledge of basic ERP/WMS (Warehouse Management System) document flows (PO, goods receipt, goods issue, stocktake); experience with SAP or a comparable system is preferred.

High attention to detail and patience with data: able to spot anomalies (negative stock, duplicate documents, inconsistent definitions) and takes pride in data accuracy.

Strong cross‑functional communication skills; able to run meetings independently and drive action items to closure. English as a working language (reports and documents are in English).

Willing to work extended hours during month‑end closing, campaign stock‑build periods and stocktakes.

Added Advantages

Full‑cycle S&OP process experience; knowledge of time‑series forecasting methods or hands‑on use of forecasting tools; demand planning experience in beauty/personal care (familiarity with expiry and batch management logic); ability to process data with SQL or Python.

BZU BZU is a holistic family care brand originated from Singapore and currently have presence in Singapore, Malaysia, Vietnam & Thailand. It offers a wide range of products that aim to protect, nurture our little ones and the whole family, ensuring they are always safe from harm.