Demand Planning Intern

ASTRO; Jakarta Pusat; On-site; IDR 33,480,000 - 66,960,000; Part time

Job summary

ASTRO, Indonesia's quick commerce company, seeks a Demand Planning Intern to support forecasting across Fresh categories and ensure product availability. You will work with data, review SKU forecasts, and translate insights into planning decisions in Jakarta.

You will gain hands-on experience in forecasting, data analysis, and cross-functional collaboration with the Demand Planning and Supply Order teams during a 6-month internship in Jakarta.

Qualifications

• Fresh graduate preferably from STEM, Statistics, Mathematics, Industrial Engineering, Information Systems, or other relevant majors.
• Strong analytical and numerical skills with good attention to detail.
• Creative, agile, and proactive in finding and resolving problems.
• Comfortable working with large datasets and performing repetitive data-checking activities with accuracy.
• Proficient in Microsoft Excel / Google Sheets; experience with data visualization or SQL is a plus.
• Able to follow SOPs and maintain consistency in daily and weekly operational processes.
• Good problem-solving skills and ability to identify data anomalies or inconsistencies.
• Good communication skills and ability to coordinate with cross-functional teams.
• Able to commit to an internship period of 6 months and work in Jakarta.

Responsibilities

• Support daily demand forecasting activities for Fresh products by running and reviewing SKU and SKU × Hub forecasts through the SCMS Demand Planning dashboard.
• Perform forecast adjustments and apply appropriate reason codes based on established SOPs and business inputs.
• Prepare and submit the weekly packaging forecast and ensure timely handoff to the Supply Order team.
• Support the preparation of the Demand Planning weekly report, particularly the Fresh section.
• Monitor forecast accuracy and flag significant variances, anomalies, or potential demand risks to the Demand Planning team.
• Maintain accurate and timely forecasting records and ensure all reporting and forecast cycles are completed according to schedule.
• Support ad hoc data analysis and operational tasks related to demand planning and inventory availability.
• Align forecasts with top-down targets and promo plans, communicate changes clearly, address issues, and provide relevant recommendations to stakeholders.
• Translate complex data into useful insights and communicate them clearly to support stakeholders in making informed decisions.
• Approach problems creatively and proactively, while developing sustainable, long-term solutions to address recurring issues.

Skills

Analytical skills

Attention to detail

Problem solving

Excel / Google Sheets

Data visualization

Communication

Cross-functional coordination

Tools

SQL

Job description

ASTRO is Indonesia's quick commerce company that delivers groceries and essentials to your door within 15 minutes. Founded in 2021 by a group of seasoned e-commerce executives and backed by trusted international investors, it is our mission to make people's lives simpler and easier by saving them time, energy, and money.

Just like real Astronauts that take off into outer space, Astro embodies the values of being fast, bold, adventurous, and technologically advanced.

About this role

As a Demand Planning Intern, you'll support daily forecasting activities, monitor demand trends, and ensure product availability across our Fresh categories. You'll work with data, identify forecast variances, and help turn insights into better demand planning decisions.

Job Description

• Support daily demand forecasting activities for Fresh products by running and reviewing SKU and SKU × Hub forecasts through the SCMS Demand Planning dashboard.
• Perform forecast adjustments and apply appropriate reason codes based on established SOPs and business inputs.
• Prepare and submit the weekly packaging forecast and ensure timely handoff to the Supply Order team.
• Support the preparation of the Demand Planning weekly report, particularly the Fresh section.
• Monitor forecast accuracy and flag significant variances, anomalies, or potential demand risks to the Demand Planning team.
• Maintain accurate and timely forecasting records and ensure all reporting and forecast cycles are completed according to schedule.
• Support ad hoc data analysis and operational tasks related to demand planning and inventory availability.
• Align forecasts with top-down targets and promo plans, communicate changes clearly, address issues, and provide relevant recommendations to stakeholders.
• Translate complex data into useful insights and communicate them clearly to support stakeholders in making informed decisions.
• Approach problems creatively and proactively, while developing sustainable, long-term solutions to address recurring issues.

Minimum Qualifications

• Fresh graduate preferably from STEM, Statistics, Mathematics, Industrial Engineering, Information Systems, or other relevant majors..
• Strong analytical and numerical skills with good attention to detail.
• Creative, agile, and proactive in finding and resolving problems.
• Comfortable working with large datasets and performing repetitive data-checking activities with accuracy.
• Proficient in Microsoft Excel / Google Sheets; experience with data visualization or SQL is a plus.
• Able to follow SOPs and maintain consistency in daily and weekly operational processes.
• Good problem-solving skills and ability to identify data anomalies or inconsistencies.
• Good communication skills and ability to coordinate with cross-functional teams.
• Able to commit to an internship period of 6 months and work in Jakarta.