Senior Data Warehouse Engineer

HOLLAND AND BARRETT; Greater London; Hybrid; GBP 65,000 - 80,000; Full time

Job summary

A health-focused retail company is seeking a Senior Data Warehousing Engineer to enhance their cloud data warehouse and support data-led solutions. You will build and scale the data architecture using Amazon Redshift, design ELT pipelines, and work with diverse datasets. Strong SQL and cloud experience, particularly with AWS services, are essential. The position offers hybrid working options and various wellbeing benefits, including 33 days holiday and health plans.

Benefits

33 days holiday including bank holidays

Health Cash Plan

Life Assurance

Incentive scheme

Virtual GP

Private Medical care

FREE at-home blood test kit

Holiday Purchase option

Pension Contribution scheme

Access to Wellhub

Qualifications

• Strong experience designing and scaling cloud data warehouses.
• Advanced SQL skills for data manipulation.
• Experience with large datasets in commercial settings.

Responsibilities

• Build and scale the enterprise data warehouse using Amazon Redshift.
• Integrate diverse data sources for analysis.
• Design and develop ELT pipelines using Matillion and AWS.

Skills

Cloud data warehouse design

SQL proficiency

Data modelling

Programming (Python)

AWS services

Git

Linux

APIs

Tools

Amazon Redshift

Matillion

Job description

About Data at Holland & Barrett

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.

The Role

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.

What you\'ll be doing

• 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 the UK for team meetings, collaboration sessions and key events.

The Person

What you\'ll bring

• 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

Benefits

Wellbeing & Lifestyle Benefits

• 33 days holiday, including bank holidays
• Health Cash Plan
• Life Assurance
• Incentive scheme based on company & personal performance
• Virtual GP
• Private Medical care
• FREE at-home blood test kit
• Holiday Purchase option
• Pension Contribution scheme
• 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

Learning & Development

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

#LI-Hybrid

#LI-CM1

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