Sephora Data Engineer

San Francisco • USA

Wednesday, January 22, 2025

Sephora, a leader in the beauty retail industry, operates under the umbrella of the LVMH Moët Hennessy Louis Vuitton conglomerate, renowned for its luxury goods. As an employer, Sephora offers a dynamic and innovative work environment, fostering creativity and excellence. The company's North American operations are headquartered in San Francisco's vibrant Financial District, where the Field Support Center (FSC) is dedicated to supporting stores in delivering exceptional client experiences.

1. Develop and design solutions to assess data from multiple sources.
2. Create and maintain Azure Data Factory (ADF) pipelines to extract data from SFTP servers.
3. Transform data according to business requirements and ingest into Databricks.
4. Develop dynamic SQL Views on top of base delta tables and build reporting dashboards.
5. Design and implement robust data pipelines using ADF and Databricks, ensuring seamless data flow into MySQL databases.
6. Develop applications leveraging Kafka streams and Spark structured streaming for real-time data processing.
7. Design and implement MySQL data models for personalization.
8. Document comprehensive data processes and pipeline configurations.

1. Master’s degree or foreign equivalent in Analytics, Applied Mathematics, or a related field.
2. One year of experience as a Data Engineer or in a related occupation.

1. Proficiency in Scala and Spark.
2. Experience with cloud technologies, particularly Azure.
3. Strong SQL skills.
4. Familiarity with ETL tools and processes.
5. Experience with retail and CRM datasets.
6. UNIX/Linux experience and scripting skills such as Shell, Perl, and Python.
7. Knowledge of APIs for data collection and ingestion.
8. Experience with data integration tools.

A minimum of one year of experience in data engineering or a related field is required.

Master’s degree or foreign equivalent in Analytics, Applied Mathematics, or a related field.

The salary range for this position is $128,400 to $153,250.

Sephora offers a comprehensive benefits package, including health insurance, retirement plans, and employee discounts. The company also provides opportunities for professional development and career advancement.

Sephora's culture is characterized by a fast-paced, innovative, and inclusive environment. The company values diversity and is committed to providing equal opportunities for all employees. At Sephora, creativity and passion are encouraged, and employees are empowered to challenge the status quo and drive change.