Search for more NHS jobs in London
Job requirements
Essential
30 listedRequirements the employer expects applicants to meet.
- Knowledge
Strong proficiency in SQL Server (T-SQL), including stored procedures, indexing, and query optimization.
- Knowledge
Knowledge of data quality, security, and regulatory requirements (e.g., GDPR, HIPAA) in a healthcare setting.
- Knowledge
Advanced knowledge of the Microsoft SQL Server product, including its services and their use
- Knowledge
Advanced Knowledge of database design, management, administration and interrogation
- Knowledge
Ability to work independently, manage priorities, and communicate effectively with both technical and non-technical stakeholders.
- Knowledge
Advanced information presentation skills, evident in use of graphics and design of reports
- Knowledge
Ability to plan ahead and anticipate potential problem areas, devising and implementing appropriate solutions
- Knowledge
Ability to confidently manage and facilitate meetings and workshops
- Knowledge
Excellent interpersonal skills and team working/building skills
- Knowledge
Ability to provide and receive highly complex, sensitive or contentious information
- Knowledge
Ability to negotiate with senior stakeholders on difficult and controversial issues including performance and change.
- Knowledge
Ability to manage and deliver to deadlines and within resources;
- Experience
Substantial experience in an SQL Development role
- Experience
Broad experience of using information derived from large and complex data sets
- Experience
Substantial experience of data requirements gathering and report specification documentation
- Experience
Substantial experience of developing complex datasets and information systems to meet with complex and changing customer requirements
- Experience
Proven experience in SSRS report development, including parameterized reports, drill-through, and visual formatting
- Experience
Experience working with clinical or healthcare datasets (e.g., EHR/EMR data, patient records, trial data)
- Experience
Experience of report/extract testing tools and methodologies
- Experience
Experience leading technical teams in good/best practice and innovation within IT spheres
- Experience
Experience of authoring and quality assuring high quality technical documentation
- Experience
Experience of researching best practice, interpreting relevance, and identifying practice which could be implemented to achieve improvements
- Experience
Evidence of working sensitively but effectively with professional staff in a diverse environment.
- Experience
Demonstrable experience of making significant judgements involving complex facts or situations requiring analysis and interpretation from a range of options
- Qualifications
A Masters’ degree in Computer Science, Information Systems, Health Informatics, or a related field (or equivalent experience).
- Qualifications
Specialist training in Microsoft SQL Server Management Studio
- Qualifications
Specialist training in SQL Server Reporting Services (SSRS)
- Additional Requirements
High level of numeracy with good attention to detail
- Additional Requirements
Demonstrates the Guy’s and St. Thomas Trust values and behaviors
- Additional Requirements
Evidence of continuous professional development
Desirable
6 listedAdditional qualities the employer would prefer.
- Knowledge
Understanding of IM&T within the NHS including understanding the information flows between NHS organisations
- Knowledge
Detailed knowledge and understanding of NHS administrative processes and systems
- Experience
Experience of working with and influencing multiple stakeholders, across organisational and service boundaries
- Experience
Experience of working in a tightly controlled change management environment with source data control
- Experience
Experience of managing staff and supporting staff development
- Qualifications
Specialist training in Microsoft Power BI
Job overview
The OneClick archive is an in house built SQL Server Reporting Services (SSRS) based information system, integrated within the Electronic Patient Record (Epic) to give end users (predominately clinicians) access to legacy patient records from clinical systems that have been decommissioned.
This role will lead the management of the OneClick archive, including ongoing support, maintenance and resolution of issues. The successful candidate will lead new developments to the OneClick archive including analysis of requirements, design of reporting solutions, development of new datasets and reports.
They will utilise their specialist knowledge of SQL and NHS data models to develop solutions to business requirements and work these through from design to implementation as part of the OneClick archive support and development.
Main duties of the job
On each development project the post holder will:
- Develop SQL solutions and SSRS reports to enable access to archived data.
- Analyse and model SQL databases to extract the required information, sometimes with limited documentation.
- Lead meetings and engagement relating to the development of OneClick for clinicians, managers and other business users to agree requirements, priorities and action plans, encouraging participation and collaboration from all relevant stakeholders
- Pro-actively problem solve and negotiate where issues arise in the development and implementation of the solution
- Ensure OneClick solutions are developed within agreed timetables, accurately reflecting the defined business requirements
- Ensure the OneClick solution has passed quality assurance including working with clinicians, managers and business users to test and validate the solutions
Detailed job description and main responsibilities
- Lead on the development of OneClick reporting solutions working with IT Clinical Systems Technology, the Long Term Archive team, the decommissioning programme and clinical teams in an agile way.
- Manage the OneClick service including day to day management and line management of the OneClick developers.
- Responsible for the management of the OneClick archive including resolution of issues and fixes.
- Collaborate with stakeholders including the ITCS decommissioning programme, MIOs and ITCS Technology teams on a regular basis to agree design and troubleshoot issues
- Demonstrate/present detailed and technical developments in an easy to understand format to individuals and/or large groups of Programme and/or Trust staff
- Communicate creative workarounds in situations that demand quick alternative solutions
- Actively participate in regular meetings with clinicians, managers and other business users
- Resolve queries and effectively deal with contentions around data quality issues with stakeholders
- Allocate and supervise work to team members for co-ordinated activities ensuring work is delivered to agreed standards
- Provide technical guidance and training to others within and outside the team in areas of special expertise to facilitate knowledge sharing and development
- Manage the production of development plans that deliver agreed milestones and objectives.
- Manage the training of key users in newly developed functionality
- Ensure the OneClick reports are reliable and perform consistently.
- Produce robust documentation for all development work including procedures for all routine tasks performed
- Responsible for ensuring that all OneClick reports fulfil the highest standards of information security and privacy. This includes developing, promoting and maintaining data governance processes and procedures
- Ensuring the OneClick archive developments are fully tested and meet required standards
- Ensuring the technical platform that the OneClick archive uses can accommodate changes in technology. Proactively lead on undertaking audits of the OneClick archive to monitor usage, accuracy and efficiency. Lead plans to improve results of audit findings.
- Ensuring that any new developments or key enhancements are evaluated and progressed into formal business proposal outlining any benefits.
WhatsApp job alerts
Get instant WhatsApp alerts for Band 8 Developer roles in London
Create your Job Clerk account first. We'll collect your alert preferences during onboarding and help you turn on WhatsApp notifications for matching healthcare roles.
Applying for this NHS job
This advert is for OneClick Principal Developer with Guy's and St Thomas' NHS Foundation Trust in London, England. It is listed as a Band 8 Developer role. The advertised salary is £66,274 - £73,496 per annum including HCA. The contract type is Permanent. The application deadline is 01 Nov 2026.
Before you apply, compare the job description with the person specification and mirror the employer's essential criteria in your supporting information. Use the vacancy title, employer, location, salary, contract type, closing date and posted date (20 Oct 2026) to decide whether this role fits your current NHSjob search. If the employer can close applications early, prepare the application before the stated deadline rather than waiting for the final day.
For more context, review related Job Clerk pages for the same profession, band or location where they exist, then use the application-support guides to tailor your statement and prepare for interview.