Exemplar Health Care Support Centre, Sheffield
Data Warehouse Engineer
Location: Exemplar Health Care Support Centre, Sheffield (Hybrid)
Contract: Full‑time, Permanent
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:
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.
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
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.
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.
About Exemplar Health Care
Exemplar Health Care began as a healthcare consultancy and training firm. But we soon saw a gap in the sector: a lack of care homes for younger adults living with complex needs.
That insight shaped the mission we still live by today - to transform complex care and provide fulfilling opportunities for the people who need it most.
We’re now proud to have more than 60 care homes across England, providing nursing care for adults living with dementia, neuro-disabilities, mental health conditions, and physical disabilities.
Whoever you are, and whatever experience you bring, there are lots of ways you can help us make every day better for the people we support.
What’s happening at Exemplar Health Care
The people we support have unique needs and stories, but one thing stays the same across all our homes - we empower individuals to achieve personal goals in a safe and supportive environment.
Every new colleague attends an induction to learn about our company and complete mandatory and role-specific training, equipping you with the skills and knowledge to deliver exceptional care.
Whether your goals are in care, nursing, management, quality or support, we provide the confidence, skills and knowledge to help you excel in your role and advance your career, if you wish.
Happy, healthy colleagues mean better care for those we support. We offer a range of initiatives to ensure our colleagues thrive in safe and supportive environments.
From paid RCNi Learning access and NMC PIN payments for nurses to lifestyle and retail discounts for everyone, our rewards ensure your career is as fulfilling as it is rewarding.
From care homes to central support services, everyone plays a vital role. Hear from colleagues across various roles about what it’s like to work with us.
#J-18808-Ljbffr