Senior SQL / Integration Specialist
Job summary
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
About us
Our mission is to make a positive difference to people's lives by improving the quality of life for all we serve. Our values are: We Care, We Respect, We are Inclusive - so we are looking for people who live and breathe these qualities when supporting service users and carers, and in their relationships with colleagues in the Trust and our partner organisations.
Job description
Job responsibilities
as per attached JD and person specification
as per attached JD and person specification
as per attached JD and person specification
Person Specification
Education/ Qualification/ Training
- Relevant master's degree or equivalent knowledge and relevant experience
- Management/leadership qualification or equivalent experience
- Evidence of continued professional development
- ITIL qualification
Experience
- 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
- Leading service changes to improve performance
- Experience of working within a Digital Department environment
Knowledge and Skills
- 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
- 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.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.
Employer details
Employer name
East London NHS Foundation Trust
Address
The Green
ELFT NHS Flat 1
London
E2 9NJ
United Kingdom
Employer's website
https://www.elft.nhs.uk/