Customer Intelligence Senior Analyst

Luxottica; Milano; In loco; EUR 45.000 - 60.000; Tempo pieno

Descrizione del lavoro

A leading global eyewear company in Milan seeks a Customer Intelligence Senior Analyst. The role involves querying databases, developing dashboards, and providing insights. Ideal candidates should have over 4 years of relevant experience, strong SQL knowledge, and proficiency in data visualization tools like Power BI. This position offers opportunities in a dynamic, inclusive environment, emphasizing data-driven decision-making and effective communication.

Competenze

• At least 4 years of relevant experience in Data company and/or analytics.
• Strong analytical and critical thinking skills.
• Ability to convey complex ideas in simple terms.

Mansioni

• Query customer database for data for reporting and analysis.
• Develop and maintain dashboards to monitor customer health.
• Prepare reports and business recommendations.

Conoscenze

SQL

Data visualization tools (Power BI, Tableau, Looker)

Google BigQuery

Airflow

GitLab

Statistical packages and data analysis tools (R, Python, SAS)

Excel (pivot tables, macros)

Communication skills

Analytical and mathematical skills

Formazione

Bachelor's degree in Math, Economics, Statistics or related field

Descrizione del lavoro

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!

Your role

The Customer Intelligence Senior Analyst is responsible for supporting analytics at the customer level and extracting insights from customers for all company audience, locally or globally. The Customers Intelligence Senior Analyst leverages SQL (Hive/MySQL) to run existing database queries and build new queries for the customers analytics team, conducts advanced analysis by collecting and using a comprehensive set of data that explains all potential business drivers. The output of the Analyst will support a mix of ad-hoc analyses, customer analytics, and reporting.

• Delivers standard reports through SQL code on a weekly and monthly basis, able to update existing code as business requirements change. Develops and maintains knowledge base on the consumer, recommending and producing dashboards to allow the business to monitor customer base health as well as keep under control key trends.
• Employs data and research insights/analysis on the customer database to understand customer types, behavioral segments and inter purchase intervals.
• Develop effective presentations on complex ideas that can be communicated in a simple and straight forward manner.
• A curious, lifelong learner able to work in an international environment with entrepreneurial spirit.
• Flexibility to handle multiple tasks and meet project deadlines.

Main responsibilities

• Query customer database for data for reporting and analysis.
• Develop and maintain knowledge base on the consumer, recommending and producing dashboards to allow the business to monitor customer base health as well as keep under control key trends.
• Research insights on the customer database to understand customer types, behavioral segments and inter purchase intervals.
• Prepare reports/presentations, with his/her actionable insight and business recommendations.

Main requirements

• Strong knowledge of SQL — mandatory.
• Airflow & GitLab.
• Google BigQuery.
• Strong knowledge of Data visualization tools (Power BI, Tableau, Looker) — mandatory.
• Statistical packages and data analysis tools (R, Python, SAS) — not mandatory, but is a plus.
• Advanced knowledge of Excel and its main features (e.g., pivot tables, macros, etc.) and presentation (Powerpoint) — mandatory.

• At least 4 years of relevant experience in Data company and/or analytics Best in Class analytical and critical thinking skills.
• Strong both in Communication writing and verbally.
• Strong analytical and mathematical skills.
• Ability to clearly convey very complex ideas in simple easy to understand ways.
• Ability to work in a dynamic environment, under stress and with tight deadlines.

• Bachelor's degree in highly analytical and quantitative areas such as: Math, Economics, Statistics, or related field.

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.