Demand Forecasting

Role \& Responsibilities

Forecast Generation: Build and maintain rolling 3–6 months SKU-level demand models factoring in seasonality, historical trends, and new product launches (NPD).

S\&OP / IBP Facilitation: Lead monthly consensus meetings with Sales, Marketing, and Finance to reconcile commercial targets with operational constraints.

Promotional \& Market Alignment: Integrate inputs from trade marketing plans, consumer promotions, and competitor activities into baseline volume adjustments.

KPI Tracking: Monitor and report key metrics including Forecast Accuracy (FA/MAPE) and Forecast Bias (FB) at various aggregations (channels, regions, SKUs). Track, analyze, and publish monthly Forecast Accuracy and Forecast Bias reports, pinpointing root causes of error.

NPD Planning

Partner with Marketing to estimate volumes for New Product Developments (NPDs).

Exception Management

Identify and investigate demand spikes or drops to adjust future statistical baselines.

• Dashboard Ownership: Design and maintain automated data models, trackers, and Power BI/Tableau dashboards to report demand metrics.
• Executive Reporting: Prepare comprehensive Management Information System (MIS) packs highlighting inventory risks, stock-outs, and demand vs. financial plan gaps.
• Scenario Planning: Build "what-if" demand scenarios to support risk assessment and strategic decision-making during leadership reviews.
• Action Tracking: Monitor cross-functional action items from S\&OP cycles to ensure deadlines are met before the final supply lock.Design and automate dashboards for sales, inventory, and forecast KPIs.
• Prepare MIS reports for leadership (sales vs forecast, stock cover, OTIF).
• Ensure data integrity across ERP/BI tools (SAP, Power BI, Tableau).
• Provide actionable insights from MIS reports to improve operational efficiency.
• * Skills \& QualificationsEducation: Bachelor’s degree in Supply Chain, Statistics, Economics, Engineering
• Experience: 2 to 3 years of relevant experience within an FMCG handling demand forecasting of large SKU portfolios.
• Technical Stack: Advanced Excel (modeling, macros, power query), ERP/Planning systems (SAP APO/IBP, Oracle Demantra, Anaplan, or Kinaxis), and BI reporting tools (Power BI/Tableau).

Soft Skills: Exceptional stakeholder influencing, cross-functional communication, and conflict resolution capabilities. and bridge the gap between commercial and operations teams.

Must-Have

• Excel (PivotTables, VLOOKUP, XLOOKUP, forecasting models)
• Power BI or Tableau (dashboard creation, data visualization)
• ERP systems (SAP, Oracle, NetSuite, or similar)
• Demand planning methodologies (statistical forecasting, driver-based modeling)

Preferred

• Experience with retail or D2C beauty/personal care categories
• Working knowledge of SQL or Python for data extraction and automation

Benefits \& Culture Highlights

• Onsite work in a collaborative, agile team environment with direct exposure to leadership and cross-functional squads.

Pay

Up to ₹1,000,000.00 per year

Benefits

• Food provided
• Paid sick time
• Provident Fund

Work Location

In person