Data Warehouse Engineer

Tinsley
2 days ago
Create job alert

Data Warehouse Engineer

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, Permanent
Department: Transformation Team
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

Related Jobs

View all jobs

Data Warehouse Engineer

Senior Data Engineer

Data Engineer

Senior Data Engineer

Data Engineer - Birmingham

Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

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

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.