Commercial Data & BI Analyst 1

EssilorLuxottica Asia Pacific Pte Ltd; Singapore; On-site; SGD 55,000 - 90,000; Full time

Job summary

EssilorLuxottica Asia Pacific Pte Ltd in Singapore seeks a Data & BI Analyst to ensure accurate, timely data and actionable dashboards for commercial insight. You will extract data from SAP and other trackers, validate it, and support stakeholders with data-driven decisions.

Build and maintain Power BI and Excel dashboards, produce regular reports, and help automate workflows. A Bachelor’s degree in a related field and 3–5 years of analytics or BI experience are preferred.

Qualifications

• Bachelor’s degree in Business Analytics, Data Analytics, Information Systems, or a related field.
• 3-5 years of experience in data analysis, reporting, or business intelligence roles.

Responsibilities

• Extract, consolidate, and manage data from multiple sources including SAP and manual trackers
• Clean, validate, and transform data to ensure consistency, accuracy, and reliability
• Develop, maintain, and optimize dashboards and reports using Power BI and Excel
• Produce regular (weekly/monthly) reports to support commercial performance tracking
• Prepare structured datasets for analysis by senior analysts and business stakeholders
• Monitor data quality and proactively identify, troubleshoot, and resolve inconsistencies
• Maintain documentation for data sources, definitions, and reporting processes
• Support automation and continuous improvement of reporting workflows

Skills

Excel advanced

Power BI

SAP data extraction

Data cleaning

Data modeling

Education

Bachelor’s degree in Business Analytics, Data Analytics, Information Systems, or related

Tools

Power Query

VBA

Job description

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

We are a global leader in the design, manufacture, and distribution of ophthalmic lenses, frames, and sunglasses. We offer our industry stakeholders in over 150 countries access to a global platform of high-quality vision care products (such as the Essilor brand, with Varilux, Crizal, Eyezen, Stellest and Transitions), iconic brands that consumers love (such as Ray-Ban, Oakley, Persol, Oliver Peoples, Vogue Eyewear and Costa), as well as a network that offers consumers high-quality vision care and best-in-class shopping experiences (such as Sunglass Hut, LensCrafters, Salmoiraghi & Viganò and the GrandVision network), and leading e-commerce platforms.

Join our global community of over 190,000 dedicated employees around the world 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!

Role Description:

The Data & BI Analyst supports the Commercial Strategy & Analytics function by ensuring accurate, timely, and structured data is available for business analysis. This role focuses on data extraction, validation, reporting, and dashboard development to enable informed decision-making across the organization.

Key Responsibilities

• Extract, consolidate, and manage data from multiple sources including SAP and manual trackers
• Clean, validate, and transform data to ensure consistency, accuracy, and reliability
• Develop, maintain, and optimize dashboards and reports using Power BI and Excel
• Produce regular (weekly/monthly) reports to support commercial performance tracking
• Prepare structured datasets for analysis by senior analysts and business stakeholders
• Monitor data quality and proactively identify, troubleshoot, and resolve inconsistencies
• Maintain documentation for data sources, definitions, and reporting processes
• Support automation and continuous improvement of reporting workflows

Scope of Role

• Responsible for end-to-end execution of data extraction, validation, reporting, and dashboard development
• Works closely with senior analysts and business stakeholders to support data-driven initiatives
• Focuses on delivering accurate, timely, and structured data to enable business insights
• Contributes to continuous improvement of data processes and reporting efficiency

Skills & Qualifications

Technical Skills:

• Strong proficiency in Microsoft Excel (advanced formulas, pivot tables, data manipulation)
• Hands-on experience with Power BI (dashboard creation, data modeling preferred)
• Familiarity with data extraction from systems such as SAP Business Intelligence or similar platforms
• Basic understanding of data structures, data cleaning, and transformation techniques

Professional Skills:

• High attention to detail and accuracy
• Strong organizational and time management skills
• Ability to handle and reconcile data from multiple sources
• Problem-solving mindset with a focus on data quality
• Good communication skills to support internal stakeholders

Experience & Education

• Bachelor’s degree in Business Analytics, Data Analytics, Information Systems, or a related field
• 3-5years of experience in data analysis, reporting, or business intelligence roles

Preferred (Nice to Have)

• Experience with basic querying skills
• Exposure to data warehousing concepts
• Experience in commercial, sales, or FMCG environments
• Familiarity with automation tools (e.g., Power Query, VBA)

Recruiting process

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.