Senior Systems Developer

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

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.

flexible-working

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

IMPORTANT

• Check your email account regularly as this is how we will communicate with you
• If you delete the job from any of your accounts, you may be prevented from accessing further communications
• To enquire about your application or inform us of any changes in your circumstances, please contact the named person on this advert
• Please provide email addresses for referees where possible
• Click here to see the range of benefits we offer
• Please review the documentation on our recruitment microsite, particularly the Trust's criminal records checking policy
• All staff have a responsibility for safeguarding children and vulnerable adults and for ensuring they are aware of the specific duties relating to their role.
• Please note that the closing date is given as a guide. On occasion, we might close a vacancy early due to a high number of applications being received. You are advised to submit your application as early as possible to avoid disappointment.

King's College Hospital NHS Foundation Trust Annual Reports and Other Corporate Publications

King's Health Partners Academic Health Science Centre Website

King's College Hospital is part of King's Health Partners Academic Health Sciences Centre (AHSC), a pioneering collaboration between King's College London, and Guy's and St Thomas', King's College Hospital and South London and Maudsley NHS Foundation Trusts.

Employer certification / accreditation badges

Documents to download

• Senior BI & Information Systems Developer (PDF, 344.4KB)
• Denmark Hill Site Map (PDF, 1.2MB)
• Princess Royal (PRUH) Site map (PDF, 1.4MB)
• Visa and Sponsorship Information (PDF, 352.6KB)