Data Engineer - 12 FTC
Data Engineer - 12 FTC

Data Engineer - 12 FTC

London Full-Time 36000 - 60000 £ / year (est.) No home office possible
S

At a Glance

  • Tasks: Build and maintain data infrastructure, develop data pipelines, and support data-driven decisions.
  • Company: Sephora celebrates diversity and empowers individuals in the beauty industry.
  • Benefits: Flexible working arrangements and a culture of learning and growth.
  • Why this job: Make a real impact on business outcomes while collaborating with passionate teams.
  • Qualifications: Strong SQL, Python skills, and experience with cloud-based data architecture required.
  • Other info: Open to candidates in London or St Helier, Jersey.

The predicted salary is between 36000 - 60000 £ per year.

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 fulfilment. From delighting clients every day to inspiring our industry at large, every action makes a difference. Join us and belong to something beautiful.

Data Engineer - 12 FTC employer: Sephora

Sephora is an exceptional employer that champions diversity and inclusivity, fostering a culture where every employee feels valued and empowered. With a strong focus on community and personal growth, Sephora offers flexible working arrangements and the opportunity to work on impactful data projects that drive strategic decisions. Join us in London or St Helier, Jersey, and be part of a team that not only celebrates individuality but also prioritises learning and innovation in a fulfilling work environment.
S

Contact Detail:

Sephora Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Engineer - 12 FTC

✨Tip Number 1

Familiarise yourself with Sephora's values and culture. Understanding their commitment to diversity, inclusivity, and empowerment will help you align your approach during interviews and discussions, showcasing how you can contribute to their mission.

✨Tip Number 2

Brush up on your SQL and Python skills, especially in the context of data pipelines and ETL processes. Being able to discuss specific projects or experiences where you've successfully implemented these technologies will demonstrate your hands-on expertise.

✨Tip Number 3

Network with current or former employees of Sephora, particularly those in data roles. They can provide valuable insights into the company’s expectations and culture, which can help you tailor your approach and stand out as a candidate.

✨Tip Number 4

Prepare to discuss your experience with cloud technologies and data warehousing, particularly BigQuery. Be ready to explain how you've optimised data delivery and ensured data security in previous roles, as this aligns closely with the responsibilities of the position.

We think you need these skills to ace Data Engineer - 12 FTC

Strong SQL skills
Proficiency in Python
Experience with cloud-based data architecture
Data warehousing development and design
ETL development using tools like SSIS, Talend, or Airflow
Familiarity with BI tools such as Power BI, Qlik Sense, or Looker
Understanding of OLTP and OLAP database structures
Ability to assemble large, complex datasets
Experience with GCP technologies
Excellent problem-solving skills
Attention to detail
Ability to work independently and collaboratively
Experience with machine learning modelling in Python or R (bonus)
Knowledge of data security practices

Some tips for your application 🫡

Understand the Role: Read the job description carefully to understand the key responsibilities and required skills for the Data Engineer position at Sephora. Tailor your application to highlight how your experience aligns with these requirements.

Highlight Relevant Skills: Make sure to emphasise your proficiency in SQL, Python, and cloud technologies in your CV and cover letter. Provide specific examples of how you've used these skills in previous roles, especially in data warehousing and ETL development.

Showcase Collaboration Experience: Since the role involves working closely with BI and Analytics teams, include examples of past collaborative projects. Highlight your ability to work both independently and as part of a team, showcasing your problem-solving skills.

Craft a Compelling Cover Letter: Write a personalised cover letter that reflects your passion for data engineering and your understanding of Sephora's values. Mention how you can contribute to their mission of making data-driven decisions and supporting business outcomes.

How to prepare for a job interview at Sephora

✨Showcase Your Technical Skills

Make sure to highlight your proficiency in SQL, Python, and cloud technologies during the interview. Be prepared to discuss specific projects where you've built data pipelines or worked with data warehousing, as this will demonstrate your hands-on experience.

✨Understand Sephora's Values

Familiarise yourself with Sephora's commitment to diversity, inclusivity, and empowerment. During the interview, express how these values resonate with you and how you can contribute to a culture that embraces authenticity and community.

✨Prepare for Problem-Solving Questions

Expect to face technical problem-solving scenarios related to data architecture and ETL processes. Practice articulating your thought process clearly, as this will showcase your analytical skills and ability to tackle challenges effectively.

✨Demonstrate Collaboration Skills

Since the role involves working closely with BI and Analytics teams, be ready to share examples of past collaborative projects. Highlight how you’ve contributed to team success and how you value input from others in achieving common goals.

Data Engineer - 12 FTC
Sephora
S
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>