Sales Analyst (Modern Trade)

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) so report numbers are explainable

● 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