NHS South Central and West Commissioning Support Unit

Advanced Data Warehouse Developer

Information:

This job is now closed

Job summary

An exciting opportunity has arisen within the Data Management Services department for an Advanced Data Warehouse Developer. This role would be suitable for a SQL/SSIS data warehouse developer who is looking to further progress their career or, an existing senior data warehouse developer with technical skills, wanting to work with data at a very large scale, in order to help improve outcomes for patients and support the wider NHS.

Main duties of the job

The role will require working on the projects assigned to the team under the direction of the Data Warehouse Architect or relevant lead. It is expected that an Advanced Data Warehouse Developer will work as part of a team utilising development standards and working practices as defined by South, Central and West.

  • Contribute to the technical design, development, implementation and maintenance of complex Business Intelligence projects and information systems.
  • Work independently on the development of technical solutions using Microsoft BI tools.
  • Understand basic functionalities of any web/form-based application or tool with by means of self-learning via reading guidance documents.
  • The creation of both technical guidance and processes where systems are developed are contributed to and keep documentation up-to date where amendments are made.
  • To be able to effectively gather requirements from customers and stakeholders.

About us

To find out more about what SCW has to offer, please visit Our offer to you page.

This is an exciting time to join NHS South, Central and West.

We are one of the largest commissioning support units in the country, providing support and professional expertise for over 70 NHS and non-NHS customers, including clinical commissioning groups, NHS England, local authorities, foundation trusts, social enterprises and other health-related organisation's.

We're supporting clients whose vision and quest for innovation requires us to be flexible, adaptable and open to adventure; giving us the freedom to work in new ways, looking at things from a different angle and challenging the norm.

We are an equal opportunities employer committed to attracting and retaining the best people in order to provide the best possible services to our customers. Our staff enjoys challenging, rewarding roles, supporting our customers to improve their local health and care services.

We want our people to fulfil their potential, so we offer a wide range of training, opportunities to gain qualifications as well as access to coaching, mentoring schemes and employee wellbeing and support for a healthy work-life balance.

Details

Date posted

08 March 2024

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year Per Annum

Contract

Permanent

Working pattern

Full-time

Reference number

891-CSU-7738CS

Job locations

Omega House

Eastleigh

SO50 5PB


Job description

Job responsibilities

Please refer to the job description and person specification for further details and information regarding this role.

#SCWjobs #SCWRecruitment #NHSjobs #NHSRecruitment #recruitment #jobs

Job description

Job responsibilities

Please refer to the job description and person specification for further details and information regarding this role.

#SCWjobs #SCWRecruitment #NHSjobs #NHSRecruitment #recruitment #jobs

Person Specification

Values & Behaviours

Essential

  • Patient First - Customer Excellence
  • Aspirational
  • Collaborative
  • Insightful
  • Respectful

Knowledge & Experience

Essential

  • Data Warehouse development
  • Kimball Data Warehouse methodology
  • Microsoft SQL Server
  • Software development project life cycle
  • Database performance tuning

Desirable

  • Authentication\Active Directory\ADFS
  • Server Infrastructure
  • Database administration
  • Microsoft SharePoint
  • .Net Development
  • Web development
  • Cloud technologies
  • Team Foundation Server

Skills & Capabilities

Essential

  • T-SQL
  • SQL Server Integration Services
  • SQL Server Reporting Services

Desirable

  • SQL Server Analysis Services
  • Tableau
  • SQL Server 2016+
  • C#/VB.Net
Person Specification

Values & Behaviours

Essential

  • Patient First - Customer Excellence
  • Aspirational
  • Collaborative
  • Insightful
  • Respectful

Knowledge & Experience

Essential

  • Data Warehouse development
  • Kimball Data Warehouse methodology
  • Microsoft SQL Server
  • Software development project life cycle
  • Database performance tuning

Desirable

  • Authentication\Active Directory\ADFS
  • Server Infrastructure
  • Database administration
  • Microsoft SharePoint
  • .Net Development
  • Web development
  • Cloud technologies
  • Team Foundation Server

Skills & Capabilities

Essential

  • T-SQL
  • SQL Server Integration Services
  • SQL Server Reporting Services

Desirable

  • SQL Server Analysis Services
  • Tableau
  • SQL Server 2016+
  • C#/VB.Net

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 South Central and West Commissioning Support Unit

Address

Omega House

Eastleigh

SO50 5PB


Employer's website

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


Employer details

Employer name

NHS South Central and West Commissioning Support Unit

Address

Omega House

Eastleigh

SO50 5PB


Employer's website

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


Employer contact details

For questions about the job, contact:

.

Jamie Lewinton

Jamie.Lewinton@nhs.net

Details

Date posted

08 March 2024

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year Per Annum

Contract

Permanent

Working pattern

Full-time

Reference number

891-CSU-7738CS

Job locations

Omega House

Eastleigh

SO50 5PB


Supporting documents

Privacy notice

NHS South Central and West Commissioning Support Unit's privacy notice (opens in a new tab)