Trac proudly powers the recruitment for

Arden and GEM Commissioning Support Unit

About

Arden & GEM is one of the largest Commissioning Support Units in the country. Our customers include more than 60 Integrated Care Boards (ICB), NHS England, local authorities and a range of care providers.

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.

Our cornerstones are quality, value, innovation and complete customer focus.

Contact

Employee Services [email protected]

Find out more

open_in_new Jobs open_in_new Website

warning

Login changes are coming

From July 2025 onwards, Multi-Factor Authentication (MFA) will be introduced to this site. This will add an extra step to the login process: a requirement to enter a One Time Passcode (OTP) upon login to minimise fraud and maintain security. See our summary page here for more details.

Vacancy status: Open

Ref: 880-7035998-B Vacancy ID: 7307185

Principal Data Warehouse Developer

Accepting applications until: 10-Jul-2025 23:59

Vacancy status: Open

Accepting applications until: 10-Jul-2025 23:59

Key details

Location

Site: County Hall
Town: Leicester
Postcode: LE1 6NB
Major / Minor Region: Warwickshire

Contract type & working pattern

Contract: 6 months (Fixed Term)
Hours: Full time - 37.5 hours per week

Salary

Salary: £46,148 - £52,809 per annum
Salary period: Yearly
Grade: (NHS AfC: Band 7)

Specialty

Main area: Technical Role

Arden & GEM is a leading Commissioning Support Unit (CSU) working across the health and care system in England to provide transformational solutions, business support and clinical services. We work in partnership with other health and care organisations to design, develop and deliver better care for patients that improves health outcomes while making efficient use of resources. Regardless of function, specialism, or location, we are all united in our commitment to improving health and wellbeing for everyone.

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.

Arden & GEM CSU is committed to supporting the redeployment of our at risk employees. In line with our policy, staff at risk may be given preferential consideration to posts that could be considered suitable alternative employment. We reserve the right to close, delay or remove adverts while this process is completed. We apologise if you experience a delay in the shortlisting stage of the recruitment cycle.

Job overview

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.

Advert

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.

Working for our organisation

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. 

Detailed job description and main 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.

Please submit your application form without delay to avoid disappointment; we will close vacancies prior to the published closing date if we receive a sufficient number of completed application forms.

Please check the email account (including your junk mail) that you supplied as part of your application on a regular basis following the closing date and throughout the recruitment process, as this is how we will communicate with you.

All new entrants to the CSU for a permanent position will be subject to a 6 month probationary period. For new entrants appointed on a fixed-term basis, the probationary period is between 1 and 6 months.

Person specification

Essential

Essential criteria

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 criteria

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