# OneClick Principal Developer > NHS job listing from Job Clerk for Guy's and St Thomas' NHS Foundation Trust. ## Canonical URLs - **HTML:** https://www.jobclerk.com/job/oneclick-principal-developer/4c5ebe80-1125-41ea-b785-1b9c6d225b7f - **Markdown:** https://www.jobclerk.com/job/oneclick-principal-developer/4c5ebe80-1125-41ea-b785-1b9c6d225b7f.md ## Summary - **Status:** Live - **Employer:** Guy's and St Thomas' NHS Foundation Trust - **Location:** St Thomas' Hospital - **Workplace type:** onsite - **Profession:** Developer - **Grade:** Band 8 - **Salary:** £66,274 - £73,496 per annum including HCA - **Contract type:** Permanent - **Employment type:** Full time - 37.5 hours per week (On site at least 50%) - **Closing date:** 2026-11-01T23:59:00.000Z - **Posted:** 2026-10-20T10:30:37.507Z - **Source information URL:** https://www.healthjobsuk.com/job/UK/London/London/Guys_St_Thomas_NHS_Foundation_Trust/IT_Clinical_Systems_Reporting/IT_Clinical_Systems_Reporting-v8369459 - **Application URL:** https://apps.trac.jobs/job-advert/8369459?ShowJobAdvert=&feedid=9002 - **Employer website:** https://www.guysandstthomas.nhs.uk ## Job Content ### 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. ## Person Specification ### Knowledge **Essential** - Strong proficiency in SQL Server (T-SQL), including stored procedures, indexing, and query optimization. - Knowledge of data quality, security, and regulatory requirements (e.g., GDPR, HIPAA) in a healthcare setting. - Advanced knowledge of the Microsoft SQL Server product, including its services and their use - Advanced Knowledge of database design, management, administration and interrogation - Ability to work independently, manage priorities, and communicate effectively with both technical and non-technical stakeholders. - Advanced information presentation skills, evident in use of graphics and design of reports - Ability to plan ahead and anticipate potential problem areas, devising and implementing appropriate solutions - Ability to confidently manage and facilitate meetings and workshops - Excellent interpersonal skills and team working/building skills - Ability to provide and receive highly complex, sensitive or contentious information - Ability to negotiate with senior stakeholders on difficult and controversial issues including performance and change. - Ability to manage and deliver to deadlines and within resources; **Desirable** - Understanding of IM&T within the NHS including understanding the information flows between NHS organisations - Detailed knowledge and understanding of NHS administrative processes and systems ### Experience **Essential** - Substantial experience in an SQL Development role - Broad experience of using information derived from large and complex data sets - Substantial experience of data requirements gathering and report specification documentation - Substantial experience of developing complex datasets and information systems to meet with complex and changing customer requirements - Proven experience in SSRS report development, including parameterized reports, drill-through, and visual formatting - Experience working with clinical or healthcare datasets (e.g., EHR/EMR data, patient records, trial data) - Experience of report/extract testing tools and methodologies - Experience leading technical teams in good/best practice and innovation within IT spheres - Experience of authoring and quality assuring high quality technical documentation - Experience of researching best practice, interpreting relevance, and identifying practice which could be implemented to achieve improvements - Evidence of working sensitively but effectively with professional staff in a diverse environment. - Demonstrable experience of making significant judgements involving complex facts or situations requiring analysis and interpretation from a range of options **Desirable** - Experience of working with and influencing multiple stakeholders, across organisational and service boundaries - Experience of working in a tightly controlled change management environment with source data control - Experience of managing staff and supporting staff development ### Qualifications **Essential** - A Masters’ degree in Computer Science, Information Systems, Health Informatics, or a related field (or equivalent experience). - Specialist training in Microsoft SQL Server Management Studio - Specialist training in SQL Server Reporting Services (SSRS) **Desirable** - Specialist training in Microsoft Power BI ### Additional Requirements **Essential** - High level of numeracy with good attention to detail - Demonstrates the Guy’s and St. Thomas Trust values and behaviors - Evidence of continuous professional development ## Documents - [functional requirements (pdf, 168.7kb)](https://www.healthjobsuk.com/documents?vdoc=10699641) - [job description and person specification (pdf, 248.4kb)](https://www.healthjobsuk.com/documents?vdoc=10702167) ## Agent Notes - This Markdown page is generated from the same Job Clerk job record as the HTML job detail page. - Use the canonical HTML URL for user-facing references. - Use the application URL when the user wants to apply on the source NHS site.