Search for more NHS jobs in London
Job overview
Join our dynamic team as a Senior SQL and Integration Specialist (Band 7), where you will play a pivotal role in designing, developing, and supporting robust data integration solutions across our organisation.
In this role, you will bring advanced expertise in SQL development within RiO (Electronic Patient Record system), including writing complex queries, optimising stored procedures, and supporting reporting and data extracts from RiO databases to enable accurate clinical and operational insights. You will lead on database performance tuning, data quality assurance, and the development of secure, scalable interfaces between key clinical and corporate systems, ensuring reliable data flows across the Trust. Working closely with multidisciplinary stakeholders, you will translate business requirements into technical solutions, particularly leveraging your knowledge of RiO data structures and workflows, while driving continuous improvement and best practice in SQL and integration (e.g., ETL pipelines, APIs, HL7/FHIR).
This is an exciting opportunity for an experienced data professional with strong SQL expertise, RiO experience, and a passion for delivering high-impact digital services in a complex healthcare environment.
Main duties of the job
SQL Developer duties and responsibilities
- Develop, implement, and optimize SQL scripts using T-SQL
- Review and interpret ongoing business report requirements
- Analyse existing SQL queries for performance improvements
- Suggest new queries
- Develop scripts for data migration, audits, data quality
- Develop scripts for use in EPRs, in particular RiO
- Provide timely scheduled management reporting
- Build useful and efficient reporting for deliverables
- Keeping up to date with the latest SQL developments and best practices
Detailed job description and main responsibilities
as per attached JD and person specification
as per attached JD and person specification
as per attached JD and person specification
Person specification
Experience
Essential
- At least 3 years’ experience as a SQL Developer or similar role
- Hands-on T-SQL programming experience
- Experience with modern relational databases.
- Advanced Microsoft office applications e.g., Visio, Excel, PowerPoint
Desirable
- Leading service changes to improve performance
- Experience of working within a Digital Department environment
Knowledge and Skills
Essential
- Excellent understanding of T-SQL Programming
- Problem-solving: ability to identify and troubleshoot database issues and find solutions to complex problems.
- Skilled at developing or optimising long, complicated SQL statements
Desirable
- Collaboration: Ability to collaborate effectively with other members of the development team, product managers, designers and business analysts.
- Time Management: Ability to manage own time effectively to meet project deadlines.
Education/ Qualification/ Training
Essential
- Relevant master’s degree or equivalent knowledge and relevant experience
Desirable
- Management/leadership qualification or equivalent experience
- Evidence of continued professional development
- ITIL qualification
WhatsApp job alerts
Get instant WhatsApp alerts for Band 7 Medical Secretary 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 Senior SQL / Integration Specialist with East London NHS Foundation Trust in London, London, England. It is listed as a Band 7 Administrative and IT role. The advertised salary is £58,133 - £65,261 per annum. The contract type is Fixed term: 8 months (Until end of March 2027). The application deadline is 28 Jul 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 (29 Jun 2026) to decide whether this role fits your current NHS job 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.