NHS South Central and West Commissioning Support Unit

Senior Data Warehouse Developer Apprentice

Information:

This job is now closed

Job summary

Contribute to the development and maintenance of data management solutions and being accountable for their delivery and operations. This apprentice will be a Band 5 working towards a Band 6 when qualified.

An individual who is able to contribute to the development and operational maintenance of a data management solution. This individual must be able to work independently and take the initiative with understanding the customer requirements and adapting existing solutions or proposing solutions under the guidance of the lead developers.

Main duties of the job

  • Working within a multi-disciplined team to implement and maintain data management solutions for SCW and its customers.
  • Implementation of solutions under the direction of the Data Warehouse Architect or more senior Data Management Services representative.
  • Commit to working and engaging constructively with internal and external stakeholders.

About us

The purpose of the Senior Data Warehouse Apprentice role is to contribute to the delivery and maintenance of SCW information systems. This will primarily be around ETL based solutions and data warehouses.

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 the Senior Data Warehouse Developer Apprentice will work as part of a team utilising development standards and working practices as defined by South, Central and West.

Details

Date posted

29 June 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£28,407 to £34,581 a year Per Annum Pro Rata

Contract

Apprenticeship

Duration

12 months

Working pattern

Full-time

Reference number

891-CSU-7589EB

Job locations

Omega House

Omega House

SO50 5PB


Job description

Job responsibilities

  • Contribute to the maintenance of complex Business Intelligence projects and information systems.
  • Contribute to the implementation of Business Intelligence projects and information systems under the guidance of the relevant lead.
  • Work independently on the maintenance of technical solutions using BI tools (Microsoft preferable).
  • Understand the basic functionality of any web/form-based application or tool using supplied documentation or through self-learning.
  • Keep documentation up to date where amendments are made
  • To be able to effectively gather requirements from customers and stakeholders.
  • Enabling skills and knowledge transfer to other team members.
  • Advise and influence decisions around ETL methodology and general data management processes.
  • Adhere to coding standards and methodologies within the development teams.
  • Communicate effectively with the project management team about progress.
  • Provide and receive complex information. The ability to understand complex information and act upon the context.

Job description

Job responsibilities

  • Contribute to the maintenance of complex Business Intelligence projects and information systems.
  • Contribute to the implementation of Business Intelligence projects and information systems under the guidance of the relevant lead.
  • Work independently on the maintenance of technical solutions using BI tools (Microsoft preferable).
  • Understand the basic functionality of any web/form-based application or tool using supplied documentation or through self-learning.
  • Keep documentation up to date where amendments are made
  • To be able to effectively gather requirements from customers and stakeholders.
  • Enabling skills and knowledge transfer to other team members.
  • Advise and influence decisions around ETL methodology and general data management processes.
  • Adhere to coding standards and methodologies within the development teams.
  • Communicate effectively with the project management team about progress.
  • Provide and receive complex information. The ability to understand complex information and act upon the context.

Person Specification

Values & Behaviours

Essential

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

Knowledge & Experience

Essential

  • Data Warehouse development / maintenance
  • Microsoft SQL Server
  • Software development project life cycle
  • Database performance tuning

Desirable

  • Kimball Data warehouse methodology
  • 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

Desirable

  • SQL Server Reporting Services
  • 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 / maintenance
  • Microsoft SQL Server
  • Software development project life cycle
  • Database performance tuning

Desirable

  • Kimball Data warehouse methodology
  • 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

Desirable

  • SQL Server Reporting Services
  • 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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Additional information

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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Employer details

Employer name

NHS South Central and West Commissioning Support Unit

Address

Omega House

Omega House

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

Omega House

SO50 5PB


Employer's website

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

Employer contact details

For questions about the job, contact:

.

Megan Watkins

megan.watkins3@nhs.net

Details

Date posted

29 June 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£28,407 to £34,581 a year Per Annum Pro Rata

Contract

Apprenticeship

Duration

12 months

Working pattern

Full-time

Reference number

891-CSU-7589EB

Job locations

Omega House

Omega House

SO50 5PB


Supporting documents

Privacy notice

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