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