Junior Business Intelligence Developer

NHS; Tees Valley; On-site; GBP 31,000 - 38,000; Full time

Job summary

A regional NHS trust is seeking a Junior Business Intelligence Developer to support data analytics using IBM Cognos dashboards. The role involves maintaining reports, writing advanced SQL code, and ensuring compliance with reporting obligations. Ideal candidates will have a degree or equivalent experience in information analysis. This full-time position offers a salary between £31,049 to £37,796 per year, with a fixed-term contract of 18 months.

Qualifications

• Educated to degree standard or equivalent in a relevant subject.
• Experience of using and writing advanced SQL and other system development languages.
• Experience in creating dashboards and reports using Cognos or similar reporting tools.

Responsibilities

• Support and develop the IBM Cognos dashboards and SQL metrics.
• Assist in maintaining and creating the dashboards for performance metrics.
• Write complex SQL code to build metrics using the Trust data warehouse.

Skills

Advanced SQL

Cognos

Data analysis

Reporting tools

Problem solving

Numeracy skills

Education

Degree in relevant subject or equivalent experiential learning

Tools

Cognos

SQL

Job description

Job Summary

This post is only open to current employees of TEWV. Any applications received from non-TEWV employees will not be considered.

This is an exciting opportunity (fixed term - 18 months) for a self‑motivated individual to join the Business Intelligence Integrated Performance team within Digital and Data Services.

The Integrated Performance team supports clinical and business decision making using data analytics presented in meaningful and interactive ways. The team provides historical and current views of important Trust operations and compares them against local and national standards. The team helps to provide clarity to operation managers, influence best practice and policy and aid overall understanding of a wealth of Trust data.

Right to work in the UK is required. This role does not meet the eligibility criteria for sponsorship under the Skilled Worker visa, so the Trust cannot offer sponsorship for this role.

Main duties of the job

The Junior Business Intelligence Developer post holder will support and develop the IBM Cognos dashboards and SQL metrics used by the Performance department and managers throughout the Trust, ensuring the Trust’s information reporting obligations to the Department of Health, NHS Digital, NHS England and Commissioners are met.

About Us

We are the Mental Health & Learning Disability NHS Trust for County Durham and Darlington, Teesside, North Yorkshire, York and Selby.

From education and prevention, to crisis and specialist care – our talented and compassionate teams work in partnership with our patients, communities and partners to help the people of our region feel safe, understood, believed in and cared for.

We nurture the recovery journey of anyone in need of our help. In our Trust, everyone has a say in how they are supported and treated because we listen to every person in our care until they feel understood. Our patients, their families and carers work together with us towards better mental health.

We’re committed to new thinking that improves the wellbeing of our region. We connect with our communities and partners to get mental health care right, in areas that really need it.

Details

• Date posted: 16 October 2025
• Pay scheme: Agenda for change
• Band: 5
• Salary: £31,049 to £37,796 per year
• Contract: Fixed term (18 months)
• Working pattern: Full‑time
• Reference number: 346-CORP-084-25-A
• Job location: Flatts Lane Centre, Middlesbrough TS6 0SZ

Job Responsibilities

Working alongside the Integrated Performance team manager, the post holder will support in the maintenance and creation of the IBM Cognos dashboards used to view the Integrated Performance metrics across the Trust to measure performance against national and local standards. The post holder will assist in writing complex SQL code to build metrics using the Trust data warehouse, whose output will be viewed on the dashboards at all levels of the Trust.

Person Specification – Essential

• Educated to degree standard or equivalent in a relevant subject or with equivalent experiential learning in the field of information analysis and reporting.
• Experience of using and writing advanced SQL and other system development languages.
• Experience in creating dashboards and reports using Cognos or similar reporting tools.
• Knowledge of the development cycle including requirements gathering, design, build, test, release and sign‑off.
• Advanced computer literacy and keyboard skills and technical skills in one or more of the following areas: relational database skills, data modelling, systems programming languages, advanced SQL, Cognos or similar, end‑user interface design (UDFs).
• Good numeracy skills.
• Ability to work under pressure to meet deadlines.
• Ability to concentrate and focus on detailed information.

Person Specification – Desirable

• Working in an NHS environment.
• Experience of working with large data.
• Knowledge of the IBM Cognos product suite and how the various layers integrate.

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exemptions Order) 1975 and requires a Disclosure and Barring Service (formerly CRB) check for any previous criminal convictions.

Certificate of Sponsorship

Applications from job seekers who require visas will be considered alongside all other applications. For further information, visit the UK Visas and Immigration website.

Employer details

• Employer name: Tees Esk and Wear Valleys NHS Foundation Trust
• Address: Flatts Lane Centre, Middlesbrough, TS6 0SZ
• Website: https://www.tewv.nhs.uk/