Job Details
| Field | Detail |
|---|---|
| Posisi | Operation Analyst Officer / Data Analyst Officer |
| Department | Business Intelligence Team |
| Reports to | Data Analyst Lead |
| Lokasi | Jakarta (Head Office), On-site |
| Posted by | Ramadhiyan Firdan — Head of Business Intelligence |
Job Summary
Operation Analyst Officer berperan sebagai analytics partner untuk tim Operations Fore Coffee — menerjemahkan data store operations, supply chain, dan product performance menjadi actionable insights. Role ini bertanggung jawab membangun dashboard, melakukan analisis mendalam terhadap performa outlet dan supply chain, serta memberikan rekomendasi data-driven untuk meningkatkan efisiensi operasional, produktivitas store, dan customer experience.
Incumbent akan bekerja erat dengan tim Store Operations, Supply Chain, Product, dan Finance untuk memastikan keputusan operasional didasarkan pada data yang akurat, tepat waktu, dan relevan.
Requirements Mapping
Setiap requirement dari job posting dipetakan ke bagian spesifik dari portfolio ini — menunjukkan bahwa skill yang diminta sudah didemonstrasikan secara konkret.
| # | Requirement | Demonstrasi di Portfolio |
|---|---|---|
| 1 | 2–4 tahun DA/BA/Ops Analyst | Store performance analysis across 350 outlets — ranking, regional analysis, weekend pattern, channel mix. Bukan analisis sederhana, tapi multi-dimensional. |
| 2 | Strong SQL | Data cleaning logic (6 jenis anomali), aggregation (GROUP BY outlet, city, category), cross-validation vs master data. Pipeline berpikir SQL-native. |
| 3 | Looker Studio / viz tools | Chart.js visualizations (bar, doughnut, scatter, line) — 8+ chart interaktif di Page 04 dan 06. Portfolio dashboard ini sendiri adalah bukti kemampuan visualisasi. |
| 4 | F&B background preferred | Fore Coffee domain: menu analysis (34 items, 7 kategori), channel mix (6 channels), peak hours pattern, outlet concept segmentation. Bukan generic — spesifik F&B. |
| 5 | Stakeholder communication | Executive summary untuk board meeting (Page 03), rekomendasi quantified dengan projected impact, narasi bisnis yang jelas dari konteks → pertanyaan → temuan → aksi. |
Key Questions from the Role
Langsung dari LinkedIn post Ramadhiyan Firdan (Head of BI) — 4 pertanyaan yang akan dihadapi sehari-hari di role ini, dan di mana portfolio ini menjawabnya.
"Why is this outlet outperforming the cluster?"
→ Page 03 (Temuan): Outlet ranking, top/bottom analysis, revenue gap 2.84x. Page 06 (Deep Dive): Store concept segmentation, geographic distribution, proximity analysis.
"Where is wastage hiding?"
→ Page 05 (Report Data): Cleaning log detail, anomaly breakdown, data quality metrics. Page 04_cara_kerja: Data pipeline methodology, cross-validation process.
"Which menu items are quietly cannibalizing the bestsellers?"
→ Page 03 (Temuan): Menu analysis — Fore Signature 50.5%, category breakdown, Tea underperformance. Page 04 (Visualisasi): Top 10 menu chart, category revenue visualization.
"How do we forecast demand better next quarter?"
→ Page 03 (Temuan): Weekend boost +21.1% (structural pattern, bukan seasonal). Page 06 (Deep Dive): Proximity analysis untuk new outlet placement, store age analysis untuk ramp-up timeline.
Responsibilities Mapping
5 key responsibilities dari job description, masing-masing dipetakan ke section spesifik di portfolio.
| # | Responsibility | Portfolio Section |
|---|---|---|
| 1 | Monitor & analyze store KPIs, performance trends, crew productivity | Page 03: Outlet ranking, weekend pattern. Page 05: Full ranking data, trend analysis. Page 06: Store concept performance. |
| 2 | Evaluate supply chain & inventory performance | Page 03: Data quality findings (95 anomali = sistem issue). Page 04_cara_kerja: Cleaning pipeline, cross-validation methodology. |
| 3 | Analyze product & menu performance, pricing, promotions | Page 03: Fore Signature dominance, menu rationalization rekom. Page 04: Category revenue chart, top 10 menu chart. |
| 4 | Develop dashboards & reports, present insights | Seluruh portfolio: 8 halaman interaktif, 8+ chart, executive summary, bilingual (ID/EN). Portfolio ini sendiri adalah dashboard. |
| 5 | Ensure data accuracy, improve reporting processes | Page 05: Cleaning log detail. Page 04_cara_kerja: Reproducibility (seed=42), expected_values.json, auto-grader checker.py. |
✅ Portfolio ini mendemonstrasikan semua 5 key responsibilities
Dari data cleaning hingga executive summary, dari visualisasi hingga stakeholder communication — setiap aspek dari job description tercakup di portfolio ini. Bukan hanya teori, tapi implementasi konkret dengan data real (350 outlet dari API) dan analisis mendalam (16,229 transaksi bersih).
💡 Beyond the Job Description
Portfolio ini juga menunjukkan kemampuan tambahan yang tidak diminta tapi valuable: (1) Web development untuk portfolio interaktif, (2) Bilingual communication (ID/EN), (3) API scraping untuk data collection, (4) Haversine proximity analysis untuk location intelligence, (5) Reproducible analysis pipeline dengan version control.