Senior Systems Developer: Sponsorship Available

King's College Hospital NHS Foundation Trust

Job Summary

The post holder will be responsible for the maintenance and further development of the Trust’s corporate data warehousing systems in facilitating Trust information needs. The post holder will be responsible for ensuring data integrity and availability of multiple system information to facilitate Trust reporting requirements to strict timelines.

The role will work closely with BI and Information system managers in providing data warehousing and reporting solutions. Providing systems expertise and support to Information analysts and Report developers that enable delivery of top class BI solutions.

Main duties of the job

Working within the Trust’s Business Intelligence Unit, we are looking for a talented and experienced BI and Information systems developer to further develop the Trust’s corporate Data Warehouse and BI systems. As part of BIU Systems team, the post holder will be working alongside other developers in provisioning performance information and support development of advance analytics to aid decision making within the Trust while ensuring data integrity and availability of multiple information assets. The post holder will be expected to work collaboratively across organisational boundaries and help to deliver information solutions in a complex and time pressured environment.

To succeed in the role, you will have strong technical and problem-solving skills and be comfortable working with the latest analytical techniques and technologies. The successful candidate will have expertise in Oracle PL/SQL, MSSQL, knowledge of the MSSQL BI Stack and Oracle APEX.

Experience of working with health related data in the NHS will be advantageous but is not a limiting factor if the candidate has proven technical skills in Data Warehousing /Analytics, and a desire to learn NHS datasets. Key terms: ETL, SSIS, PL/SQL, T-SQL, SSRS, SSAS, PowerBI, Oracle APEX, Data Science, Python.

Person Specification

Education and Qualifications

Essential

  • Educated to Masters level or equivalent level of of experience
  • Specialist training in Datawarehousing or SQL

Desirable

  • Specialist training in Microsoft applications
  • Specialist training in data science
  • EPIC Cogito training/accreditation

Knowledge and Experience

Essential

  • Demonstrable experience working in an NHS informatics setting
  • Knowledge of different database schema designs and use cases
  • Substantial experience writing complex relational and multidimensional SQL

Desirable

  • Experience with EPIC DWH tools
  • Knowledge of API
  • Experience of XML translation

Skills and Competencies

Essential

  • Advance database development skills
  • Proficiency in SSIS and/or other ETL tools
  • Data modelling including use of SSAS
  • Methodical and organised, ability to work on own initiative

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

Closing Date: 08 April 2025

To apply for this job please visit apps.trac.jobs.