Commercial Analyst

Astro Technologies Indonesia; Jakarta Barat; Hybrid; IDR 1,071,360,000 - 2,008,800,000; Full time

Job summary

Astro Technologies Indonesia mencari Margin Controller Associate untuk memantau kinerja komersial dan peluang peningkatan margin di seluruh merek, vendor, kategori, SKU, saluran, dan hub. Anda bekerja sama dengan tim Commercial, Category, Campaign, Pricing, dan CorpFin untuk mengubah data menjadi insight yang mendorong margin.

Peran melibatkan pembaruan dashboard mingguan, analisis metrik utama, serta dukungan inisiatif harga, promosi, dan negosiasi dengan vendor.

Qualifications

• Memiliki kemampuan analisis data yang kuat dan mampu menerjemahkan data menjadi rekomendasi aksi.
• Menguasai Excel/Google Sheets dan SQL untuk analisis data margin dan KPI.
• Kemampuan berpikir strategis, proaktif, dan komunikatif untuk bekerja lintas fungsi.

Responsibilities

• Memantau dashboard tingkat SKU mingguan untuk memantau margin, penjualan, dan profitabilitas.
• Menganalisis kinerja merek, vendor, kategori, SKU, saluran, dan hub untuk menemukan celah dan peluang perbaikan margin.
• Mendukung inisiatif peningkatan margin seperti negosiasi terms, rebate vendor, pricing, promosi, dan prioritisasi SKU/kategori.
• Melacak kinerja inisiatif dengan membandingkan target vs realisasi dan dampak finansial.
• Membantu validasi data dan investigasi masalah terkait pricing, shrinkage, dan deviasi biaya.

Job description

DESKRIPSI PEKERJAAN

About this Position

We’re looking for a Margin Controller Associate to monitor commercial performance and identify opportunities to improve margin and profitability across brands, vendors, categories, SKUs, channels, and hubs. You’ll work closely with Commercial, Category, Campaign, Pricing, and CorpFin teams to turn data into actionable insights and support margin improvement initiatives.

Job Description

As our Astronaut, your missions are:

• Maintain and update weekly SKU-level dashboards across stores, platforms, and hubs to monitor key commercial performance metrics, including sales, margin, and profitability.
• Analyse brand, vendor, category, SKU, channel, and hub performance across key metrics such as sales, margin components (front margin, back margin, ads, etc.), profitability, OOS, AOV, and CVR to identify performance gaps, issues, and improvement opportunities.
• Support commercial and margin improvement initiatives, including trading terms, vendor rebates, pricing, promotions, SKU/category prioritization, and other initiatives to drive revenue growth and profitability.
• Track and evaluate initiative performance by monitoring targets, actual results, and financial impact, and support follow-up actions when performance is below expectations.
• Assist in data validation and issue investigation, including identifying data discrepancies and supporting root-cause analysis for pricing, shrinkage, cost deviations, and other margin-related issues
• Prepare reports, dashboards, and insight packs and collaborate with Commercial, Category, Operations, Supply Chain, and Finance teams to support decision-making and process improvements.

KUALIFIKASI MINIMUM

In order to launch the missions successfully, you need to have:

• Bachelor’s degree in Business, Economics, Engineering, Mathematics, Statistics, or other relevant fields.
• 1–2 years of experience in Commercial, Business Analysis, Revenue Management, Category Management, E-commerce, or Retail. Fresh graduates with strong analytical/project experience may also be considered.
• Strong Excel/Google Sheets and SQL skills and good understanding of sales, margin components (front margin, back margin, ads), profitability, OOS, AOV, and CVR.
• Strategic Thinking: Able to connect data with business performance, identify opportunities/risks, and translate insights into actionable recommendations.
• Proactive in identifying problems and opportunities, taking ownership, and driving tasks from analysis through follow-up.
• Structured thinker with strong attention to detail and communication skills, comfortable working cross-functionally in a fast-paced environment.

RINGKASAN PERKERJAAN

• *SPESIALISASI**: Skilled Trade
• *PENDIDIKAN MINIMAL**: S1 (Sarjana)
• *SISTEM KERJA**: Hibrid
• *TIPE PEKERJAAN**: Full time
• *LOKASI**: West Jakarta, DKI Jakarta, Indonesia
• *INDUSTRI**: E-Commerce
• *SITUS PERUSAHAAN**: http://www.astronauts.id

TENTANG PERUSAHAAN

ASTRO is Indonesia's quick commerce company that delivers groceries and essentials to your door within minutes. Founded in 2021 by a group of seasoned e-commerce executives and backed by both trusted International and local 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.
Interested in working for a company that pushes the boundaries and strives to be the best?