Open Jobs Lead Data Engineer Enterprise Reporting & Analytics

Job ID:288055
Location Name: CA-FSC SF Off (0174)
Address: 350 Mission St 20th Floor San Francisco CA 94105 United States (US)
Job Type: Full Time
Position Type: Regular
Job Function: Information Technology
Work Location: Hybrid - San Francisco CA

Ready for a career glow up As a Lead Engineer you will design and implement innovative analytical solutions and work alongside the product engineering team evaluating new features and architecture. Reporting to the Director Engineering Data & AI you will work closely with other team members like data architects data engineers report developers product and business analysts to understand what the business is trying to achieve move data from source to target and design optimal data models. You will be also responsible for building and maintaining reporting capabilities in the data platform that will feed data from the data models. This hands-on technical role demands excellency with AI/ML concepts and their integration into data engineering pipelines. Come be a part of a team that is starting this new journey.

What Youll Do:

• Lead design and implement innovative analytical solutionsusing 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 efficiencyby 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 analysisof 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 teamsto provide data required for developing operationalizing and evaluating predictive models dashboards and reports.
• Manage vendorsto 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 Youll 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.
• Bachelors degree in Computer Science Engineering Mathematics Statistics Economics Finance or another quantitative field. #LI-SR1

What Youll Get:

The annual base salary range for this position is $191520.00- $212800.00 The actual base salary offered depends on a variety of factors which may include as applicable the applicants 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 willperform the employed in this position may also be eligible to earn job will be posted for a minimum offivedays.

• CaringCommunity.Youllcollaborate with teammates who are equally passionateabout innovatinganddrivingthe industry forward together united in beauty.

• Fulfilling Path.Your career transformation starts here with opportunities that will challengestretchand develop your skills.

• Meaningful Work.As you make an impact onbeautyyoullfeel and see the positive change (consumer industryandsocial)thatyourindividual voice is a part of.

Rewardsas Uniqueas You:

Some benefits have eligibility requirements and may depend on job classification and length of employment.

• Health.Choose a healthcare plan to fit you and your familys needs withmedicaldental and vision also fully covers our employees disability and life insurance.

• Wealth.We offer a competitive 401k with4%match as well as FSA and HSA programs. We also offer a Student Debt Retirement plan where your student loan paymentsqualifyto earn the 401k match from Sephora.

• Balance.Youll beempoweredto find the perfect blend of work/life balance thatactuallyworks for youwithPTO flexibilityprotectedleave and more.

• Growth.Career growthis built into every role with access to trainingdevelopmentand tuition reimbursement.

• Perks.Thinkyouvetried it all Enjoya30%discount on all merchandise/services opportunities forfreeproductor gratisand flash sale discountsonLVMHbrandproducts.

• Support.Join a team thattruly 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 andinclusiveworkplaceand considers allapplicants withoutregard 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 is committed to providing reasonable accommodationtaapplicantswith disabilities or other medical conditions.

Sephora will consider all qualified applicants including those witharrest and conviction recordsin a manner consistent with the requirements of allapplicable 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.

JoinUs and Belong to Something Beautiful