ePCR Senior Business Intelligence Developer
Job summary
We are seeking an experienced ePCR Senior Business Intelligence Developer to support the maintenance and development of the electronic Patient Clinical Records systems (ePCR) Reporting, including:
The ePCR databases
The data flow into the databases
Websites using the databases
SQL Server Reporting Services reports
PowerBI reports
Ad hoc reports using various tools
Configuration & system access and permissions using the Supplier Admin Tool
This post requires specialist technical knowledge and experience to support and maintain the development of the ePCR system that meet the requirements of the organisation.
Main duties of the job
To collaborate closely with the Clinical Information & Records teams, as well as the Research and Audit teams, to ensure the effective flow of clinical data from the patient to the end user, while supporting both local and national reporting requirements of the Trust.
Responsibilities include:
Leading on the technical aspect of the electronic Patient Record systems, including writing changes to its configuration, in liaison with clinical users, the system developers and other stakeholders
Creating and running appropriate tests for software and configuration releases, and feeding back issues found to the system suppliers
Configuring the care record system to ensure correct access control, and maintaining effective system functionality.
Writing and maintaining the SQL Server, ETL Scripts (PowerShell) that imports data from the clinical system to the Trust's data warehouse
Administering the Clinical Reporting databases
Support the Trust's information needs through the development of web based reporting tool,
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
- Qualified to degree level in an IT related subject or extensive experience in the field
Previous Experience
- Advanced knowledge of Microsoft SQL Server 2008 R2 and later including TSQL, Stored Procedures and functions with a significant experience designing and developing SQL reports
- Proven SQL database administration experience
- Proven data engineering integration experience (ETL/ELT/OLAP)
- Knowledge of computer programming techniques
- Experience developing end to end PowerBI reports (or similar)
- Knowledge/Experience of working with Electronic Clinical Systems
- 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
- Understanding NHS/Clinical settings
- Working knowledge of web based technologies
- Information Systems Testing
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