Job vacancy: Principal Data Warehouse Developer, Arden and GEM Commissioning Support Unit, Leicester

Job summary

Main area: SQL Developer
Grade: NHS AfC: Band 7
Contract: Permanent
Hours: Full time - 37.5 hours per week
Job ref: 880-6195401

Employer: Arden and GEM Commissioning Support Unit
Employer type: NHS
Site: St Johns House
Town: Leicester
Salary: £43,742 - £50,056 pa
Salary period: Yearly
Closing: 01/05/2024 23:59

Principal Data Warehouse Developer

NHS AfC: Band 7

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.

Detailed job description and main responsibilities

To support the Data Management Leads of the BI Systems team whose purpose is to manage all aspects of processing 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.

Person specification

Education./Training/Qualifications

Essential criteria

Professional qualification at degree level in an information related discipline or equivalent experience.
Evidence of continued professional development.

Desirable criteria

Post graduate qualification
Prince 2 qualified
Cloud certification

Experience

Essential criteria

Proven experience in the provision of data management systems
Significant experience in design and modelling of complex NHS data and systems
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 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
Experience in delivery of the responsibilities described in the JD

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.