Customer Intelligence Senior Analyst

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) is a plus Advanced knowledge of Excel and its main features (e.g., pivot tables, macros, etc.) andpresentation (Powerpoint) 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 What’s in it for you In EssilorLuxottica, you are not defined just by your job title. Each career adventure is unique; have a glimpse of some of the benefits you will enjoy as a successful candidate: Access to our cutting-edge learning platform, Leonardo, and personalized development programs to help you grow professionally and personally. Enjoy flexible work conditions, health insurance coverage, ticket restaurants, internal rooftop canteen Join the Corporate Shareholding Program “BOOST” an opportunity to share in the company’s success and directly benefit from EssilorLuxottica’s growth. Access special offers for employees on a vast range of eyewear, eye care products, and fashion apparel, so you can enjoy our world-class brands firsthand. Enjoy our “Disconnect Program” a holistic approach to work-life balance, including initiatives for mental health, yoga, jogging sessions, and more, designed to help you recharge and stay healthy 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. #J-18808-Ljbffr