# ePCR Senior Business Intelligence Developer

> NHS job listing from Job Clerk for South Western Ambulance Service NHS Foundation Trust.

## Canonical URLs

- **HTML:** https://www.jobclerk.com/job/epcr-senior-business-intelligence-developer/81a04988-2f4a-446c-9a85-828a908c6459
- **Markdown:** https://www.jobclerk.com/job/epcr-senior-business-intelligence-developer/81a04988-2f4a-446c-9a85-828a908c6459.md

## Summary

- **Status:** Live
- **Employer:** South Western Ambulance Service NHS Foundation Trust
- **Location:** Trust HQ
- **Workplace type:** onsite
- **Profession:** Developer
- **Grade:** Band 7
- **Salary:** £49,387 - £56,515 / per annum (indicative)
- **Contract type:** 18 months (Fixed Term)
- **Employment type:** 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)
- **Closing date:** 2026-09-14T22:59:00.000Z
- **Posted:** 2026-09-01T07:42:09.739Z
- **Source information URL:** https://www.healthjobsuk.com/job/UK/Devon/Exeter/South_Western_Ambulance_Service_NHS_Foundation_Trust/IT/IT-v8244307
- **Application URL:** https://apps.trac.jobs/job-advert/8244307?ShowJobAdvert=&feedid=9002
- **Employer website:** https://www.swast.nhs.uk

## Job Content

### 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
- Report development
- 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

Stakeholder engagement

Report development (inc. Power BI)

System UAT support, including system integration testing

Other project and BAU tasks, as required

### Detailed job description and main responsibilities

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

## Person Specification

### Previous Experience

**Essential**

- Advanced knowledge of Microsoft SQL Server 2019 and later including TSQL, Stored Procedures and functions with a significant experience designing and developing SQL reports
- Proven data engineering integration experience (ETL/ELT/OLAP)
- Experience developing end to end PowerBI reports (or similar)
- Experience of testing (data flows, reporting etc.)
- Relevant system development experience
- Proven SQL database administration experience
- Proven experience of Data Engineering and warehousing
- Working knowledge of at least one programming language

**Desirable**

- 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

### Education and Qualifications

**Essential**

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

## Documents

- [swast code of conduct (pdf, 1.3mb)](https://www.healthjobsuk.com/documents?edoc=2579)
- [epcr senior business intelligence developer (pdf, 328.6kb)](https://www.healthjobsuk.com/documents?vdoc=10555623)

## Agent Notes

- This Markdown page is generated from the same Job Clerk job record as the HTML job detail page.
- Use the canonical HTML URL for user-facing references.
- Use the application URL when the user wants to apply on the source NHS site.