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
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
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.