Lead Data Engineer Enterprise Reporting & Analytics

sephora.com; San Francisco (CA); On-site; USD 191,520 - 212,800; Full time

Benefits offered by this job

Healthcare coverage (medical, dental, vision)

401k with 4% match

Career growth opportunities

30% discount on all merchandise/services

Job summary

Sephora is seeking an experienced analytics leader in San Francisco to lead innovative analytical solutions that drive data quality and business intelligence efficiency. The role requires extensive experience in BI tools and AI integration, ensuring the optimal performance of data systems.

A successful candidate will mentor team members and collaborate with cross-functional teams to translate complex needs into actionable technical strategies, driving impactful outcomes in a competitive beauty retail environment.

Sephora offers a comprehensive benefits package, including health coverage, 401k matching, and unique perks for employees.

Qualifications

• 8+ years of experience in software development and deployment with business intelligence tools.
• 2+ years of integrating AI/ML-powered features into production applications.
• 5+ years of experience analyzing large datasets.

Responsibilities

• Lead, design, and implement innovative analytical solutions using Big Data technologies.
• Drive data quality and cost efficiency.
• Collaborate with business stakeholders to understand requirements.

Skills

Leadership in analytical solutions

SQL expertise

Experience with AI/ML features

Strong communication skills

Data modeling

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or related field

Tools

Tableau

Databricks

Cognos

SSAS Cubes

ETL tools

Job description

What you’ll do:

• Lead, design, and implement innovative analytical solutions using advanced SQL, Databricks, Tableau, Cognos, SSAS Cubes, ETL tools, and other Big Data technologies, while monitoring and optimizing BI system performance to ensure efficient data retrieval, processing, and reporting.
• Drive data quality and cost efficiency by implementing quality control processes to ensure the accuracy of data, dashboards, and reports, while enforcing cost optimization strategies across the data platform to minimize compute and storage costs.
• Perform detailed analysis of business problems and technical environments to design high‑quality technical solutions, converting business functionalities into actionable technical strategy.
• Drive the adoption of AI‑assisted development tools (e.g., Claude Code, GitHub Copilot, Cursor) and automation platforms to enhance engineering productivity, solution quality, and agentic workflow initiatives.
• Collaborate with business stakeholders, data analysts, developers, and IT teams to understand requirements and deliver solutions that meet their needs—translating complex technical concepts for non‑technical audiences through effective communication.
• Partner closely with Data Science, Machine Learning, and Analytics teams to provide data required for developing, operationalizing, and evaluating predictive models, dashboards, and reports.
• Manage vendors to understand the potential architectural impact of different vendor strategies and ensure alignment with the overall data platform architecture.
• Build and foster a high‑performance engineering culture—mentoring and upskilling team members and providing the tools and motivation to make things happen.

What you’ll bring:

• 8+ years of experience in software development and deployment with business intelligence tools.
• 8+ years of experience in business intelligence and data warehousing, including mastery of SQL, Data Warehousing, and Big Data and stream processing.
• 2+ years of hands‑on experience building or integrating AI/ML‑powered features and agentic workflows into production applications.
• 1+ year of experience using AI‑assisted development tools (e.g., Claude Code, Cursor, GitHub Copilot, Cline, Aider) to accelerate software delivery.
• 5+ years of experience analyzing large datasets to identify trends, patterns, and outliers to extract meaningful insights.
• 5+ years of experience writing design documentation, Source‑to‑Target mapping documentation, and managing Confluence pages.
• 5+ years of experience converting business functionalities into technical Jira stories.
• 3+ years of hands‑on experience with SQL, Databricks, ADF, Datastage (or other ETL tools), SSAS Cubes, Cognos, Tableau, ThoughtSpot, and other BI tools.
• Hands‑on experience designing and building agentic workflows using orchestration frameworks such as LangGraph, LangChain, CrewAI, AutoGen, or Amazon Bedrock Agents.
• Experience implementing RAG (Retrieval‑Augmented Generation) pipelines using vector databases (Pinecone, Weaviate, pgvector, Chroma) and frameworks (LlamaIndex, LangChain Retrieval).
• Working knowledge of the Model Context Protocol (MCP) for connecting AI models to enterprise data sources, tools, and APIs.
• Strong experience with data modeling, design patterns, and building highly scalable Business Intelligence solutions.
• Demonstrated ability to mentor and coach engineering talent, including upskilling teams on AI‑augmented development practices.
• Excellent communication and storytelling skills, with the ability to clearly convey complex analytical results to business partners.
• Bachelor’s degree in Computer Science, Engineering, Mathematics, Statistics, Economics, Finance, or another quantitative field.

What you’ll get:

The annual base salary range for this position is $191,520.00 - $212,800.00. The actual base salary offered depends on a variety of factors, which may include, as applicable, the applicant’s qualifications for the position; years of relevant experience; specific and unique skills; level of education attained; certifications or other professional licenses held; other legitimate, non‑discriminatory business factors specific to the position; and the geographic location in which the applicant lives and/or from which they will perform the job. Individuals employed in this position may also be eligible to earn bonuses.

• Careful Community. You’ll collaborate with teammates who are equally passionate about innovating and driving the industry forward – together, united in beauty.
• Fulfilling Path. Your career transformation starts here, with opportunities that will challenge, stretch and develop your skills.
• Meaningful Work. As you make an impact on beauty, you’ll feel and see the positive change (consumer, industry, and social) that your individual voice is a part of.

Rewards as unique as you:

• Health. Choose a healthcare plan to fit you and your family’s needs with medical, dental, and vision coverage. Sephora also fully covers our employees’ disability and life insurance.
• Wealth. We offer a competitive 401k with 4% match as well as FSA and HSA programs. We also offer a Student Debt Retirement plan, where your student loan payments qualify to earn the 401k match from Sephora.
• Balance. You’ll be empowered to find the perfect blend of work/life balance that actually works for you with PTO, flexibility, protected leave, and more.
• Growth. Career growth is built into every role, with access to training, development, and tuition reimbursement.
• Perks. Think you’ve tried it all? Enjoy a 30% discount on all merchandise/services, opportunities for free product or "gratis," and flash sale discounts on LVMH brand products.
• Support. Join a team that truly cares – with free mental health and financial coaching resources with 24/7 access to Modern Health and Financial Finesse. Plus, volunteer and donation matching.

Sephora values a diverse and inclusive workplace and considers all applicants without regard to sex, pregnancy, race, color, national origin, gender (including gender identity and gender expression), age, religion, sexual orientation, military/veteran status, disability, or any other protected category. Sephora is committed to providing reasonable accommodation ta applicants with disabilities or other medical conditions.

Sephora will consider all qualified applicants, including those with arrest and conviction records in a manner consistent with the requirements of all applicable laws, including the Los Angeles Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York City Fair Chance Act.