Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Build and scale our cloud data warehouse, turning complex data into impactful insights.
- Company: Join Holland & Barrett, a leader in wellness and health.
- Benefits: 33 days holiday, health cash plan, private medical care, and exclusive discounts.
- Why this job: Make a real difference in people's wellness journeys with data-driven solutions.
- Qualifications: Experience with cloud data warehouses, advanced SQL skills, and programming knowledge.
- Other info: Enjoy hybrid working and access to extensive learning opportunities.
The predicted salary is between 36000 - 60000 £ per year.
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!
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
Senior Data Warehouse Engineer employer: Holland and Barrett
Contact Detail:
Holland and Barrett Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Warehouse Engineer
✨Tip Number 1
Network like a pro! Reach out to current employees at Holland & Barrett on LinkedIn. Ask them about their experiences and any tips they might have for the interview process. It’s all about making connections that can help us stand out!
✨Tip Number 2
Prepare for those technical assessments! Brush up on your SQL skills and get comfortable with ELT pipelines. We recommend doing some practice problems on platforms like Coderbyte to get in the zone before the real deal.
✨Tip Number 3
Show off your problem-solving skills during the case study! Think aloud and explain your thought process clearly. Remember, it’s not just about getting the right answer; it’s about how you approach the problem that matters to us.
✨Tip Number 4
Don’t forget to highlight your collaborative mindset! Share examples of how you’ve worked with cross-functional teams in the past. At Holland & Barrett, we value teamwork, so let’s show them how well we can play together!
We think you need these skills to ace Senior Data Warehouse Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior Data Warehouse Engineer role. Highlight your experience with cloud data warehouses, especially Amazon Redshift, and showcase your SQL skills. We want to see how your background aligns with our mission at Holland & Barrett!
Showcase Your Projects: Include specific projects where you've designed and scaled data warehouses or worked with large datasets. We love seeing real-world examples of your work, so don’t hold back on the details that demonstrate your expertise and problem-solving skills.
Be Clear and Concise: When writing your application, keep it clear and concise. Use straightforward language to explain your technical skills and experiences. Remember, we want to understand your journey without getting lost in jargon!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, you’ll get to explore more about our culture and values while you’re at it!
How to prepare for a job interview at Holland and Barrett
✨Know Your Data Warehousing Stuff
Make sure you brush up on your knowledge of cloud data warehouses, especially Amazon Redshift. Be ready to discuss your experience with designing and scaling these systems, as well as any specific projects you've worked on that relate to the role.
✨Show Off Your SQL Skills
Prepare to demonstrate your advanced SQL skills during the interview. You might be asked to solve a problem or write a query on the spot, so practice common SQL scenarios and be ready to explain your thought process clearly.
✨Understand the Business Impact
Holland & Barrett is all about using data to improve customer experiences. Think about how your work in data warehousing can directly impact business outcomes. Be prepared to share examples of how you've turned complex data into actionable insights in previous roles.
✨Be Ready for Collaboration Questions
Since this role involves working closely with various teams, expect questions about collaboration. Prepare examples of how you've successfully worked with non-technical stakeholders to explain technical concepts or deliver data-led solutions.
