Leeds and York Partnership NHS Foundation Trust

Business Intelligence Officer

This job is now closed

Job summary

The role will focus on the development of the Trust's Data Warehouse and interoperability. The post holder will require and develop a number of skills including T-SQL, C#, HTML, FHIR and SQL Server Administration

Main duties of the job

Assist in the development of the Trusts Data Warehouse, bespoke developments and integrations with other systems both internal and external.

About us

The Leeds and York Partnership NHS Foundation Trust (LYPFT) is the main provider of Mental Health and Learning Disability services in Leeds. We also provide specialist inpatient services in York and some highly specialised services across the country. As a teaching trust with strong links to local universities, we are a centre of excellence for teaching,research and development.

There are many benefits of working for LYPFT including fantastic employee wellbeing support, 27 - 33 days annual leave, flexible working and remote working arrangements, the NHS Pension Scheme (LYPFT pays 20.6% into your scheme each year), coaching, support and opportunities for career development and training and education support alongside a range of exclusive discounts and payment schemes including for cars, extra leave days and more organisations such as Blue Light Card, Health Service Discounts and NHS Discount Offers.

We also have an incredible bank department, offering variety of roles in nursing, allied health professions, healthcare support worker and administration clerical. Permanent employees are automatically added to bank. Bank-only workers can choose the hours they want to work and will have the opportunity to gain additional experience, keep skills up to date, develop new ones and earn extra money without having to commit to a permanent role. For an informal discussion or more information please contact the team bankstaffingdepartment.lypft@nhs.net

Date posted

06 July 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£28,407 to £34,581 a year Per Annum

Contract

Permanent

Working pattern

Full-time

Reference number

173-51823-COR

Job locations

St Mary’s House

Leeds

LS12 3QE

Job description

Job responsibilities

The post holder will be responsible for aiding in the development of the Trusts data warehouse. This will involve combining data in from a wide variety of sources in a format that can be used to report performance internally and externally. There will also be scope to develop internal systems and integrations between systems.

Job description

Job responsibilities

Person Specification

Qualifications

Essential

Degree level education or equivalent relevant working experience.

Experience

Essential

Experience of developments using SQL Server
Experience of using T-SQL

Person Specification

Qualifications

Essential

Degree level education or equivalent relevant working experience.

Experience

Essential

Experience of developments using SQL Server
Experience of using T-SQL

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.

Employer details

Employer name

Leeds and York Partnership NHS Foundation Trust

Address

St Mary’s House

Leeds

LS12 3QE

Employer's website

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

Employer details

Employer name

Leeds and York Partnership NHS Foundation Trust

Address

St Mary’s House

Leeds

LS12 3QE

Employer's website

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