Advanced Data Warehouse Developer

NHS South Central and West Commissioning Support Unit

Information:

This job is now closed

Job summary

The purpose of the Advanced Data Warehouse role is to contribute to the delivery and maintenance of SCW internal and external customer projects and information systems. This will range from simple reporting projects to full end to end Data Warehouses.

Contribute to the technical design, development and maintenance of data management solutions and being accountable for their delivery.

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
  • Line management responsibility for a team of technical developers

About us

Suitable for an individual who is able to contribute to the development and operational maintenance of a data management solution from initiation to completion. This individual must be able to work independently and take the initiative with understanding the customer requirements, working with stakeholders, and developing an end-to-end technical solution.

Date posted

22 December 2022

Pay scheme

Agenda for change

Band

Band 7

Salary

£41,659 to £47,672 a year Per Annum

Contract

Permanent

Working pattern

Full-time

Reference number

891-CSU-7441EB

Job locations

NHS SCW CSU

Bristol

BS1 3NX


Job description

Job responsibilities

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

Job description

Job responsibilities

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

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

NHS SCW CSU

Bristol

BS1 3NX


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

NHS SCW CSU

Bristol

BS1 3NX


Employer's website

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


For questions about the job, contact:

.

Timothy Edwards

timothy.edwards3@nhs.net

Date posted

22 December 2022

Pay scheme

Agenda for change

Band

Band 7

Salary

£41,659 to £47,672 a year Per Annum

Contract

Permanent

Working pattern

Full-time

Reference number

891-CSU-7441EB

Job locations

NHS SCW CSU

Bristol

BS1 3NX


Supporting documents

Privacy notice

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