Information Analyst – Data Warehouse and Analytics: Sponsorship Available

Wye Valley NHS Trust

Job Summary

The purpose of this job is to support with, and to maintain the Information Department’s information and business intelligence Data Warehouse, to enable production of key dataset outputs for reporting internally and externally.

This involves the development, support and management of any reporting requirements and the update of these processes. This role will also act as deputy for the System Managers in their absence.

This role is key in working with the System Managers in the development of systems required to enable the Information Department to meet its statutory reporting requirements.

Responsibility to support any interfaces and downloads between systems within the Trust to enable data sharing.

This role supplies specialist support and technical expertise to the System Managers and to the rest of the Information Team and all other departments within Wye Valley Trust on the ongoing planning and development of their reporting requirements from their current/new systems.

There will be a requirement to work two days on site.

 

Main duties of the job

Assisting the System Managers in the design, development, testing, documentation and support of interfaces between Wye Valley systems to improve reporting within the Trust.

Setting up automated reports required by Information Analysts and other external stakeholders for their regular and ad-hoc reporting. To identify where work processes can be rationalized and automated and to assist in the setting up of new reports/queries when required.

Support the System Managers in the development, management, and availability of Servers to ensure that trust wide business critical Information reporting requirements are met. These include Power BI reporting, and other SQL server databases.

To work with individual users to enable them to produce both ad hoc and regular reports via SQL server, SSRS, Power BI, and other tools and to enable them to solve their requirements for data analysis.

Where appropriate, support existing and any new systems that exist within the Trust.

Effectively communicate on detailed Information reporting issues with Trust staff at different levels of the organisation

To undertake any other duties as may be assigned to the post holder that are commensurate with the grading and responsibilities/competencies of the post holder.

Person Specification

Experience

Essential

  • Information Management
  • SQL Server 2019 onwards
  • Systems development skills, preferably using Microsoft technologies
  • SSRS Reporting

Desirable

  • Power BI/Excel/VBA Programming

Knowledge

Essential

  • SQL Server Integration Services, Reporting Services, Database programming/querying

Desirable

  • SQL Server Analysis Services

Education or Qualifications

Essential

  • First level degree in an Information Management / IT related degree or equivalent experience

Desirable

  • Management Qualifictions

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

Closing Date: 21 June 2026

To apply for this job please visit apps.trac.jobs.