About this role
Job summary
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
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 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 strategywhich 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
Job description Job responsibilities
For further information about this role please see the attached job description and person specification.
Person Specification
Education and Qualifications Essential
Qualified to degree level in an IT related subject or extensive experience in the field Full UK Driving License
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
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.
Employer details Employer name South Western Ambulance Service NHS Foundation Trust
Address Exeter HQ
Exeter
EX2 7HY
United Kingdom
Employer's website https://www.swast.nhs.uk (Opens in a new tab)