Commercial Planning & Business 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

Select how often (in days) to receive an alert: Create Alert

If you’ve worn a pair of glasses, we’ve already met.

We are a global leader in the design, manufacture, and distribution of advanced vision care products, eyewear, and med-tech solutions. We are home to the most innovative lens technologies, including Varilux, Stellest and Transitions, iconic brands such as Ray-Ban, Oakley, and Supreme, top-selling smart eyewear products Ray-Ban Meta, Oakley Meta and Nuance Audio, the most desired luxury licensed brands and world-class retailers including Sunglass Hut, LensCrafters, Vision Express and Apollo. Join our global community of over 200,000 employees across 150 countries and 600 operations facilities, serving 300,000 eye care professionals and operating 18,000 stores in driving the transformation of the eyewear and eyecare industry.

Discover more by following us on LinkedIn!

Your #FutureInSight with EssilorLuxottica

Are you willing to pioneer new frontiers, foster inclusivity and collaboration, embrace agility, ignite passion, and make a positive impact on the world? Join us in redefining the boundaries of what’s possible!

Your Role

We are seeking a highly skilled and motivated person to join our dynamic team at EssilorLuxottica. As a key member of our organization, you will play a crucial role in d rive data-backed commercial decisions across the Frames and Wearables business by owning sales planning, forecasting, and performance analysis for the domestic channels. This role turns complex data into clear, compelling stories for leadership and partners. Your expertise will help drive the adoption and optimal use of our products, ensuring improved outcomes and satisfaction collaboration with various stakeholders.

Main Responsibilities:

Planning & Forecasting

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.

Performance Analysis & Reporting

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.

Commercial Support

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.

Data & Systems

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.

Main Requirements:

Bachelor's degree in Business, Economics, Finance, Statistics, Industrial Engineering, or related field.

3–5 years of experience in an analytical or commercial role. Candidates from any industry are welcome.

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)

What’s in it for you

In EssilorLuxottica, you are not defined just by your job title. Each career adventure is unique, but have a glimpse of the benefits and perks you can have by choosing us.

• Join theEmployee Shareholding Program to share in the Company’s success and directly benefit from EssilorLuxottica’s growth.
• Opportunity to volunteer with the OneSight EssilorLuxottica Foundation and be an active part of our mission to improve lives by improving sight.
• Medical benefits including health insurance coverage for hospital & surgical, outpatient - general practitioner and specialist, Life insurance.

Our recruitment process may vary; If you are selected, you will be contacted by our recruiters to guide you through the specific steps for your application.

Our Diversity, Equity and Inclusion commitment

We are committed to creating an inclusive environment for all employees. We celebrate diversity and provide equal opportunities to all, regardless of race, gender, ethnicity, religion, disability, sexual orientation, or any other characteristic that makes us unique.