Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support and develop IBM Cognos dashboards and SQL metrics for performance reporting.
- Company: Tees Esk and Wear Valleys NHS Foundation Trust, dedicated to mental health and learning disability care.
- Benefits: Fixed-term contract with opportunities for professional growth in a supportive environment.
- Why this job: Make a real difference in healthcare by using data to improve patient outcomes.
- Qualifications: Degree or equivalent experience in information analysis; advanced SQL skills required.
- Other info: Join a compassionate team committed to enhancing mental health services in the community.
The predicted salary is between 30000 - 42000 £ per year.
Go back Tees Esk and Wear Valleys NHS Foundation Trust
Junior Business Intelligence Developer
The closing date is 30 October 2025
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 Developerpost 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.
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.
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 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
- Educated to Degree standard or equivalent in a relevant subject or with equivalent experiential learning in the field of information analysis and reporting.
Knowledge
- 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.
- 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
- Advanced computer literacy and keyboard skills and technical skills in one or more of the following areas: o Relational database skills and expertise o Data Modelling o Systems programming languages o Advanced SQL o Cognos or similar o End user interface design (UDFs)
- Ability to work under pressure to meet deadlines
- Ability to concentrate and focus on detailed information
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.
Tees Esk and Wear Valleys NHS Foundation Trust
#J-18808-Ljbffr
Junior Business Intelligence Developer employer: Tewv Brits
Contact Detail:
Tewv Brits Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Junior Business Intelligence Developer
✨Tip Number 1
Network like a pro! Reach out to current employees at TEWV on LinkedIn or through mutual connections. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Prepare for the interview by brushing up on your SQL skills and understanding IBM Cognos. We want to see you shine, so practice explaining your past projects and how they relate to the role.
✨Tip Number 3
Show your passion for data analytics! During interviews, share examples of how you've used data to influence decisions or improve processes. It’s all about demonstrating your value to the team.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining our awesome team.
We think you need these skills to ace Junior Business Intelligence Developer
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter for the Junior Business Intelligence Developer role. Highlight your experience with SQL and dashboard creation, as well as any relevant projects that showcase your skills in data analytics.
Showcase Your Skills: Don’t just list your qualifications; demonstrate how your skills align with the job requirements. If you've worked with IBM Cognos or similar tools, share specific examples of how you used them to solve problems or improve processes.
Be Clear and Concise: Keep your application straightforward and to the point. Use bullet points where possible to make it easy for us to see your key achievements and experiences. Remember, clarity is key when dealing with complex data!
Apply Through Our Website: We encourage you to submit your application through our official website. This ensures that your application goes directly to us and helps streamline the process. Plus, it’s super easy to do!
How to prepare for a job interview at Tewv Brits
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries you've written and how they impacted your previous projects. This role requires advanced SQL knowledge, so showcasing your expertise will definitely impress.
✨Familiarise Yourself with IBM Cognos
Since you'll be working with IBM Cognos dashboards, it’s crucial to understand how they function. If possible, create a sample dashboard or two to demonstrate your skills. Being able to talk about your experience with Cognos will show that you're ready to hit the ground running.
✨Understand the Trust's Mission
Take some time to research Tees Esk and Wear Valleys NHS Foundation Trust and its commitment to mental health. Understanding their values and how the Integrated Performance team contributes to patient care will help you align your answers with their mission during the interview.
✨Prepare for Scenario-Based Questions
Expect questions that assess how you handle real-world challenges, especially in data analysis and reporting. Think of examples from your past experiences where you successfully gathered requirements, designed solutions, or met tight deadlines. This will demonstrate your problem-solving skills and ability to work under pressure.