Data Warehouse Developer
Posted Today by Hunter Healthcare
£400 Per day
Outside
Undetermined
WC1V, Covent Garden, Greater London
Summary: The role of SQL Data Warehouse Developer involves supporting an NHS organization in the redesign and optimization of a large-scale operational data warehouse. The position requires hands-on delivery, focusing on rebuilding processing and business logic layers to enhance performance and ensure compliance with national reporting standards. Collaboration with an internal data team is essential to complete defined work packages within budget and time constraints.
Key Responsibilities:
- Rebuild and optimise existing SQL data warehouse processing and transformation layers
- Redesign business logic and KPI calculation frameworks to improve consistency and scalability
- Simplify and document complex legacy scripting
- Work through clearly defined technical work packages at pace
- Support peer review and quality assurance of development outputs
- Ensure alignment with national reporting and performance standards
Key Skills:
- Strong SQL development expertise with advanced scripting and transformation experience
- Proven experience optimising or rebuilding legacy data warehouse environments
- Strong understanding of ETL processes and data modelling principles
- Experience delivering complex KPI and performance indicator frameworks
- Ability to work independently within a prescriptive delivery structure
- Recent work directly in the NHS on a Data Warehouse related project
Salary (Rate): £400/day
City: Covent Garden
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: outside IR35
Seniority Level: Mid-Level
Industry: IT
We are seeking an SQL Data Warehouse Developers to support an NHS organisation with the redesign and optimisation of a large scale operational data warehouse environment. The existing solution has accumulated significant technical debt over time and now requires a full rebuild of the processing and business logic layer to improve performance, simplify KPI calculations and ensure alignment with national performance reporting standards. This is a hands on delivery role working closely with an established internal data team to complete clearly defined work packages within a fixed budget and timescale.
Key Responsibilities
- Rebuild and optimise existing SQL data warehouse processing and transformation layers
- Redesign business logic and KPI calculation frameworks to improve consistency and scalability
- Simplify and document complex legacy scripting
- Work through clearly defined technical work packages at pace
- Support peer review and quality assurance of development outputs
- Ensure alignment with national reporting and performance standards
Essential Skills and Experience
- Strong SQL development expertise with advanced scripting and transformation experience
- Proven experience optimising or rebuilding legacy data warehouse environments
- Strong understanding of ETL processes and data modelling principles
- Experience delivering complex KPI and performance indicator frameworks
- Ability to work independently within a prescriptive delivery structure
- Recent work direclty in the NHS on a Data Warehouse related project