Clinical Information Report Developer

Job Summary

Reporting to the ECS Senior BI Developer, and being responsible for the maintenance and development of clinical information reporting solutions, including:

• Develop reports using Power BI
• Supporting the ePCR database
• The data flow into the database
• SQL Server Reporting Services reports
• Ad hoc reports using various tools
• Maintenance of local reporting tools
• Configuration using the Supplier Admin Tool
• System access and permissions using the Supplier Admin Tool

Main Duties

To work closely with the Clinical Information & Records and Research and Audit Teams to manage the flow of clinical data from the patient to the end user, and support the local and national reporting requirements of the Trust. This will include:

• Using clinical data, clinical information systems and expert analysis and interpretation to support problem solving and evidence-based decision making.
• Working with the Senior ECS BI Developer to support Electronic Care System release processes by running appropriate tests for software and configuration releases, and feeding back issues found to internal groups and system suppliers
• Supporting the SQL Server Integration Services package that imports data from the clinical system to the Trust's data warehouse
• Administering the clinical database
• Support the Trust's information needs through the development of reporting tools
• Maintain a good level of risk and governance knowledge and apply this throughout the scope and development of reports / use of data

About Us

Working for [Employer hidden — sign up to reveal] 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 of 10,000 square miles and responding to an average of 2,650 incidents every day.

At the heart of our beautiful and diverse region we employ over 6000 people and are supported by over 575 volunteers.

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

Person Specification

Essential

• Qualified to degree level in an IT related subject or extensive experience in the field.
• Previous experience and extensive knowledge of using PowerBI
• Advanced knowledge of Microsoft SQL Server 2008 R2 and later including TSQL, Stored Procedures and functions with a significant

Desirable

• Experience of working with clinical information
• Extensive knowledge of Microsoft Office products, particularly Excel.

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
• Cycle-to-work and other salary sacrifice schemes
• Staff networks
• Access to a wide range of discounts from various organisations across the UK

Visa Sponsorship

This role does not meet the criteria for Skilled Worker visa sponsorship under current Home Office regulations. You must have the existing right to work in the UK to be considered for this position.

Employer Details

Employer: [Employer hidden — sign up to reveal]

Address: Trust HQ, Abby Court, Exeter, EX2 7HY

Website: https://www.swast.nhs.uk

Contact: Tim Boyce - [contact hidden]