Commercial Data & BI Analyst 1

EssilorLuxottica; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

EssilorLuxottica in Singapore seeks a Data & BI Analyst to enable data-driven decisions by building dashboards and ensuring data quality across commercial functions.

You will extract data from SAP, consolidate sources, and collaborate with senior analysts to deliver timely insights using Power BI and Excel in a fast-paced global organization.

Qualifications

• Strong proficiency in Excel with advanced formulas and data manipulation.
• Hands-on experience building dashboards in Power BI.
• Experience extracting data from SAP BI or similar systems.
• Knowledge of data cleaning and data transformation techniques.

Responsibilities

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

Skills

Excel

Power BI

SAP BI

Data cleaning

Education

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

Tools

SAP Business Intelligence

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

• 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)

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.