Customer Intelligence Senior Analyst

Luxottica; Milano; In loco; EUR 50.000 - 70.000; Tempo pieno

Descrizione del lavoro

A global leader in eyewear is seeking a Customer Intelligence Senior Analyst in Milan. This role involves extracting insights from customer data and developing reports through SQL and data visualization tools like Power BI and Tableau. The ideal candidate has at least 4 years of experience in data analytics, strong communication skills, and a Bachelor’s degree in a quantitative field. Join a team dedicated to fostering inclusivity and collaboration.

Servizi

Inclusive work environment

Opportunities for professional growth

Competenze

• Strong knowledge of SQL is mandatory.
• Proficiency in data visualization tools like Power BI and Tableau.
• Advanced Excel including pivot tables and macros required.
• Bachelor's degree in a quantitative field such as Math or Statistics.

Mansioni

• Query customer database for reporting and analysis.
• Develop dashboards to monitor customer base health.
• Prepare actionable reports and presentations.
• Research customer types and behavioral segments.

Conoscenze

Strong knowledge of SQL

Data visualization tools (Power BI, Tableau, Looker)

Advanced knowledge of Excel

Strong analytical and mathematical skills

Communication writing and verbal skills

Ability to work under pressure

Curiosity and lifelong learning

Formazione

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

Strumenti

Airflow

GitLab

Google BigQuery

Statistical packages (R, Python, SAS)

Descrizione del lavoro

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 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 to 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
• GoogleBigQuery
• 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.