Demand Planning and Analysis Specialist

This role is critical in driving the success of our private label portfolio spanning 100-150 SKUs across all product categories. The ideal candidate will independently manage demand forecasting, inventory planning, and provide analytical insights to support both the Private Label BU and Marketing Department in strategic decision-making.Responsibilities1. Demand Planning and Forecasting (40% of the workload): a. Develop and maintain accurate demand forecasts for 150-200 private label SKUs across all categories (current and future products)b. Create rolling 12-months demand plans using statistical forecasting methods and market intelligencec. Analyze historical sales data, seasonality trends, market trends, and promotional impacts to improve forecast accuracyd. Monitor forecast accuracy KPIs and implement continuous improvement initiativese. Manage transition from current legacy system to MS Dynamics for planning processes2. Managing new products launches (15% of the workload):a. Determine launch volume forecasts for new private label productsb. Collaborate with Marketing to understand launch strategies and promotional plansc. Monitor post-launch performance and adjust forecasts accordinglyd. Provide recommendations for phase-out of underperforming SKUse. Track suppliers performance and related demand/ consumption figures3. Stock management (15% of the workload):a. Determine optimal inventory levels balancing service levels with working capital requirements and handling both local and imported productsb. Monitor stock levels and identify potential stockouts or excess inventory situationsc. Coordinate with procurement team member to ensure timely product availabilityd. Track and report on inventory KPIs including days of inventory, stock turns, and waste4. Business Analytics and Reporting (20% of the workload):a. Support Marketing Department with data-driven insights for campaign planning and any analytical requirementsb. Develop and maintain Power BI dashboards for real-time business performance monitoringc. Provide weekly/monthly reports on sales performance, forecast accuracy, and inventory metricsd. Conduct deep-dive analysis on category and SKU performance as needed Requirements Bachelor's degree in Business Administration, Business Studies, Supply Chain, or related field 3-5 years of experience in demand planning, preferably in FMCG industry Proven experience managing multiple SKUs across diverse product categories Experience with system migrations or implementations is a plus. Advanced Excel proficiency including complex formulas, pivot tables, macros, and data modeling Power BI expertise for dashboard creation and data visualization Experience with ERP systems; MS Dynamics knowledge is advantageous Strong understanding of statistical forecasting methods Proficiency in data analysis and interpretation Strong analytical and problem-solving abilities Excellent attention to detail with high accuracy standards Ability to work independently and manage multiple priorities Strong communication skills to present complex data insights clearly Proactive approach to identifying and resolving potential issues Comfortable working with ambiguity and changing priorities