Clinical Information Report Developer

South Western Ambulance Service NHS Foundation Trust; Exeter; On-site; GBP 80,000 - 100,000; Full time

Job summary

A regional ambulance service in the UK is seeking a Clinical Information Reporting Specialist to develop and maintain clinical reporting solutions using Power BI. The ideal candidate should have a degree in IT, extensive experience with Power BI, and advanced SQL Server skills. Responsibilities include managing clinical data flow and supporting reporting tools. This role offers a standard working week with various employee benefits and opportunities for professional development.

Benefits

27 days holiday plus public holidays

Pay enhancements for shifts and overtime

Car leasing scheme

Free parking across Trust sites

Cycle-to-work scheme

Access to discounts

Qualifications

• Qualified to degree level in an IT related subject or extensive experience in the field.
• Previous experience and extensive knowledge of using Power BI.
• Advanced knowledge of Microsoft SQL Server 2008 R2 and later including TSQL.
• Experience of working with clinical information.
• Extensive knowledge of Microsoft Office products, particularly Excel.

Responsibilities

• Manage the flow of clinical data from patient to end user.
• Support Electronic Care System release processes.
• Administer the clinical database.
• Support the Trust's information needs through reporting tools.

Skills

Power BI

TSQL

Clinical information management

Excel

Education

Degree in IT or extensive experience

Tools

Microsoft SQL Server 2008 R2

Job description

Overview

Go back South Western Ambulance Service NHS Foundation Trust

The closing date is 04 February 2026

Reporting to the ECS Senior BI Developer, and being responsible for the maintenance and development of clinical information reporting solutions, including:

• Develop reports using Power BI
• Supporting the ePCR database
• The data flow into the database
• SQL Server Reporting Services reports
• Ad hoc reports using various tools
• Maintenance of local reporting tools
• Configuration using the Supplier Admin Tool
• System access and permissions using the Supplier Admin Tool

This post requires specialist technical knowledge and experience to support and maintain the development of clinical reports and reporting systems, which meet the requirements of the organisation.

Representation of the team, the department, directorate and the Trust at internal and external meetings, ensuring that strategic projects and processes are conducted with due consideration to clinical data, research and audit, and ensuring that strategic decisions with a bearing on the department are communicated appropriately.

Provide feedback to Medical Directorate Managers, other Senior Managers and Directors, identifying issues which affect the use and performance of the Business Intelligence system.

Main duties of the job

To work closely with the Clinical Information & Records and Research and Audit Teams to manage the flow of clinical data from the patient to the end user, and support the local and national reporting requirements of the Trust. This will include:

• Using clinical data, clinical information systems and expert analysis and interpretation to support problem solving and evidence-based decision making.
• Working with the Senior ECS BI Developer to support Electronic Care System release processes by running appropriate tests for software and configuration releases, and feeding back issues found to internal groups and system suppliers
• Supporting the SQL Server Integration Services package that imports data from the clinical system to the Trust's data warehouse
• Administering the clinical database
• Support the Trust's information needs through the development of reporting tools
• Maintain a good level of risk and governance knowledge and apply this throughout the scope and development of reports / use of data

About us

Working for us is an experience like no other. We provide emergency and urgent care, 24 hours a day, 365 days a year, operating across the largest ambulance region in England of 10,000 square miles and responding to an average of 2,650 incidents every day.

We remain committed to ensuring that we provide the best possible care for all our patients, which is reflected in our new five-year strategy which has continually improving patient care at its very core.

At the heart of our beautiful and diverse region we employ over 6000 people and are supported by over 575 volunteers.

If you embody our values of one team, compassionate and innovative and are looking to make a real difference to peoples' lives, then we would love to hear from you.

In return we will equip you with the skills, resources and development you need to thrive in your role.

You will have opportunities to progress to roles at a higher pay grade and enjoy continuous professional development.

• A standard working week of 37.5 hours
• Holiday entitlements of 27 days per year, plus general and public holidays, rising to 29 days after 5 years and 33 days after 10 years
• Pay enhancements for out of hours, shift and overtime working
• Career and salary progression
• Car leasing scheme
• Free parking across Trust sites
• Cycle-to-work and other salary sacrifice schemes
• Staff networks
• Access to a wide range of discounts from various organisations across the UK

Job responsibilities

The Clinical Information and Records Team are responsible for the management of clinical information, clinical systems development and clinical reporting throughout SWASFT.

We are a small, but busy group of information professionals who are responsible for all clinical system development and reporting within the South Western Ambulance Service.

For further information about this role, please see the attached Job Description and Person Specification.

Person Specification

Education and qualification

• Qualified to degree level in an IT related subject or extensive experience in the field.
• Previous experience and extensive knowledge of using PowerBI
• Advanced knowledge of Microsoft SQL Server 2008 R2 and later including TSQL, Stored Procedures and functions with a significant
• Experience of working with clinical information
• Extensive knowledge of Microsoft Office products, particularly Excel.

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.

South Western Ambulance Service NHS Foundation Trust