Senior Data Warehouse Engineer

Holland & Barrett; London; On-site; GBP 60,000 - 80,000; Full time

Benefits offered by this job

Technology Incentive Scheme

Learning and Development opportunities

28 or 33 days holiday per year

Job summary

A leading wellness company in London is looking for a Senior Data Warehousing Engineer to enhance their data capabilities. This role involves integrating various data sources and building a scalable data warehouse using AWS Redshift. Candidates should have 3–4 years of experience in data transformations and advanced SQL skills. The position offers a chance to impact the company's data strategy significantly and includes benefits like a technology incentive scheme, learning opportunities, and competitive holiday allowances.

Qualifications

• 3–4 years' experience transforming large datasets into analytics and BI solutions.
• Strong experience with cloud data warehouses (AWS Redshift preferred).
• Entrepreneurial mindset, strong communication skills, and a drive to deliver.

Responsibilities

• Integrating raw data sources into the data environment.
• Building and scaling the data warehouse in Amazon Redshift.
• Designing, building and maintaining ELT workflows.

Skills

Advanced SQL skills

Experience with AWS Redshift

Programming in Python

Data modelling

Working with large datasets

Data visualization

Education

Bachelor's degree in Software Engineering, Computer Science, or related field

Tools

Amazon Redshift

Matillion

Git

Docker

Job description

Overview

Data is the beating heart at Holland & Barrett. Our data teams — Data Engineering, Data Warehousing, BI, Data Science and Product Analytics — enable the company's vision of becoming the world leader in personalised wellness journeys. We aim to provide access to quality data at the speed of thought and to enable data-driven decision making across the organisation. We build and deploy advanced data products that deliver a world-class user experience to our customers.

We are looking for a passionate Senior Data Warehousing Engineer to join our growing Data & Analytics organisation. You'll be part of the Data Warehousing team, collaborating with Data Engineering, BI, Data Science and Product Analytics colleagues to shape the future of data at H&B.

About The Role

As a Senior Data Warehousing Engineer, you'll play a key role in building and scaling our data environment. You will integrate raw data sources — such as sales, supply chain and clickstream data — and design data models that enable BI reporting, customer segmentation and content personalisation. Your work will directly influence how H&B delivers for our customers. You'll work with technologies including Amazon Redshift, Matillion and the AWS ecosystem, and you'll be hands-on with SQL, ELT workflows and data modelling.

This is an exciting opportunity to make a big impact in a high-growth business, while collaborating across product, tech and business teams.

What You'll Be Doing

• Integrating raw data sources into the H&B data environment
• Building and scaling our data warehouse in Amazon Redshift
• Designing, building and maintaining ELT workflows
• Developing data cubes and applications to support BI, marketing and analytics
• Writing high-quality SQL and ensuring system health across our data stack
• Partnering with product, tech and business teams to deliver impactful projects
• Contributing to the vision, culture and strategy of the Data & Analytics organisation
• Bachelor's degree in Software Engineering, Computer Science, or related field
• 3–4 years' experience transforming large datasets into analytics and BI solutions (e-commerce experience is a plus)
• Highly advanced SQL skills
• Strong experience with cloud data warehouses (AWS Redshift preferred)
• Experience with at least one programming language (Python preferred)
• A broad technical skillset and eagerness to learn — from Git and Linux to APIs, Docker, NoSQL and serverless tools
• Bonus: experience in data visualisation, analytics or serverless data stacks (Lambda, Kinesis, API Gateway)
• Entrepreneurial mindset, strong communication skills, and a drive to deliver in a fast-paced environment

Benefits

• Technology Incentive Scheme - bonus schemes for all grades in Technology, starting at 10%
• Learning and Development opportunities
• Career progression
• Pension contribution
• 28 or 33 days holiday per year
• Refer and Earn Scheme
• Epic Extras benefits and discounted products (25% discount from day one)
• Free 24/7 confidential advice & colleague welfare
• Mental Health First Aiders and wellbeing support
• Reward and Recognition schemes