Skip to main content
Please wait, loading

Job summary

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

Employer heading

South Western Ambulance Service NHS Foundation Trust logo

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

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.

Benefits

  • Competitive NHS salary
  • 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
  • Generous Pension Scheme
  • 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.

Person specification

Education and Qualifications

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

Previous Experience

Essential criteria
  • 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 criteria
  • 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

Apprenticeships logoNo smoking policyAge positiveInvestors in People: GoldImproving working livesMindful employer.  Being positive about mental health.Armed Forces Covenant

Documents to download

Apply online now

Further details / informal visits contact

Name
Kristian Hughes
Job title
ePCR Senior Business Intelligence Developer
Email address
[email protected]
Telephone number
01392 261697
Apply online nowAlert me to similar vacancies