Data Engineer - 12 FTC

Sephora; London; On-site; GBP 45,000 - 75,000; Full time

Job summary

Sephora seeks a Data Engineer on a 12-month fixed-term contract. You will build and maintain data infrastructure, leading to data-driven business insights. Responsibilities include designing data pipelines and optimizing cloud performance. Candidates should excel in SQL and Python, with experience in ETL and cloud systems being beneficial.

Benefits

Community-oriented culture

Learning and growth opportunities

Empowering work environment

Qualifications

• Strong foundation in SQL and Python.
• Experience in data warehousing and ETL.
• Comfortable with cloud-based data architecture.

Responsibilities

• Designing and maintaining scalable data pipelines.
• Collaborating with BI and Analytics teams.
• Ensuring data security and optimising cloud costs.

Skills

SQL

Python

Data Warehousing

ETL

Cloud Technologies

Problem-Solving

Tools

BigQuery

Power BI

Job description

At Sephora, beauty is about feeling seen, valued, and empowered, individually and collectively. It is connecting deeply with others, celebrating diversity and inclusivity, unlocking your potential and making a difference every day. Together, we belong to something beautiful.

The Opportunity

At Sephora, data is more than just numbers, it’s the foundation of every strategic decision we make. We’re looking for a Data Engineer to join us on a 12-month fixed-term contract (maternity cover) and play a pivotal role in building and maintaining the data infrastructure that powers our insights. You’ll be instrumental in developing our data warehouse and enabling seamless data flow across the business, empowering teams with the tools they need to make data-driven decisions.

You’ll collaborate closely with our Business Intelligence and Analytics teams to design and implement robust data pipelines, optimise cloud performance, and ensure the integrity and security of our data. Your work will directly support the delivery of key business metrics and help shape the future of data at Sephora.

We’re open to candidates based in either London or St Helier, Jersey, and are happy to explore a flexible working arrangement.

You Will Also Be Responsible For

• Designing, building, and maintaining scalable data pipelines and architecture
• Assembling large, complex datasets that meet functional and non-functional business requirements
• Collaborating with BI and Analytics developers to deliver actionable insights
• Automating manual processes and optimising data delivery for performance and scalability
• Supporting the extraction, transformation, and loading (ETL) of data from diverse sources using SQL and GCP technologies
• Ensuring data security and separation across systems and teams
• Monitoring and optimising cloud query and storage costs

What You’ll Bring

You’re a problem-solver with a passion for clean, efficient data systems. You bring a strong foundation in SQL, Python, and cloud-based data architecture, and you’re comfortable navigating both structured and unstructured data environments. You’re proactive, detail-oriented, and thrive in a collaborative setting where your work has a direct impact on business outcomes.

Your experience in data warehousing, ETL development, and cloud technologies enables you to build solutions that are not only technically sound but also aligned with business goals. You’re confident working independently, yet always ready to contribute to a team effort.

Our Ideal Candidate Will Also Possess

• Strong Python skills, with experience pulling data from APIs
• A solid understanding of Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) database structures (MSSQL and BigQuery preferred)
• Experience in data warehouse development and design (BigQuery preferred)
• Proficiency in ETL tools such as SSIS, Talend, or Airflow
• Familiarity with BI tools like Power BI, Qlik Sense, or Looker (Power BI preferred)
• Excellent SQL query writing skills
• Exposure to cloud architecture and SaaS frameworks
• Excellent problem-solving and decision-making skills
• Ability to work both independently and collaboratively
• Experience with machine learning modelling in Python or R is an added bonus

Here, you will find:

• Community, in which authenticity is embraced, and the strength of our differences fuels our collective spirit.

• Culture of empowerment, learning & growth, that offers you the tools, space and opportunity to learn, innovate and lead

• Work that brings, fulfillment. From delighting clients every day, to inspiring our industry at large, every action makes a difference

Join us and belong to something beautiful.