Senior Systems Developer

King's College Hospital NHS Foundation Trust

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.

About us

King's College Hospital (KCH) is one of London's largest, busiest and most prestigious teaching hospitals in the diverse area of Camberwell, South London. The Trust has several sites and serves patients locally, nationally and internationally. This post will be based at Denmark Hill site and there may be occasions when the post holder would be required to work at Princess Royal University Hospital sites.

Job responsibilities

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.

The post holder will be working very closely with the Operations, Finance and IT directorates in guiding and implementing information systems related decisions. The systems include the Trust corporate data warehouse, Patient Administration system, Clinical system, Theatre system, Emergency Department system and any other that may hold reportable data.

The post holder will also play a crucial role in designing and implementing end to end automated performance reporting solutions. In the longer-term contribute to identify, evaluate and implement latest data warehousing and data science technologies for automation and predictive analysis.

Person Specification

Education and Qualifications

• Educated to Masters level or equivalent level of experience
• Specialist training in Data warehousing or SQL
• Specialist training in Microsoft applications
• Specialist training in data science

Knowledge and Experience

• 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
• Experience with EPIC DWH tools
• Knowledge of API
• Experience of XML translation

Skills and Competencies

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

Salary

£54,320 to £60,981 a year per annum inc HCA's

Contract

Permanent

Working pattern

Full-time

Reference number

213-CORP-6974294-A

Job locations

King's College Hospital NHS Foundation Trust