Data Warehouse Specialist Developer (EPR)

Job summary

Salisbury NHS Foundation Trust is excited to offer an opportunity for an ambitious individual to join our Data and Informatics team as a Data Warehouse Specialist Developer on a Fixed Term Contract to support the implementation of the new Shared EPR.

We are looking for a dynamic, forward thinking individual to work closely with the Data Architect tomaintain and develop the Trust Data Warehouse and BI architecture including performance, maintainability and scalability along with a secure, governed and well architected data infrastructure.

This role will act as a technical expert to users both within the department and to other departments around the Trust in the following key areas:

  • Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS)
  • PostgreSQL
  • Data Warehousing Architectures
  • Microsoft Power BI

To be successful in this role you will have a real eye for detail, an analytical mind-set, excellent communication skills and a willingness to adapt your approach with our stakeholders and interpret requirements with the enthusiasm to get the job done to the highest standards.

Experience of working with NHS data is essential for this role.

Main duties of the job

The post holder is responsible for the adaptation, support and development of the technologies and processes supporting the safe use of the Trust Data Warehouse & BI Platform (a major trust wide information system). Ensuring accurate data flows to support Trust Financial Reporting, Income Recovery, National Data Submissions and Internal reporting requirements

About us

Salisbury NHS Foundation Trust (SFT) is an innovative hospital with a proud heritage and over 250 years of experience behind us. Here we're driven to deliver an outstanding experience for everyone and have been well regarded for the quality of care and treatment we continue to provide for our patients and also our staff.

We are an acute Trust, rated "Good" by the CQC, with a track record of high performance providing regional and super regional specialist services such as: Burns, Plastics & Reconstructive Surgery, Wessex Regional Genetics Laboratory, Wessex Rehabilitation, Spires Cleft Centre and the Duke of Cornwall Spinal Treatment Centre. We have about 470 beds and employ over 4000 staff.

We support flexible working and will consider requests taking into account the needs of the service. We think working here is pretty rewarding. You can access a range of NHS discounts, receive a minimum of 35 days paid holiday (pro rata), and we offer a generous pension scheme. On-site benefits include car parking (fee applies), leisure centre, day nursery and holiday play scheme.

Salisbury is an attractive place to live and work and really gives you the best of everything. With easy access to London and local airports, the city of Southampton is only a short train or car journey away or if you prefer the sea, Bournemouth is also accessible. Don't just take our word for it, why not explore what Salisbury has to offer by visiting www.experiencesalisbury.co.uk

Job description

Job responsibilities

Please see attached Job description and person specification for full details of roles and responsibilities.

Person Specification

Qualifications

Essential
  • Masters degree or equivalent relevant training and experience.
Desirable
  • Degree in relevant subject
  • Evidence of continued professional development

Experience

Essential
  • Significant experience of working in a Data Warehouse environment in a large organisation.
  • Significant development experience with SQL (including T-SQL, SSIS, SSRS & SSAS), or PostgreSQL
  • Demonstrable experience working in an NHS Acute/Community Trust
Desirable
  • Previous experience working in an Information Department within the NHS
  • Experience delivering specialist training to other staff and organisations in all aspects of the Data Warehouse technical environment.
  • Previous experience working within a shared EPR Programme

Knowledge

Essential
  • Expert knowledge of the NHS Data Manual, Information Standards, data flows and statistical returns.
  • Expert knowledge of Microsoft SQL Server (T-SQL, SSIS, SSRS, SSAS), PowerBI and Data Warehouseing Architectures
  • Clear understanding of NHS patient activity information, statutory data requirements, data definitions and performance measures
  • Ability to communicate complex (potentially contentious or sensitive) analytical issues to data literate persons or groups at various levels.
Desirable
  • Knowledge of NHS datasets and specialised coding structures (eg CDS, OPCS4, ICD10, HRG)
  • Technical Knowledge of PostgreSQL

Employer details

Employer name

Salisbury NHS Foundation Trust

Address

Salisbury NHS Foundation Trust

Odstock Road

Salisbury

SP2 8BJ

United Kingdom

Employer's website

https://www.salisbury.nhs.uk/

Job Details

Company
Salisbury NHS Foundation Trust
Location
Salisbury, SP2 8BJ, United Kingdom
Salary
£49387.00 to £56515.00
Posted