Commercial & Planning Analyst

Elite Beauty Asia; Kuala Lumpur; On-site; MYR 100,000 - 150,000; Full time

Job summary

A leading FMCG company in Kuala Lumpur seeks a Commercial & Planning Analyst to bridge Sales and Supply Chain functions. This role involves demand planning, inventory management, and business performance reporting. Candidates should hold a Bachelor's degree and possess at least 2-3 years of relevant experience, particularly in demand planning and data analysis. Proficiency in Microsoft Excel is essential for success in this dynamic environment.

Qualifications

• Minimum 2-3 years of experience in a similar role in FMCG.
• Expert-level proficiency in Microsoft Excel for data analysis.
• Experience in handling Purchase Order management and delivery tracking.

Responsibilities

• Serve as Primary Supply Chain contact for Sales team.
• Develop and consolidate demand forecasts using market intelligence.
• Monitor regional inventory levels to minimize obsolescence.

Skills

FMCG experience

Data analysis

Demand forecasting

Communication skills

Excel proficiency

Education

Bachelor’s degree in Business, Supply Chain, Statistics or related field

Tools

Microsoft Excel

Job description

Commercial & Planning Analyst (Experience in the FMCG industry is preferred)

This role serves as the critical operational and analytical hub between Commercial (Sales) and Supply Chain functions, with additional responsibility for regional business performance reporting. The incumbent ensures seamless execution of the Sales & Operations Planning (SOP) process and provides data-driven insights to support strategic decision‑making.

Job Responsibilities :

Demand Planning & Sales Liaison

Serve as the primary Supply Chain point of contact for the Sales team, managing all communication regarding order fulfilment, inventory availability, and supply constraints.

Collaborate with Sales and Key Account Managers to develop, consolidate, and challenge rolling demand forecasts (by SKU, customer, and region), utilizing historical data, market intelligence, and promotional plans.

Drive forecast accuracy by providing Sales teams with regular performance reports on forecast vs. actuals, in‑stock rates, and customer service levels.

Translate commercial strategies and promotional calendars into actionable supply plans, ensuring the supply chain is prepared for forecasted demand spikes.

Supply Coordination & Inventory Management

Convert the approved demand plan into an executable supply plan by coordinating closely with Supply Chain, product team and lead times.

Monitor and manage regional inventory levels (safety stock, days of cover) to achieve target customer service levels while minimizing obsolescence and carrying costs.

Facilitate efficient order allocation and timely customer deliveries by working with supply chain team.

Proactively manage daily supply exceptions (e.g., production delays, quality issues, logistics disruptions). Develop and communicate contingency plans to mitigate impact on customer service.

Business Performance & Executive Reporting

Lead or actively participate in the monthly SOP cycle, preparing data and analyses to facilitate cross‑functional dialogue.

Act as the consolidation point for regional performance data (e.g., sales, shipments, inventory, forecast accuracy) from all markets or business units.

Generate and distribute standardized and ad‑hoc executive reports for regional leadership, ensuring timely and accurate submission.

Prepare presentation materials, dashboards, and performance summaries to support senior leadership in business reviews and strategic planning sessions.

Job Requirement :

Bachelor’s degree in Business, Supply Chain, Statistics, or a related field.

Minimum 2-3 years of direct experience in an FMCG company in a similar role (Demand Planning, Supply Chain Analyst, Sales Analyst).

Expert-level proficiency in Microsoft Excel (mandatory: PivotTables, VLOOKUP/XLOOKUP, SUMIFS, Charts) for data analysis and reporting.

Proven experience in handling end‑to‑end Purchase Order (PO) management and tracking on‑time delivery to retailers.

Hands‑on experience with inventory management, sales analysis, and demand forecasting in a fast‑paced environment. Exceptional follow‑up and coordination skills – must be persistent, organized, and able to drive issues to resolution.

Strong communication skills to interact effectively with sales teams, supply chain, and external partners.