Job summary
- Main area
- Business Intelligence
- Grade
- NHS AfC: Band 7
- Contract
- Permanent
- Hours
- Full time - 37.5 hours per week
- Job ref
- 213-CORP-6974294-A
- Employer
- King's College Hospital NHS Foundation Trust
- Employer type
- NHS
- Site
- King's College Hospital NHS Foundation Trust
- Town
- London
- Salary
- £54,320 - £60,981 per annum inc HCA's
- Salary period
- Yearly
- Closing
- 08/04/2025 23:59
Employer heading
Senior Systems Developer
NHS AfC: Band 7
King’s College Hospital NHS Foundation Trust is one of the UK’s largest and busiest teaching Trusts with a turnover of c£1.8 billion, 1.5 million patient contacts a year and more than 15,000 staff based across 5 main sites in South East London. The Trust provides a full range of local hospital services across its different sites, and specialist services from King’s College Hospital (KCH) sites at Denmark Hill in Camberwell and at the Princess Royal University Hospital (PRUH) site in the London Borough of Bromley.
We encourage all our staff to have a healthy work/life balance. In doing so, you can apply for flexible working from the beginning of your employment. We offer a range of options which are designed to suit different circumstances and priorities in line with service requirements.
Job overview
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.
Working for our organisation
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.
Detailed job description and main 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 criteria
- Educated to Masters level or equivalent level of of experience
- Specialist training in Datawarehousing or SQL
Desirable criteria
- Specialist training in Microsoft applications
- Specialist training in data science
- EPIC Cogito training/accreditation
Knowledge and Experience
Essential criteria
- 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 criteria
- Experience with EPIC DWH tools
- Knowledge of API
- Experience of XML translation
Skills and Competencies
Essential criteria
- 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
Employer certification / accreditation badges
Documents to download
Further details / informal visits contact
- Name
- Hardik Korat
- Job title
- BI & Data Warehouse Manager
- Email address
- [email protected]
List jobs with King's College Hospital NHS Foundation Trust in Administrative Services or all sectors