Principal Data Warehouse Developer

NHS; Leicester; On-site; GBP 50,000 - 70,000; Full time

Job summary

The NHS is seeking a Principal Data Warehouse Developer to lead the development of advanced data processing solutions for the National Flows team. This role involves managing technical design and development tasks, ensuring compliance with specifications while collaborating with various stakeholders to enhance data management processes. Candidates should have extensive experience with Microsoft tools for Data Management and possess the ability to thrive in high-pressure environments.

Qualifications

• Extensive experience with Microsoft SQL Server, SSIS, SSAS, ADF, and Azure Synapse Analytics.
• Proven experience in developing large-scale enterprise Data Warehouse solutions.
• Ability to manage workloads and deadlines in complex environments.

Responsibilities

• Design and build advanced data processing solutions for the National Flows team.
• Develop resilience and business continuity plans for database upgrades.
• Produce clear documentation for all developments and interpret technical specifications.

Skills

Expert knowledge of industry systems/technologies

Data Management

Business Intelligence

Experience in high-pressure environments

Tools

Microsoft SQL Server

SSIS

SSAS

ADF

Azure Synapse Analytics

Cloud technologies

Job description

Go back NHS Arden and Greater East Midlands Commissioning Support Unit

Principal Data Warehouse Developer

The closing date is 10 July 2025

We are looking for a driven and dedicated individual to support the Data Management Leads of the National Flows team, whose purpose is to manage all aspects of processing national datasets for Arden and GEM customers. They will be responsible for the technical design, development, and support of the DSCRO/Data Management service and associated technologies, tools, and solutions to deliver an effective service to Arden and GEM customers. The appointed person will ensure data flows are designed and developed in accordance with specifications describing customer and internal requirements, maintaining high levels of quality through an assurance process working closely with other team members and Dataset Leads.

Main duties of the job

Support the Data Management Leads of the National Flows team in managing all aspects of processing national datasets for Arden and GEM customers. Be responsible for the technical design, development, and support of the DSCRO/Data Management service and related technologies. Ensure data flows are designed and developed according to specifications. Maintain quality through an assurance process, collaborating with team members and Dataset Leads. Support strategic planning for technological solutions, researching best practices and technological advancements. Manage and provide expert advice to internal teams and external clients, prioritizing work plans, optimizing resources, and embedding quality throughout the service.

About us

NHS Arden & GEM supports over 90 customers across the health and care system, including NHS England, ICS, ICB, Trusts, and Local Authorities. Our team of over 1000 staff operates across the Midlands, North, West, South East, Greater Manchester, and Essex. We are committed to NHS values, building strong relationships, and providing innovative solutions to improve patient outcomes and optimize resource use.

Job responsibilities

Design and build advanced data processing solutions as the principal developer for the National Flows team. Develop large-scale data warehouse solutions using various data streams. Support future planning of the data warehouse system, including procurements, migrations, and upgrades. Develop resilience and business continuity plans for database upgrades. Produce clear documentation for all developments. Interpret complex technical specifications into data specifications. Evaluate new products and technologies for potential use within development projects.

Person Specification

• Expert knowledge of industry systems/technologies supporting Data Management and Business Intelligence
• Extensive experience with Microsoft SQL Server, SSIS, SSAS, ADF, Azure Synapse Analytics, and Cloud technologies
• Proven experience in developing large-scale enterprise Data Warehouse solutions using the Microsoft BI stack
• Ability to work effectively in high-pressure, complex environments, managing workloads and deadlines
• Experience designing database architecture within NHS settings
• Experience designing solutions within structured architectural environments, utilizing version control

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975. A Disclosure check will be required to verify any criminal convictions.

Employer name

NHS Arden and Greater East Midlands Commissioning Support Unit