Sales Analyst (Modern Trade)

SKINTIFIC; Jakarta Selatan; Vor Ort; IDR 180.000.000 - 240.000.000; Vollzeit

Zusammenfassung

SKINTIFIC is seeking a Modern Trade Sales Analyst in Jakarta Selatan to own recurring commercial reporting and perform deep-dive analyses. The role combines strong SQL, Excel, and BI development with daily collaboration with KAM and commercial stakeholders in a fast-paced FMCG environment.

The ideal candidate is commercially sharp, technically solid, proactive, and uses AI with judgment to enhance reporting quality while maintaining trust in numbers.

Qualifikationen

• Minimum 2 years of analytics or reporting experience.
• Strong analytical thinking and problem solving.
• Proactive ownership and clear communication with cross-functional teams.
• Experience partnering with sales/commercial stakeholders in fast-paced environments.
• Experience creating recurring weekly/monthly reports and dashboards.

Aufgaben

• Own recurring weekly and monthly Modern Trade reports.
• Partner with KAM and stakeholders; communicate clearly and validate figures.
• Spot report breaks, propose fixes, and prevent escalations.
• Break complex questions into steps and show work before answering.
• Run deep dives, build reusable models (Excel/BI) and derive recommendations.
• Develop BI reports or models in Power BI, Looker, or Tableau; ensure data quality.
• Write strong SQL with joins, grain, dedup and business-rule filters.
• Reconcile figures and apply AI to accelerate reporting while preserving accuracy.

Kenntnisse

SQL

Excel

BI development

Stakeholder mgmt

Analytical thinking

AI usage

Python basics

Tools

Power BI

Looker

Tableau

BigQuery

Jobbeschreibung

Modern Trade Sales Analyst

Jakarta Selatan | Work From Office | Full-time

At SKINTIFIC, we are continuously expanding our data and commercial analytics capabilities across nationwide Modern Trade operations.

We are looking for a Modern Trade Sales Analyst who will own recurring commercial reporting, run deep-dive analysis, build models the business can reuse, and keep numbers trusted without being chased. This role combines strong SQL, Excel, BI development, and day-to-day partnership with KAM and commercial stakeholders in a fast-paced FMCG environment.

This position is ideal for someone who is commercially sharp, technically solid, proactive, and uses AI with judgment - not as a copy-paste shortcut.

Main Responsibilities

Commercial Reporting & Stakeholder Support

• Own recurring weekly and monthly Modern Trade commercial reports
• Partner with KAM and commercial stakeholders: write and speak clearly; push back politely when a requested number is wrong
• Spot breaks in reports or logic, flag them, and propose a fix without waiting to be ticketed
• Break messy sales questions into steps and show the work before sending an answer

Deep Analysis & Modelling

• Run deep-dive analysis on sales and commercial questions, not only the recurring pack
• Build analytical models the business can reuse (Excel, BI, or similar) - drivers, scenarios, and "what happens if"
• Find opportunities in the numbers and turn them into a clear recommendation

BI Development & Data Quality

• Develop reports or models in Power BI, Looker, Tableau, or equivalent (semantic model and/or DAX-or-equivalent and/or publish)
• Write strong SQL (joins, grain, dedup, business-rule filters - not only SELECT *)
• Reconcile figures before sending so trusted numbers reach the business
• Use AI to move faster on reporting and analysis, while staying accountable for the number that goes out

Requirements

General

• Minimum 2 years of relevant experience in analytics, commercial reporting, or similar roles
• Strong analytical thinking, structured problem-solving, and communication skills
• Proactive ownership mindset: spots issues and proposes fixes; does not wait to be ticketed
• Able to work with KAM / commercial stakeholders in a dynamic, fast-paced environment
• Recurring reporting ownership (weekly/monthly)
• Uses AI as a working tool, not a shortcut: writes a clear brief, gives enough background, and checks the result - especially numbers - before it goes to the business

Technical Skills

• Practical AI skills: prompt engineering and context engineering (clear brief, right files/background, check before send). Saved workflows or light tool use is a plus
• Strong SQL (joins, grain, dedup, business-rule filters - not only SELECT *)
• Evidence of having developed BI reports or models in Power BI, Looker, Tableau, or equivalent - not dashboard viewing only
• Statistic-based modelling (forecasting, regression, tests, or similar) is preferred
• Putting model output into an app or interactive dashboard is a plus
• Familiarity with warehouse SQL (BigQuery or similar) is a plus
• Basic Python (pandas, cleaning, a small script) is preferred

Business & Commercial Understanding

• Experience working with sales, operational, or commercial datasets
• Ability to translate business questions into clear reporting logic
• Familiarity with FMCG sales and related commercial data (sell-in/sell-out, market share, distribution, promo/price) is a strong advantage
• Named retailers are not required
• Comfortable working with cross-functional commercial stakeholders

Why Join Us?

• Be part of a high-growth company expanding across nationwide commercial channels
• Own reporting the business actually uses, with real impact on Modern Trade decisions
• High exposure to commercial strategy, sales operations, and business decision-making
• Work closely with business leaders, KAMs, and cross-functional teams
• Opportunity to build and improve BI and reporting that the team relies on every week