Location
London

Hours
Full Time

Salary
£73,496 per annum

About the Role
Guy’s and St Thomas’ NHS Foundation Trust is one of the UK’s busiest and most successful NHS foundation trusts, providing a wide range of hospital and community services across south London and specialist care for patients from further afield. The Trust is home to leading centres including the largest dental school in Europe, a £160 million Cancer Centre, Evelina London Children’s Hospital, and one of the largest critical care units in the UK. In 2021, the Royal Brompton and Harefield hospitals joined the Trust, creating a world-renowned heart and lung centre.

The OneClick archive is an in-house built SQL Server Reporting Services (SSRS) based information system integrated within the Electronic Patient Record (Epic), enabling clinicians and other users to access legacy patient records from decommissioned clinical systems.

This role will lead the management, support, maintenance, and development of the OneClick archive. The successful candidate will analyse requirements, design reporting solutions, and develop new datasets and reports using specialist knowledge of SQL and NHS data models. You will work collaboratively with clinical teams, IT departments, and other stakeholders to ensure the OneClick archive meets business needs and maintains high standards of quality, security, and performance.

Guy’s and St Thomas’ NHS Foundation Trust and King’s College Hospital NHS Foundation Trust share a vision for agile digital services and significant investment in Electronic Health Records (EHR) to transform healthcare delivery. This role offers the opportunity to contribute to this digital transformation within two of London’s largest teaching hospitals.

Experience
- Substantial experience in SQL development and SSRS report creation including parameterized reports, drill-through, and visual formatting
- Experience working with large, complex healthcare datasets such as EHR/EMR and patient records
- Proven ability to gather data requirements and produce detailed report specifications
- Experience leading technical teams and managing development projects
- Skilled in testing, quality assurance, and authoring high-quality technical documentation
- Experience working sensitively and effectively with diverse professional staff
- Ability to analyse complex situations and make informed judgements
- Desirable: experience influencing multiple stakeholders, managing staff, and working in controlled change management environments

About you
- Strong interpersonal and team-building skills with excellent communication abilities
- Ability to work independently, manage priorities, and facilitate meetings and workshops
- High attention to detail and numeracy skills
- Demonstrates commitment to continuous professional development
- Ability to negotiate with senior stakeholders on complex and sensitive issues
- Commitment to the Trust’s values and behaviours
- Desirable: understanding of NHS IM&T, information flows, and administrative processes

Qualifications
- Essential: Master’s degree in Computer Science, Information Systems, Health Informatics, or related field (or equivalent experience)
- Specialist training in Microsoft SQL Server Management Studio and SQL Server Reporting Services (SSRS)
- Desirable: specialist training in Microsoft Power BI