Information Analyst - Data Warehouse and Analytics

Job summary

Please note, we reserve the right to close this vacancy early once sufficient applications are received.

The purpose of this job is to supportwith, 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

About us

About us

Wye Valley NHS Trust is a member of an NHS Foundation Group with South Warwickshire University NHS FT, George Eliot Hospital NHS Trust and Worcestershire Acute NHS Hospitals Trust.

Located on the border with Wales in the shadow of the Black Mountains, we provide acute and community services across Herefordshire and into parts of Powys and run Hereford County Hospital and the community hospitals in Bromyard, Leominster and Ross-on-Wye.

We are a progressive and forward looking trust with ambitious plans to improve quality and integrate patient pathways through close collaborative working with our partners to deliver the quality of care wed want for our family and friends.

More than 3,000 people work for the Trust they tell us its a great place to work, blending the busyness of a DGH with the benefits of working in a beautiful rural and unspoilt county like Herefordshire.

We can offer a great work-life balance and have a fine tradition of working with staff to help them achieve their full potential.

Russell Hardy, Trust Chairman: "The strength of the Trust is its amazing staff; a great place to work, a great place to develop your career and a great place to reach your potential."

Our values -Care, Accountability, Respect and Excellence - are at the heart of all we do. We believe in providing the right care in the right place at the right time.

Job description

Job responsibilities

To view role requirements and role responsibilities in full, please view the Job description and person specification attached to this vacancy in the supporting documents.



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.

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.

Employer details

Employer name

Wye Valley NHS Trust

Address

The Old Records Office

Harold Street

Hereford

HR1 2QX

United Kingdom

Employer's website

https://www.wyevalley.nhs.uk/



Job Details

Company
Wye Valley NHS Trust
Location
Hereford, HR1 2QX, United Kingdom
Salary
£32073.00 to £39043.00
Posted