Person Specification

Qualifications

Essential

• Educated to degree level or equivalent experience
• Advanced knowledge in T-SQL and scripting languages
• Advanced knowledge in Microsoft Power BI, including dashboard development, acquired through training and experience
• Evidence of continued professional development

Experience

Essential

• Proven track record of working within an Informatics environment within the NHS
• Experience in programming, configuring, managing and maintaining the operation of complex databases and developing and manipulating large, complex datasets from clinical systems and data warehouses
• Advanced expertise in T-SQL development, including writing, optimising and troubleshooting complex queries across large datasets to improve efficiency, accuracy and reproducibility of reporting processes
• Developed and maintained automated reporting solutions (including Visual Studio or equivalent tools) and created interactive dashboards using Microsoft Power BI, incorporating DAX calculations.
• Experience of data interrogation and data linking, able to analyse complex issues where material is conflicting and drawn from multiple sources.
• Experience in system testing, quality assurance and problem-solving.
• Experience in presenting data to colleagues and shareholders.

Knowledge, Skills & Abilities

Essential

• Developed specialist knowledge of data collection and analysis within a Trust to design and develop reports.
• Working knowledge of Microsoft SQL Server Management Studio.
• Knowledge of automating reports using Visual Studio.
• Knowledge of Microsoft Power BI.
• Extensive working knowledge of the Microsoft Office package – particularly Word, Access and Excel.
• Understanding of governance, risk management, data protection and confidentiality requirements.
• Ability to analyse, interpret and synthesise complex datasets, exercising sound independent judgement and escalating where appropriate, particularly in areas where clear precedent may not exist.
• Developed problem-solving skills, including investigation of discrepancies, identification of trends and root cause analysis to support service improvement and data accuracy.
• Ability to manage priorities effectively and deliver agreed outputs within deadlines while seeking guidance on broader strategic decisions where required.

Personal Skills

Essential

• Highly developed written and verbal communication skills, with the ability to translate complex technical information into clear, accessible and actionable insight for non-technical audiences.
• Strong communication skills, both written and verbal – able to provide and receive complex, sensitive information and use persuasion, influencing and negotiation with individuals and groups, including shareholders.
• Good analytical and problem-solving skills – ability to analyse complex data and make judgements/draw conclusions – including ability to respond to unexpected demands.
• Able to advise colleagues within the Information, Finance and operational Teams and recommend approaches to reporting/processing / applying guidance.
• Ability to work independently and make autonomous decisions.
• Able to work flexibly to meet the demands of the role.

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 (Opens in a new tab).

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 (Opens in a new tab).

Closing Date: 23 March 2026