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. 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. Date posted 26 March 2025 Pay scheme Agenda for change Band Band 7 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 Denmark Hill London SE5 9RS Job description 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. Job description 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 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 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). 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 King's College Hospital NHS Foundation Trust Address King's College Hospital NHS Foundation Trust Denmark Hill London SE5 9RS Employer's website https://www.kch.nhs.uk/ (Opens in a new tab)