In short
An onsite data analyst/automation role in Surabaya at an F&B lifestyle company: analyzing daily sales, supply-chain, and payment data, running demand forecasting and KPI reviews, and building Python/Apps Script/API automations including scheduled Claude Code AI workflows on a VPS.
About the role
Salary: Rp 5.333.333 – Rp 8.000.000 per month
Responsibilities:
1. Analyze daily operational data (sales, supply chain, payments, etc.) to detect and resolve anomalies and discrepancies.
2. Perform supply chain demand forecasting and regularly audit forecast accuracy.
3. Design, build, and maintain automations, including:
- Python scripts for data processing and validation
- Trigger-based spreadsheet automation (Apps Script)
- Data integration across systems via APIs
- Scheduled AI workflows powered by Claude Code running on a VPS.
4. Monitor all automations to ensure they run reliably, and troubleshoot errors or bugs as they arise.
5. Evaluate the Operations team’s performance against established KPIs.
6. Prepare monthly and other periodic reports for management.
7. Maintain the company’s spreadsheet files to keep them accurate and well-structured.
8. Coordinate with the Operations team to understand field requirements and translate them into formulas, systems, and reports.
Qualifications:
1. Bachelor’s degree in Statistics, Mathematics, Computer Science, or a related field.
2. 1–2 years of experience as a Data Analyst, preferably in the F&B industry.
3. Proficient in Python, Excel, and Google Sheets.
4. Familiar with SQL and query writing.
5. Able to turn complex data into clear, actionable insights.
6. Detail-oriented, with a critical eye for numbers that don’t add up.
7. Innovative, highly proactive, and motivated to automate repetitive work.
8. Able to communicate clearly with non-technical teams.
9. Nice to have: Apps Script, Claude Code or similar AI coding tools, Git, databases, and VPS.
Requirements
- Bachelor's degree in Statistics, Mathematics, Computer Science, or a related field
- 1-2 years of experience as a Data Analyst
- Proficient in Python, Excel, and Google Sheets