Senior Data Warehouse Engineer

OverviewData 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 RoleAs 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 DoingIntegrating raw data sources into the H&B data environmentBuilding and scaling our data warehouse in Amazon RedshiftDesigning, building and maintaining ELT workflowsDeveloping data cubes and applications to support BI, marketing and analyticsWriting high-quality SQL and ensuring system health across our data stackPartnering with product, tech and business teams to deliver impactful projectsContributing to the vision, culture and strategy of the Data & Analytics organisationBachelor's degree in Software Engineering, Computer Science, or related field3–4 years' experience transforming large datasets into analytics and BI solutions (e-commerce experience is a plus)Highly advanced SQL skillsStrong 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 toolsBonus: 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 environmentBenefitsTechnology Incentive Scheme - bonus schemes for all grades in Technology, starting at 10%Learning and Development opportunitiesCareer progressionPension contribution28 or 33 days holiday per yearRefer and Earn SchemeEpic Extras benefits and discounted products (25% discount from day one)Free 24/7 confidential advice & colleague welfareMental Health First Aiders and wellbeing supportReward and Recognition schemes

#J-18808-Ljbffr