NHS Arden and Greater East Midlands Commissioning Support Unit

Principal Data Warehouse Developer

The closing date is 10 July 2025

Job summary

We are looking for a driven and dedication 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 b 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 and they will maintain high levels of quality through management of an assurance process working closely with other members of the team and Dataset Leads.

Main duties of the job

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. To 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. To ensure data flows are designed and developed in accordance with specifications describing customer and internal requirements. Maintain high levels of quality through management of an assurance process working closely with other members of the team and Dataset Leads. To support the Data Management Leads in the strategic planning of current and future technological solutions to ensure optimal performance, researching and reviewing recognised best practice and upcoming technological enhancements. To manage and provide expert advice and support to internal teams and external clients including prioritising work plans, making best use of available resource and embedding quality throughout the service.

About us

NHS Arden & GEM supports over 90 customers spanning the entire health and care system including: NHS England (Regions and National Programmes), Integrated Care Systems (ICS), Integrated Care Boards (ICB), Trusts, and Local Authorities. Our people and solutions are not afraid to push the boundaries when playing an integral role in helping customers to meet the challenge of building integrated and sustainable healthcare. We have over 1000 staff, with offices throughout the Midlands, North, West and South East we cover a core geographic patch that extends to Greater Manchester in the north and Essex in the south. Our services are built on a strong foundation of experienced people who build great relationships, a commitment to NHS values and a thorough understanding of our clients and the challenges they face. We provide real value to our customers by working at scale, creating the synergies and innovation that ultimately drives improved patient outcomes and makes commissioning resources work harder.

Details

Date posted

26 June 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

£46,148 to £52,809 a year per annum

Contract

Fixed term

Duration

6 months

Working pattern

Full-time

Reference number

880-7035998-B

Job locations

County Hall

Leicester

LE1 6NB


Job description

Job responsibilities

To be the principal developer for the National Flows team designing and building advanced data processing solutions. To design, develop and implement large scale data warehouse solutions using different types of data streams. To support the National Flows team into future planning of the data warehouse system for example by ensuring that system procurements, migrations and upgrades are not considered without due considerations taking place. To support and develop resilience and business continuity plans for database upgrades. To produce clear documentation on all developments. To read and understand complex technical specification material so that these can be further developed into data specifications for developers. To evaluate new products and technologies and consider their usage as solutions within the development work program.

Job description

Job responsibilities

To be the principal developer for the National Flows team designing and building advanced data processing solutions. To design, develop and implement large scale data warehouse solutions using different types of data streams. To support the National Flows team into future planning of the data warehouse system for example by ensuring that system procurements, migrations and upgrades are not considered without due considerations taking place. To support and develop resilience and business continuity plans for database upgrades. To produce clear documentation on all developments. To read and understand complex technical specification material so that these can be further developed into data specifications for developers. To evaluate new products and technologies and consider their usage as solutions within the development work program.

Person Specification

Essential

Essential

  • Expert Knowledge of industry systems/technologies supporting Data Management/ Business Intelligence
  • Significant experience and training in Microsoft SQL Server, SSIS, SSAS, ADF, Azure Synapse Analytics and Cloud technologies.
  • Experience of developing large scale enterprise DW Solutions utilising the Microsoft BI stack
  • Experience of working in a pressured and complex environment requiring prioritisation of workloads and negotiation of delivery timescales

Desirable

  • Experience in designing database architecture in a complex NHS environment
  • Experience of designing solutions within Architectural capacity within a formal and structured environment utilising version control
Person Specification

Essential

Essential

  • Expert Knowledge of industry systems/technologies supporting Data Management/ Business Intelligence
  • Significant experience and training in Microsoft SQL Server, SSIS, SSAS, ADF, Azure Synapse Analytics and Cloud technologies.
  • Experience of developing large scale enterprise DW Solutions utilising the Microsoft BI stack
  • Experience of working in a pressured and complex environment requiring prioritisation of workloads and negotiation of delivery timescales

Desirable

  • Experience in designing database architecture in a complex NHS environment
  • Experience of designing solutions within Architectural capacity within a formal and structured environment utilising version control

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer details

Employer name

NHS Arden and Greater East Midlands Commissioning Support Unit

Address

County Hall

Leicester

LE1 6NB


Employer's website

https://www.ardengemcsu.nhs.uk/ (Opens in a new tab)


Employer details

Employer name

NHS Arden and Greater East Midlands Commissioning Support Unit

Address

County Hall

Leicester

LE1 6NB


Employer's website

https://www.ardengemcsu.nhs.uk/ (Opens in a new tab)


Employer contact details

For questions about the job, contact:

Head of Data Engineering

Stephen Smith

Stephen.smith32@nhs.net

Details

Date posted

26 June 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

£46,148 to £52,809 a year per annum

Contract

Fixed term

Duration

6 months

Working pattern

Full-time

Reference number

880-7035998-B

Job locations

County Hall

Leicester

LE1 6NB


Supporting documents

Privacy notice

NHS Arden and Greater East Midlands Commissioning Support Unit's privacy notice (opens in a new tab)