Data Analyst

at  Sephora

THE OPPORTUNITY

Analytics is the compass that guides Sephora on its strategic journey, and we are on the lookout for a Data Analyst who can harness the power of data to propel our business forward. As a Data Analyst, you’ll play a critical role in analyzing and interpreting customer data to drive business decisions across our digital platforms. Leveraging your strong experience in BigQuery SQL, you’ll craft scripts that seamlessly integrate back-end data with Google Analytics 4 for in-depth customer analysis and segmentation.
Your expertise in data modeling will enable you to map out data structures that support the creation and maintenance of dashboards and reports, tracking key performance indicators (KPIs) related to online engagement, traffic, conversion rates, and marketing effectiveness. In this role, you’ll work with data visualization tools like Power BI and Google Data Studio to develop compelling visual reports that convey complex insights in a clear and actionable manner. Additionally, you’ll ensure the accuracy and quality of data, while effectively communicating your insights to non-technical stakeholders.

You will also be responsible for:

• Writing and optimizing BigQuery SQL scripts for GA4 analysis, integrating back-end data to segment and analyze customer data.
• Developing and maintaining dashboards and regular weekly/monthly reports to track KPIs related to performance, online engagement, A/B testing, traffic, conversion rates, marketing attribution, and campaign effectiveness.
• Using data visualization tools such as Power BI and Google Data Studio to create clear, actionable insights for stakeholders.
• Engaging in data modeling to effectively map out data structures that support business goals.
• Utilizing digital analytics tools like Google Analytics and Quantum Metric to deliver data-driven recommendations.
• Ensuring the accuracy and quality of data while drawing insightful conclusions and making strategic recommendations.

WHAT YOU’LL BRING

Your passion for detail is matched by your logical thinking and curiosity. You not only obsess over details but also possess the agility to communicate improvements rapidly and clearly. You thrive in an ever-evolving landscape, where driving innovation and continuous improvement is paramount. We are looking for a detail-oriented Data Analyst with strong analytical skills, capable of working both independently and collaboratively within a dynamic team environment.
We value ambition paired with a logical mindset—individuals who are curious, inquisitive, and able to articulate suggestions with precision. You will utilize your strong foundation in BigQuery SQL, particularly in GA4 analysis, coupled with hands-on experience in data visualization using tools like Power BI. Your deep understanding of digital analytics, especially within Ecommerce and Retail, will enable you to provide actionable insights that drive business success. Your proficiency in digital analytics tools such as Google Analytics and Quantum Metric will be essential in providing recommendations that optimize performance.

Our ideal candidate will also possess:

• Proficiency in Google Analytics, Quantum Metric, or similar digital analytics platforms.
• Experience with Google Marketing Platform.
• Strong communication skills, both written and verbal, for conveying complex data insights to non-technical stakeholders.
• An eye for detail and a commitment to data accuracy and quality.
• Familiarity with Google Tag Manager, A/B testing tools, competitor research using market share tools, setting up data feed APIs, and UX platforms would be advantageous.

• Writing and optimizing BigQuery SQL scripts for GA4 analysis, integrating back-end data to segment and analyze customer data.
• Developing and maintaining dashboards and regular weekly/monthly reports to track KPIs related to performance, online engagement, A/B testing, traffic, conversion rates, marketing attribution, and campaign effectiveness.
• Using data visualization tools such as Power BI and Google Data Studio to create clear, actionable insights for stakeholders.
• Engaging in data modeling to effectively map out data structures that support business goals.
• Utilizing digital analytics tools like Google Analytics and Quantum Metric to deliver data-driven recommendations.
• Ensuring the accuracy and quality of data while drawing insightful conclusions and making strategic recommendations