Clinical Information Report Developer

South Western Ambulance Service NHS Foundation Trust

Information:

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

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 of 10,000 square miles 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.

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.

In return we will equip you with the skills, resources and development you need to thrive in your role.

You will have opportunities to progress to roles at a higher pay grade 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
  • Cycle-to-work and other salary sacrifice schemes
  • Staff networks
  • Access to a wide range of discounts from various organisations across the UK

Date posted

30 July 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-A

Job locations

Trust HQ

Abby Court

Exeter

EX2 7HY


Job description

Job responsibilities

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.

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

Job description

Job responsibilities

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.

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

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

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

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

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)

For questions about the job, contact:

Senior ECS BI Developer

Kristian Hughes

kristian.hughes@swast.nhs.uk

Date posted

30 July 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-A

Job locations

Trust HQ

Abby Court

Exeter

EX2 7HY


Supporting documents

Privacy notice

South Western Ambulance Service NHS Foundation Trust's privacy notice (opens in a new tab)