Lead Data Engineer Enterprise Reporting & Analytics

Lead Data Engineer accountable for designing analytics solutions and building reporting capabilities within Sephora's data platform, collaborating with data science, analytics, product engineering, and business stakeholders, with emphasis on AI/ML integration and data quality.

Responsibilities

• Architect and implement innovative analytical solutions leveraging SQL, Databricks, Tableau, Cognos, SSAS Cubes, ETL tools, and other Big Data technologies, while monitoring BI performance to ensure efficient data retrieval, processing, and reporting.
• Enhance data quality and cost efficiency by deploying quality control processes to verify data, dashboards, and reports, and applying cost-optimization strategies across the data platform to minimize compute and storage spend.
• Analyze business problems and technical environments to design robust technical solutions, translating business functionalities into actionable technical strategy.
• Promote AI assisted development tools (Claude Code, GitHub Copilot, Cursor) and automation platforms to boost engineering productivity, solution quality, and workflow autonomy.
• Collaborate with business stakeholders, data analysts, developers, and IT teams to gather requirements and deliver solutions that meet needs, translating complex technical concepts for non-technical audiences.
• Partner with Data Science, Machine Learning, and Analytics teams to provide data for developing, operationalizing, and evaluating predictive models, dashboards, and reports.
• Manage vendor relationships to evaluate architectural impact of different strategies and ensure alignment with the data platform architecture.
• Foster a high-performance engineering culture by mentoring and upskilling team members and providing tools and motivation to deliver results.

Requirements

• 8+ years of experience in software development and deployment with business intelligence tools.
• 8+ years in business intelligence and data warehousing, with strong command of SQL, data warehousing concepts, and Big Data and streaming processing.
• 2+ years 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 actionable 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 agentic workflows using orchestration frameworks such as LangGraph, LangChain, CrewAI, AutoGen, or Amazon Bedrock Agents.
• Experience implementing Retrieval-Augmented Generation pipelines using vector databases (Pinecone, Weaviate, pgvector, Chroma) and frameworks (LlamaIndex, LangChain Retrieval).
• Working knowledge of the Model Context Protocol for connecting AI models to enterprise data sources, tools, and APIs.
• Strong experience with data modeling, design patterns, and building scalable BI solutions.
• Proven ability to mentor and coach engineering talent, including upskilling teams on AI augmented development practices.
• Excellent communication and storytelling skills to clearly convey complex analytical results to business partners.
• Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, Economics, Finance, or another quantitative field.

Technologies

• SQL
• Databricks
• Tableau
• Cognos
• SSAS Cubes
• ETL tools
• Claude Code
• GitHub Copilot
• Cursor
• Cline
• Aider
• LangGraph
• LangChain
• CrewAI
• AutoGen
• Amazon Bedrock Agents
• Pinecone
• Weaviate
• pgvector
• Chroma
• LlamaIndex
• LangChain Retrieval
• MCP (Model Context Protocol)
• ThoughtSpot
• ADF
• Datastage
• Jira
• Confluence

Benefits

• Health
• Wealth
• Balance
• Growth
• Perks
• Support

What you’ll get

• Caring Community
• Fulfilling Path
• Meaningful Work

Rewards as unique as you

• Health
• Wealth
• Balance
• Growth
• Perks
• Support