Senior Data Warehouse Engineer

At Holland & Barrett, we're backing every body to live healthier, happier lives. Data plays a vital role in how we do that — helping us understand, personalise and improve wellness journeys for millions of people.

We're looking for a Senior Data Warehousing Engineer to help build, scale and evolve our cloud data warehouse. You'll work at the heart of our Data & Analytics function, turning complex data into trusted, high-impact insight that supports everything from BI and marketing automation to personalisation and customer experiences.

The Role

• Building and scaling our enterprise data warehouse using Amazon Redshift
• Integrating and ingesting large, diverse data sources including sales, supply chain and digital clickstream data
• Designing, developing and owning ELT pipelines using Matillion and AWS services
• Creating robust, well-modelled datasets and data cubes to power BI reporting and analytics
• Writing high-quality, performant SQL and maintaining strong data modelling standards
• Monitoring the data platform and taking ownership of reliability, performance and system health
• Working closely with product, technology and business teams to deliver data-led solutions
• Mentoring and supporting colleagues, contributing to a strong and inclusive data culture

Location: We offer hybrid working
, with occasional presence at one of our Holland & Barrett offices in UK for team meetings, collaboration sessions and key events.

The Person

• Strong experience designing and scaling cloud data warehouses (Redshift preferred)
• Advanced SQL skills and a deep understanding of data modelling concepts
• Experience working with large, complex datasets in a commercial environment
• Proficiency in at least one programming language (Python preferred)
• Comfort working across modern data and cloud tooling (e.g. AWS, Git, Linux, APIs)
• The ability to explain technical concepts clearly to non-technical stakeholders
• Curiosity, ownership and a collaborative mindset — comfortable working in a fast-moving environment
• 33 days holiday, including bank holidays
• Health Cash Plan
• Life Assurance
• Incentive scheme based on company & personal performance
• Virtual GP
• Private Medical care
• Holiday Purchase option
• Access to ‘Wellhub' with gyms, studios and wellbeing apps

• 25% Colleague Discount with FREE Standard Delivery
• Exclusive Discounts from a wide range of partners
• £/€50 Annual Product Allowance to spend in store

• Access to a variety of learning opportunities, including Level 2-5 Apprenticeships, Workshops and our Digital Learning Library
• AND MORE!

Recruitment Process

Our selection process is designed to be thorough, transparent, and aligned with the role. It includes:

• A short Coderbyte assessment to evaluate core technical and analytical skills
• An interview with the Hiring Manager to explore your experience and motivations
• A case study to demonstrate problem-solving and strategic thinking
• A follow-up review to delve deeper into your insights and approach with Hiring Manager and a senior colleague