Demand Supply Planner

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

Job summary

AlloFresh in Jakarta is seeking an Inventory Analytics Associate to analyze sales, inventory, and supply data to guide purchasing and replenishment decisions. You will develop dashboards to provide visibility into inventory and supplier performance and support data-driven procurement.

The role requires proficiency in SQL or Python, strong analytical skills, and experience building dashboards with Power BI/Tableau/Looker Studio.

Qualifications

• Bachelor's degree in relevant field (or related)
• Fresh graduates welcome, with relevant projects/internships/certifications in data analytics, supply chain, SQL/Python, or dashboard development
• Proficiency in SQL or Python required
• Strong analytical and numerical skills with ability to work with large datasets
• Experience building dashboards using Power BI, Tableau, Looker Studio, or similar tools
• Good understanding of inventory management, replenishment, purchasing, or supply chain processes
• Detail-oriented, structured, and able to translate data into actionable recommendations

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

Skills

SQL

Python

Data analysis

Dashboard development

Education

Bachelor's degree in Supply Chain Management, Industrial Engineering, Statistics, Mathematics, Business Analytics, Information Systems

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.