Senior Data Engineer

What’s the role about? As the UK’s most effective omni-channel retailer, E-Commerce is a key part of Our Business - we run two of the busiest websites in the UK, driving a significant proportion of our sales. Our Engineering practice includes 60+ teams, working on everything from Cloud Platforms to Mobile Apps, from E-Commerce functionality to Machine Learning. Our Engineers work collaboratively and share knowledge, and learning is extremely important to us. We support our Engineers to continuously improve their skills and keep abreast of the latest technologies. Find out more about being a Data Engineer in the Partnership, and the technology we use. What you’ll be doing? This is an opportunity to join our John Lewis Partnership Data Platform (PDP) team working as a Senior Data Engineer. You will be using your extensive Data Engineering skills and experience in designing, implementing and supporting secure cloud-based data platforms, ensuring high-quality delivery outcomes across our data landscape. The vision for PDP is to embed data-driven decision-making and analytics at scale, across the Partnership. We recognise the importance of data and are backing a significant investment in developing the platform. We are transforming our in-house Data Engineering capability, which has been at the heart of a move to a cloud-native data platform, to become Product delivery focused. Recent successes have been the PDP underpinning customer experience and loyalty outcomes such as my JL Rewards and the relaunch of my Waitrose. As a Senior Data Engineer, you will participate in the shaping and delivery of data solutions to meet the needs of a wide variety of stakeholders from across the Partnership. You will be able to propose and build, run and own high quality data products. You will have a passion for using technology to deliver innovative and innovative software and data solutions and will have a proven history of working in teams delivering complex, performant, high-quality software. We want you to work well in a fast-paced environment and have a focus on quality, ensuring the delivery aligns with the needs of the business, whilst also being supportable and maintainable and with clear ownership. You will be a mentor for exceptional data DevSecOps for our Partners and customers. Internally this role is called Product Engineer (PL6) What you’ll already have: Expert skills in building cloud-based data pipelines using data orchestration and workflow platforms. We use Airflow/Cloud Composer with Python but you may have experience with different orchestration/workflow tools or programming languages. Experienced running/coaching teams - responsible for designing solutions and aiding the team implement these solutions.Advanced SQL skills, with a deep understanding of how to write performant SQL and debug problemsExperience with a cloud-based relational Data Warehousing productData transformation tools, preferably DBTCloud-Based data platforms, preferably Snowflake or Big QueryDesigning secure data pipelines and fixing security/performance issuesIdentification of data quality issuesDeploying to at least one major Cloud Platform such as AWS, GCP or AzureExperience in platform as a code, particularly TerraformContinuous Integration/Continuous DeliveryTDD, pair programming, preferably PythonAgile development methods such as Scrum or Kanban. What else you could bring: Containerisation, KubernetesBuilt and/or championed observability platformsEvent-driven designGitlab CI, Jenkins, Circle CI, JiraData orchestration and workflow technologies such as AirflowVisualisation & reporting tools such as Tableau or LookerETL tools such as Apache Beam or AbInitioKnowledge or experience of DataVault (DV2)Data VisualisationUnderstanding of Data Management Concepts. Where will you be working?: We have opportunities at both our John Lewis Head Office in London, Pimlico and Waitrose Head Office in Bracknell, Berkshire. We have a blended hybrid approach of working from our offices and a home/remote UK location. You are contracted to a Partnership office location. If you choose to work remotely you should be aware that from time to time, you will need to come into the office. This decision is made within your team.