Demand Forecasting Data Analyst - Automation & Insights

Astro Indonesia; Jakarta Utara; On-site; IDR 120,000,000 - 180,000,000; Full time

Job summary

Astro Indonesia is seeking a Data Analyst to support the Demand Planning team, improving forecast accuracy and reliability. You will analyze sales and demand patterns, develop forecasting logic, and build automated tools to support inventory decisions and timely fulfillment.

Collaborate across functions to turn data into practical forecasting solutions and improve product availability. The role emphasizes building scalable data products and maintaining robust forecasting pipelines.

Qualifications

• Minimum 1–3 years of experience as a Data Analyst, BI Analyst, Analytics Engineer, or similar.
• Strong SQL skills and experience with BigQuery or another cloud data warehouse.
• Proficiency in Python for data analysis, automation, and/or pipeline development.
• Understanding of demand forecasting concepts and evaluation metrics (baseline, seasonality, trends).
• Experience building dashboards, automated reports, data pipelines, monitoring tools, or alerts.
• Strong problem-solving, root-cause analysis, and data-validation skills.
• Ability to communicate technical analysis clearly to non-technical stakeholders.

Responsibilities

• Analyze demand patterns across SKU, hub, category, time period, campaign, price changes, and seasonal events.
• Develop, evaluate, and improve demand forecasting logic; monitor forecast performance.
• Translate findings into clear recommendations for Demand Planners and Supply Chain stakeholders.
• Translate business requirements into scalable data solutions: datasets, dashboards, alerts, and automated workflows.
• Build and maintain data models and pipelines supporting forecasting processes.
• Automate manual forecasting and monitoring using SQL, Python, BigQuery, and DAGs.
• Maintain documentation for logic, data lineage, and runbooks.
• Ensure reliability of daily forecasting pipelines and report-refresh processes.
• Troubleshoot data-quality issues and pipeline failures; perform backfills if needed.
• Collaborate with Data Engineering, Data Science, and Product teams to improve forecasting systems.

Skills

SQL skills

Python for data analysis

Demand forecasting concepts

Dashboarding & reporting

Data validation

Tools

BigQuery

Google Sheets

Airflow/Composer

Git

Google Data Studio

Apache Superset

Google Cloud Platform

Job description

Astro Indonesia is seeking a Data Analyst to support the Demand Planning team, improving forecast accuracy and reliability. You will analyze sales and demand patterns, develop forecasting logic, and build automated tools to support inventory decisions and timely fulfillment.

Collaborate across functions to turn data into practical forecasting solutions and improve product availability. The role emphasizes building scalable data products and maintaining robust forecasting pipelines.