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