Skip to main content

This site is independent of the NHS and the Department of Health.

Please wait, loading

Job summary

Main area
Digital and Data Services
Grade
Band 5
Contract
18 months (Fixed term)
Hours
Full time - 37.5 hours per week
Job ref
346-CORP-084-25-A
Employer
Tees, Esk and Wear Valleys NHS Trust
Employer type
NHS
Site
Flatts Lane Centre
Town
Middlesbrough
Salary
£31,049 - £37,796 per annum
Salary period
Yearly
Closing
30/10/2025 23:59

Employer heading

Tees, Esk and Wear Valleys NHS Trust logo

Junior Business Intelligence Developer

Band 5

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.

We won’t rest until everyone in our region has the mental health care they need, to lead their best possible life.

Job overview

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 support clinical and business decision making using data analytics presented in meaningful and interactive ways. The team provide historical and current views of important Trust operations and against Local and National standards. The team help to provide clarity to operation managers, influence best practice and policy and aid overall understanding of a wealth of Trust data.

You must have the Right to Work in the UK in order to be successfully appointed to this role. Please note, this role does not meet the required eligibility criteria for sponsorship under the Skilled Worker visa and therefore the Trust is unable to offer sponsorship for this particular role.

Main duties of the job

The Junior Business Intelligence Developer post holder will work to 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.  

 

Working for our organisation

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.

Detailed job description and main 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 used across the Trust to measure performance against National and Local standards.  The post holder will assist in the writing of complex SQL code to build metrics using the Trust data warehouse, the output of which will be viewed on the dashboards at all levels of the Trust.

Please refer to the attached job description and person specification for further detailed information to ensure that you meet the role criteria before applying.

Person specification

Qualifications

Essential criteria
  • Educated to Degree standard or equivalent in a relevant subject or with equivalent experiential learning in the field of information analysis and reporting.

Knowledge

Essential criteria
  • 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.
Desirable criteria
  • Working in an NHS environment.
  • Experience of working with large data.
  • Knowledge of the IBM Cognos product suite and how the various layers integrate.

Skills

Essential criteria
  • Advanced computer literacy and keyboard skills and technical skills in one or more of the following areas: • Relational database skills and expertise • 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

Employer certification / accreditation badges

We are a Living Wage EmployerVeteran AwareApprenticeships logoNo smoking policyPositive about disabled peopleAge positiveImproving working livesArmed Forces Covenant (Silver Award)Mindful employer.  Being positive about mental health.Disability confident employerStep into healthArmed Forces CovenantBetter Health at Work Gold Award

Documents to download

Apply online now

Further details / informal visits contact

Name
Roy Stewart
Job title
BI Integrated Performance Manager
Email address
[email protected]
Apply online nowAlert me to similar vacancies