Data Engineer - 12 FTC

Profile

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 OpportunityAt 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 ForDesigning, building, and maintaining scalable data pipelines and architectureAssembling large, complex datasets that meet functional and non-functional business requirementsCollaborating with BI and Analytics developers to deliver actionable insightsAutomating manual processes and optimising data delivery for performance and scalabilitySupporting the extraction, transformation, and loading (ETL) of data from diverse sources using SQL and GCP technologiesEnsuring data security and separation across systems and teamsMonitoring 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 PossessStrong Python skills, with experience pulling data from APIsA 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 AirflowFamiliarity with BI tools like Power BI, Qlik Sense, or Looker (Power BI preferred)Excellent SQL query writing skillsExposure to cloud architecture and SaaS frameworksExcellent problem-solving and decision-making skillsAbility to work both independently and collaborativelyExperience 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 leadWork 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.