Data Warehouse Engineer

Exemplar Health Care
Tinsley, S9 1UA, United Kingdom
3 months ago
Applications closed

Related Jobs

View all jobs

Senior Data Engineer

Pontoon Warwick, United Kingdom

Senior Data Engineer

Synthesia London, United Kingdom
Hybrid

Full Stack Software Engineer

83zero Lime Street, City And County Of the City Of London, United Kingdom
£100,000 – £130,000 pa Hybrid

Snowflake Data Architect - London, Wembley

Adecco London, United Kingdom
£80,000 – £90,000 pa On-site

Data Architect

DCV Technologies London, United Kingdom
£400 – £500 pd Contract

Snowflake / Data Architect - London, Wembley

Adecco London, United Kingdom
£80,000 – £90,000 pa On-site
Job Type
Contract
Contract Duration
6 months
Posted
13 Mar 2026 (3 months ago)

Data Warehouse Engineer - 6 Month FTC

When registering to this job board you will be redirected to the online application form. Please ensure that this is completed in full in order that your application can be reviewed.

Data Warehouse Engineer

Location: Exemplar Health Care Support Centre, Sheffield (Hybrid)

Contract: Full-time, Fixed Term Contract

Department: IT

Salary: Competitive, depending on experience

Make a Difference with Data. Join Exemplar Health Care.

At Exemplar Health Care, our mission is simple: to make every day better for the people we support and the colleagues who care for them. Data plays a vital role in helping us deliver safe, effective, and meaningful care across our complex care services.

We are now looking for a talented Data Warehouse Engineer to help modernise, optimise and scale our data infrastructure so we can deliver even smarter insights to our teams across the organisation.

If you love improving data processes, building efficient pipelines, and creating reliable structures that others can build on—this could be the role for you.

About the Role

You will play a key role in transforming our data warehouse and Azure data platform. This includes redeveloping Azure Data Factory (ADF) pipelines, implementing star schema models, and improving the reliability and quality of our data assets.

You will:

Azure Data Factory & Pipeline Development

* Group and redesign pipelines based on source systems and processing stages.

* Build parameterised pipelines to remove duplication and simplify change management.

* Migrate existing logic into a cleaner, streamlined structure.

* Remove old or redundant pipelines to create a more efficient environment.

Star Schema & Data Warehouse Development

* Help transition from denormalised 2D files to a robust star schema aligned to Kimball principles.

* Create and maintain new tables, stored procedures, and data workflows.

* Maintain and update our architecture matrix.

Data Quality & Infrastructure Monitoring

* Build automation to measure data quality, refresh success, and null frequency.

* Extract pipeline and platform performance data using Microsoft APIs.

* Support the development of a data infrastructure performance dashboard.

Collaboration & Documentation

* Use Bitbucket for version control and Confluence for documentation.

* Work closely with Analysts and the wider Data & Analytics team on shared development frameworks.

What We’re Looking For

Essential Skills

* Advanced SQL and strong understanding of relational database design.

* Proven experience with Azure Data Factory, including parameterised pipelines.

* Experience with Azure Functions, particularly Python.

* Strong understanding of star schema / Kimball modelling.

* Knowledge of APIs and automated data extraction.

* Understanding of the “Do Not Repeat (DRY)” principle.

* Experience with Git (Bitbucket preferred).

* Experience with data-quality validation and monitoring.

Desirable

* Azure Data Engineer Associate (DP-203).

* Azure Fundamentals (AZ-900) or Azure Developer (AZ-204).

* Experience documenting in Confluence.

* Experience in healthcare, social care, or another regulated sector.

Why Join Exemplar Health Care?

* A collaborative and supportive working culture.

* A chance to build scalable, modern data systems from the ground up.

* Real opportunities for professional development and certification.

* Work that directly improves outcomes for adults with complex needs.

* Hybrid working with flexibility where possible.

Apply Today

If you’re passionate about data engineering and want to use your skills to make a meaningful impact, we’d love to hear from you.

Apply now and help us shape the future of data at Exemplar Health Care

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Where to Advertise Data Science Jobs in the UK (2026 Guide)

Where to advertise data science jobs UK in 2026: the specialist boards, communities and channels that actually reach senior and lead data science talent. Data science spans a broad and often misunderstood spectrum — from statistical modelling and experimental design through to machine learning engineering, product analytics and AI research. The strongest candidates identify firmly with specific subdisciplines and are frustrated by adverts that conflate data scientist with data analyst, business intelligence developer or machine learning engineer. General job boards produce high application volumes for data roles but consistently fail to match specialist data science profiles with the right opportunities. This guide, published by DataScienceJobs.co.uk, covers where to advertise data science roles in the UK in 2026, how the main platforms compare, what employers should expect to pay, and what the data says about hiring across different role types.

Data Science Jobs UK 2026: What to Expect Over the Next 3 Years

Data Science Jobs UK 2026: roles, salaries and the trends shaping UK data science hiring over the next three years — from MLE crossover to GenAI workflows. Data science has spent the past decade being described as the sexiest job of the twenty-first century. By 2026, the reality is both more nuanced and more interesting than that label ever suggested. The discipline has matured, fragmented, deepened, and in some respects reinvented itself — and the jobs market has changed with it in ways that create genuine opportunity for those who understand what employers actually want, and genuine difficulty for those still operating on assumptions formed five years ago. The data science jobs market of 2026 is not simply a larger version of what it was three years ago. The generalist data scientist — equally comfortable wrangling data, building models, and presenting insights to the board — is giving way to a more specialised landscape where employers know exactly what problem they are trying to solve and are looking for candidates with the specific depth to solve it. Machine learning engineering, causal inference, experimentation, AI product development, and domain-specific applied science have all emerged as distinct career tracks within what was previously a single, loosely defined profession. At the same time, the arrival of large language models and the broader AI capability wave has both threatened and created data science roles in equal measure. Some of the work that junior data scientists spent their early careers doing — data cleaning, exploratory analysis, basic model building — is being partially automated by AI tooling. But the demand for practitioners who can evaluate AI systems rigorously, apply statistical thinking to complex business problems, and build the data foundations on which AI depends has grown considerably. The candidates who will thrive over the next three years are those who understand where the discipline is heading — which specialisms are attracting the most investment, which technologies are reshaping what data scientists are expected to build and know, and how to position a data science career that will remain valuable as the field continues to evolve around them. This article breaks down what the UK data science jobs market is likely to look like through to 2028 — covering the titles emerging right now, the technologies driving employer demand, the skills that will matter most, and how to position your career ahead of the curve.