South Western Ambulance Service NHS Foundation Trust

Clinical Information Report Developer

This job is now closed

Job summary

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

o Develop reports using Power BI

o Supporting the ePCR database

o The data flow into the database

o SQL Server Reporting Services reports

o Ad hoc reports using various tools

o Maintenance of local reporting tools

o Configuration using the Supplier Admin Tool

o System access and permissions using the Supplier Admin Tool

This post requires specialist technical knowledge and experience to support and maintain the development of clinical reports and reporting systems, which meet the requirements of the organisation.

Representation of the team, the department, directorate and the Trust at internal and external meetings, ensuring that strategic projects and processes are conducted with due consideration to clinical data, research and audit, and ensuring that strategic decisions with a bearing on the department are communicated appropriately.

Provide feedback to Medical Directorate Managers, other Senior Managers and Directors, identifying issues which affect the use and performance of the Business Intelligence system.

Main duties of the job

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

The Clinical Information and Records Team are responsible for the management of clinical information, clinical systems development and clinical reporting throughout SWASFT.

We are a small, but busy group of information professionals who are responsible for all clinical system development and reporting within the South Western Ambulance Service.

We believe good quality data and effective systems are important for delivering excellent patient care.

Date posted

10 June 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year per annum

Contract

Fixed term

Duration

12 months

Working pattern

Full-time

Reference number

202-6341516

Job locations

Trust HQ

Abby Court

Exeter

EX2 7HY

Job description

Job responsibilities

For further information about this role, please see the attached Job Description and Person Specification

Job description

Job responsibilities

For further information about this role, please see the attached Job Description and Person Specification

Person Specification

Education and qualification

Essential

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

Desirable

Proven knowledge and experience of Microsoft SQL Server Reporting Services and Integration Services.
Experience of working with clinical information
Extensive knowledge of Microsoft Office products, particularly Excel.

Person Specification

Education and qualification

Essential

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

Desirable

Proven knowledge and experience of Microsoft SQL Server Reporting Services and Integration Services.
Experience of working with clinical information
Extensive knowledge of Microsoft Office products, particularly Excel.

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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Additional information

Disclosure and Barring Service Check

Certificate of Sponsorship

Employer details

Employer name

South Western Ambulance Service NHS Foundation Trust

Address

Trust HQ

Abby Court

Exeter

EX2 7HY

Employer's website

https://www.swast.nhs.uk (Opens in a new tab)

Employer details

Employer name

South Western Ambulance Service NHS Foundation Trust

Address

Trust HQ

Abby Court

Exeter

EX2 7HY

Employer's website

https://www.swast.nhs.uk (Opens in a new tab)