ePCR Senior Business Intelligence Developer

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

Benefits offered by this job

Car lease scheme

Free parking

Staff networks

Discounts

Job summary

South Western Ambulance Service NHS Foundation Trust in Exeter is seeking an experienced ePCR Senior Business Intelligence Developer to support the preparation for and introduction of a new Electronic Patient Clinical Record.

You will design data flows, integrate legacy data with the new EPCR, run tests, and maintain SQL databases and Power BI reports to meet organisational needs.

Qualifications

• Degree in IT or equivalent experience.
• Advanced knowledge of Microsoft SQL Server 2019+ and T-SQL.
• Experience designing and developing SQL reports.
• Experience with end-to-end Power BI reporting.
• Experience in data engineering and warehousing.
• Familiarity with change control processes.

Responsibilities

• Work with the Clinical Information and Records Team to support EPCR data pipelines.
• Integrate legacy and new EPCR data.
• Support transition from legacy system to the new EPCR (data management, reporting).
• Create and run tests for data flows and reports.
• Maintain Clinical Databases & data flows.
• Peer review and support of BI deliverables.
• System UAT support and testing.
• Other project and BAU tasks as required.

Skills

SQL Server 2019+

Power BI reports

Data engineering

Data warehousing

Programming language

Change control processes

Data testing

ETL knowledge

Education

Bachelor's degree in IT or related field

Tools

SQL Server Management Studio

Power BI Desktop

Job description

Main area IT Grade NHS AfC: Band 7 Contract 18 months (Fixed Term) Hours Full time - 37.5 hours per week (Office day Thursday (Exeter), M-F week. Initially 2-3 days in the office for training and induction) Job ref 202-8244307

Employer South Western Ambulance Service NHS Foundation Trust Employer type NHS Site Exeter HQ Town Exeter Salary £49,387 - £56,515 / per annum (indicative) Salary period Yearly Closing 14/09/2026 23:59 Interview date 15/09/2026

ePCR Senior Business Intelligence Developer

NHS AfC: Band 7

Job overview

We are seeking an experienced ePCR Senior Business Intelligence Developer to support the preparation for and introduction of a new Electronic Patient Clinical Record (ePCR).

This will involve:

• Preparing and the ePCR databases
• Supporting the data flow into the databases
• Integrating legacy and new data
• Peer support and review

This post requires specialist technical knowledge and experience to implement, support and maintain the ePCR databases and reporting to meet the needs of the organisation.

Main duties of the job

To work closely with the Clinical Information and Records Team, the new EPCR Project Working Group and the Data, Analytics and Insight Team to support the development and maintenance of data flows and pipelines, integrate the legacy and new data and ensure the effective flow of clinical data.

Responsibilities include:

Working with the Clinical Information and Records Team to introduce the new EPCR data and data pipelines

Integrate existing / legacy data with the new EPCR data

Support the transition from the legacy system to the new, including all tasks relating to clinical information management (legacy reporting / new reporting etc.)

Creating and running appropriate tests

Maintenance of Clinical Databases & data flows

Peer review and support

System UAT support, including system integration testing

Other project and BAU tasks, as required

Working for our organisation

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 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.

The role is based in Exeter, one of the most vibrant, attractive and historically interesting cities in England, with excellent transport links and a great mix of independent shops, cafes and bars.

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 and resources you need to thrive in your role.

You will have opportunities to progress to roles across the Trust 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
• Staff networks
• Wide range of discounts from various organisations across the UK

Detailed job description and main responsibilities

For further information about this role please see the attached job description and person specification.

Please note: We reserve the right to close this vacancy before the advertised closing date if a sufficient number of applications are received. Early application is therefore encouraged.

Person specification

Education and Qualifications

• Qualified to degree level in an IT related subject or extensive experience in the field
• Full UK Driving License

Previous Experience

• Advanced knowledge of Microsoft SQL Server 2019 and later including TSQL, Stored Procedures and functions with a significant experience designing and developing SQL reports
• Experience developing end to end PowerBI reports (or similar)
• Experience of testing (data flows, reporting etc.)
• Proven experience of Data Engineering and warehousing
• Working knowledge of at least one programming language
• Proven experience of managing change in information systems
• Proven knowledge and experience of configuring a system to a user’s specification via a Change Control Process

Employer certification / accreditation badges

Name Kristian Hughes Job title ePCR Senior Business Intelligence Developer Email address [emailprotected] Telephone number 01392 261697