Strategic Commercial Planner & Analyst

EssilorLuxottica; Jakarta Pusat; On-site; IDR 240,000,000 - 360,000,000; Full time

Benefits offered by this job

Employee Shareholding

OneSight Foundation volunteer

Medical benefits including health/life

Job summary

EssilorLuxottica in Jakarta seeks a data-driven analytics professional to own sales planning, forecasting, and performance analysis for domestic channels. You will turn complex data into clear leadership-ready insights and support adoption of our products through cross-functional collaboration.

Ideal candidates have 3–5 years in analytical/commercial roles, strong Excel and PowerPoint skills, and fluency in Bahasa Indonesia and English. The role is based on-site in Jakarta.

Qualifications

• Bachelor's degree in Business, Economics, Finance, Statistics, Industrial Engineering, or related field.
• 3–5 years of experience in an analytical or commercial role.
• Background as Product Manager, Sales Planner, or Business Analyst is a strong advantage.
• Strong Microsoft Excel skills (must-have): advanced formulas (XLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, nested IF, dynamic arrays), PivotTables, Power Query, data validation, and building structured, error-free models from raw data
• Excellent presentation skills (must-have): able to build clean, executive-level PowerPoint decks and present findings confidently to senior management
• Fluent in Bahasa Indonesia and English (written and spoken)

Responsibilities

• Lead budget and forecast cycles, including periodic reforecasts, monthly phasing, and year-end estimates.
• Monitor stock health and sell-in vs. sell-out gaps with distributors and key accounts.
• Produce monthly MTD/YTD performance reviews by brand, channel, and account, with clear commentary on drivers and risks.
• Track core commercial metrics (net sales, margin, pricing compliance) and flag deviations early.
• Build financial simulations and ROI analyses for trade programs, incentives, campaigns, and bundle offers.
• Support key account business plans with volume, value, and profitability projections.
• Evaluate new door openings and channel expansion opportunities.
• Maintain clean, reliable sales and master data across platform and internal reporting tools.
• Partner with Finance, Supply Chain, Marketing, and Regional teams to align numbers and assumptions.

Job description

EssilorLuxottica in Jakarta seeks a data-driven analytics professional to own sales planning, forecasting, and performance analysis for domestic channels. You will turn complex data into clear leadership-ready insights and support adoption of our products through cross-functional collaboration.

Ideal candidates have 3–5 years in analytical/commercial roles, strong Excel and PowerPoint skills, and fluency in Bahasa Indonesia and English. The role is based on-site in Jakarta.