Demand Supply Planner

AlloFresh; Jakarta Pusat; On-site; IDR 120,000,000 - 180,000,000; Full time

Job summary

AlloFresh is seeking a data-driven professional in Jakarta to analyze inventory, sales, and supply data and to develop dashboards that provide visibility into inventory performance. You will support purchasing decisions by calculating replenishment quantities and monitoring stock levels.

The role involves extracting and analyzing data with SQL or Python, collaborating with stakeholders, and continuously improving planning processes to boost inventory efficiency.

Qualifications

• Bachelor's degree in Supply Chain Management or related field.
• Proficiency in SQL or Python is required.
• Experience building dashboards with Power BI, Tableau, or Looker Studio preferred.
• Fresh graduates welcome, especially with relevant projects or internships.

Responsibilities

• Analyze sales, inventory, and supply data to determine purchasing and replenishment requirements.
• Calculate recommended purchase quantities based on inventory levels and sales trends.
• Monitor inventory availability and identify stockout or overstock risks.
• Prepare and coordinate purchasing recommendations / PO quantities based on planning analysis.
• Develop, maintain, and improve dashboards and reports to monitor inventory, purchasing, and replenishment performance.
• Extract, clean, manipulate, and analyze data using SQL or Python.
• Provide data-driven insights and recommendations to support purchasing and supply decisions.
• Collaborate with stakeholders to align replenishment plans with business needs.
• Continuously improve planning processes, reporting, and analytical tools to improve inventory efficiency.

Skills

SQL

Python

Data analysis

Analytical thinking

Education

Bachelor's degree in Supply Chain Management or related field

Tools

Power BI

Tableau

Looker Studio

Job description

This role will be responsible for analyzing inventory, sales, and supply data to determine optimal purchasing and replenishment quantities. The role also develops and maintains dashboards to provide visibility on inventory and supply performance and support data-driven purchasing decisions.

Responsibilities

• Analyze sales, inventory, and supply data to determine purchasing and replenishment requirements.
• Calculate recommended purchase quantities based on inventory levels, sales trends, stock coverage, and replenishment needs.
• Monitor inventory availability and identify potential stockout or overstock risks.
• Prepare and coordinate purchasing recommendations / PO quantities based on planning analysis.
• Develop, maintain, and improve dashboards and reports to monitor inventory, purchasing, and replenishment performance.
• Extract, clean, manipulate, and analyze data using SQL or Python.
• Provide data-driven insights and recommendations to support purchasing and supply decisions.
• Collaborate with relevant stakeholders to ensure replenishment plans are aligned with business and operational needs.
• Continuously improve planning processes, reporting, and analytical tools to improve inventory efficiency.

Requirements

• Bachelor's degree in Supply Chain Management, Industrial Engineering, Statistics, Mathematics, Business Analytics, Information Systems, or a related field.
• Fresh graduates are welcome to apply, particularly candidates with relevant academic projects, internships, or certifications in data analytics, supply chain, SQL/Python, or dashboard development.
• Proficiency in SQL or Python is required.
• Strong analytical and numerical skills with the ability to work with large datasets.
• Experience in building dashboards using Power BI, Tableau, Looker Studio, or similar tools is preferred.
• Good understanding of inventory management, replenishment, purchasing, or supply chain processes.
• Detail-oriented, structured, and able to translate data into actionable recommendations.