Data Warehouse Engineer
UK Visa Sponsorship Analytics
Analytics are greyed out due to low classification confidence (44.0%).
Occupation Type
IT business analysts, architects and systems designers
Occupation Code Skill LevelHigher Skilled
Sponsorship Salary Threshold
£54,900
(£28.15 per hour)
Occupation rate applies
Above analytics are generated algorithmically based on job titles and may not always be the same as the company's job classification. You can also check detailed occupation eligibility, and salary criteria on our UK Visa Eligible Occupations & Salary Thresholds page.
Disclaimer: Hunt UK Visa Sponsors aggregates job listings from publicly available sources, such as search engines, to assist with your job hunting. We do not claim affiliation with Exemplar Health Care. For the most up-to-date job details, please visit the official website by clicking "Apply Now."
Description
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 betterfor 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 onthis 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
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 betterfor 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 onthis 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.
- Help transition from denormalised 2D files to a robuststar schemaaligned to Kimball principles.
- Create and maintain new tables, stored procedures, and data workflows.
- Maintain and update our architecture matrix.
- 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 Were Looking For
Essential Skills
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.
- 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.
- 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.
If youre passionate about data engineering and want to use your skills to make a meaningful impact, wed love to hear from you.
Apply now and help us shape the future of data at Exemplar Health Care.
LNKD1_UKTJ