Data Warehouse Developer

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