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