Overview

An exciting opportunity has arisen to join the Performance Information Team who are seeking to appoint a Data Solutions Developer to support the Data Solutions Team in the development and maintenance of data warehousing and BI solutions on behalf of the Trust.

The successful candidate will have access to the NHS apprenticeship scheme with opportunity to study further academic qualifications.

JOIN OUR TELEGRAM CHANNEL

Main duties of the job

This post will provide support for Business As Usual (BAU), including daily process checks and the timely delivery of regular submission/reporting requirements. In doing so, the post holder will develop a robust knowledge of NHS and Trust datasets, and the wider Data Warehouse.

The role will offer the candidate the opportunity to familiarise themselves with a range of health systems and datasets, working closely with Information Analysts to support clinical staff and inform operational processes.

They will also be part of a team that transforms the existing data warehouse as the organisation seeks to increase data maturity on its journey moving to cloud hosting as part of a three-year digital data strategy.

Job description

Job Responsibilities

Technical skills include SQL (and other data manipulation languages), ETL tools, understanding RDBMS, Excel and BI Reporting tools such as SSRS and Power BI.

 

Data Warehousing / Data & Server Management

  • Participate in the development of data marts, data extracts and ETL/ELT processes in support of the Trusts federated Corporate Data Warehouse and the provision of a Single Source of Fact
  • To ensure that all developments and changes are fully documented, auditable and change control policies are adhered to
  • To liaise with external agencies, clinical users, & trust staff as required to support the development of the service to meet the needs of its users
  • To comply to standards in respect of database administration, ETL and data modelling, incorporating full documentation to support change control mechanisms and audit requirements
  • To perform continuous reviews on best practices for data transformation, data modelling and information reporting
  • To undertake other duties as designated by the Data Solutions Architect
  • To assist on the design, development & maintenance of the Corporate Data Warehouse which acts as the single platform for reporting utilising the most appropriate technologies.
  • To work as part of the team developing and deploying a cloud data warehouse solution

Special Features This role has a frequent requirement for intense concentration whilst developing & analysing complex database solutions.

The job is specialised in terms of the technical capabilities of the post holder and the ability to develop skills and experience in the following would be considered core requisites to undertake the role:

 

Programming Languages, Systems, Methodologies

  • SQL.
  • T-SQL (or another vendor).
  • SSIS.
  • Power BI.
  • VB.Net.
  • XML.
  • JSON.
  • PowerShell.
  • Azure Cloud.
  • Data Vault modelling.

Databases

  • SQL Server (Multiple Versions).
  • RDBMS.

 

Person Specification

Knowledge & Experience

Essential

  • Demonstrable experience and demonstrable understanding of Relational Database Design & Management.
  • Proven knowledge of ETL/ELT
  • Proven knowledge of Microsoft SQL Server, SSMS, SSIS and BIDS (or equivalent).
  • Strong proven SQL/T-SQL knowledge

Desirable

  • Understanding of multi-dimensional modelling.
  • A good proven knowledge across a multitude of NHS datasets and the complex data schemas and the Information it pertains to.
  • Proven knowledge of Azure, Data Vault, Agile, Power BI.
  • Proven knowledge of alternative data structures such as XML, JSON.
  • Demonstrable experience in working with programming/scripting languages such as VB.Net, and PowerShell.

 

Qualifications

Essential

  • Degree in relevant subject.
  • Educated to A level, similar qualifications, or work experience, or equivalent demonstrable experience.
  • Or equivalent demonstrable experience.

Desirable

  • Equivalent demonstrable experience in numerate/ informatics subject.

 

Aptitude & Abilities

Essential

  • Good investigative and problem-solving skills.
  • Proven mathematical reasoning skills.
  • Excellent keyboard skills.
  • Good analytical skills.
  • Business analysis skills.
  • Ability to work as part of a team.
  • Should be able to communicate between user requirements, technical requirements and constraints.
  • SQL skills ideally in SQL Server or relevant vendor.
  • Attention to detail.

Desirable

  • Good presentation skills.
  • Good telephone manners and ability to liaise with staff at all levels.
  • Good time management.
  • Good communication, both written and verbal.

 

Disposition/Attitude/Motivation

Essential

  • Determined and Self-motivated.
  • Team worker.
  • Proactive, take own initiative.
  • Analytical.
  • Good operational planner.
  • Results orientated.
  • Ability to work well in a busy environment.
  • Ability to prioritise.

Desirable

  • Partake in training to improve/motivate overall technical skills and proven knowledge.

 

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).

Apply for job

Rate & Write a Review