Job summary
- Main area
- Business Intelligence
- Grade
- NHS AfC: Band 6
- Contract
- Permanent
- Hours
- Full time
- Flexible working
- Job ref
- 346-CORP-031-25
- Employer
- Tees, Esk and Wear Valleys NHS Trust
- Employer type
- NHS
- Site
- Flatts Lane Centre
- Town
- Normanby
- Salary
- £37,338 - £44,962 per annum
- Salary period
- Yearly
- Closing
- 03/04/2025 23:59
- Interview date
- 14/04/2025
Employer heading

Senior Business Intelligence Developer
NHS AfC: Band 6
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
An exciting opportunity has arisen to recruit a Senior Business Intelligence Developer to work on a full-time basis as part of the Integrated Information Centre (IIC) team. The post is based at Flatts Lane Centre, Normanby, however, the Trust endorses a flexible working model that fully facilitates a blended approach to remote and on-site working.
This post will work as part of the Trust’s Business Intelligence (BI) team (referred to as the IIC Team) and will be responsible for the design, development, documentation and testing of bespoke dashboards and reports that will be used to support and improve both patient care and management decision making across the Trust
This will involve working closely with other BI Developers and ETL/Data Warehouse developers within the IIC Team, staff within the wider Business Intelligence & Reporting section and customers, to support the Trust’s Business Intelligence, information and Digital & Data agenda.
The team are in the process of evolving the IIC to further support the Trusts Digital and Data Journey to Change. The IIC is in the late stages of migration to the IBM Cloud and the successful applicant will be ideally placed to develop their skills using IBM Cloud Pak for Data and all the exciting and innovative technology that it entails including AI and machine learning.
Main duties of the job
The successful candidate will have a background in Business Intelligence report and dashboard development (ideally with IBM’s Cognos Analytics and related InfoSphere products), with demonstratable, practical skills in relation to Business Intelligence software and associated technologies.
Candidates with strong skills in alternative products such as Power BI, SSRS, QlikView, Crystal Reports, Tableau or other products will also be considered.
The candidate must have an appetite to identify improvements to their own work maximising the use of technology and aiming to automate reporting where possible.
Good communication, customer management skills and staff supervision experience are essential.
The candidate will be responsible for gathering requirements using techniques such as interviews, document analysis, workshops, surveys, use cases, business, and workflow analysis.
They will support the evaluation and development of products and procedures, by analysing existing systems, and performing gap analysis. Support developers and testers by creating professionally written acceptance criteria.
The candidate will be able to analyse business/functional needs and requirements and maintain contact with the customer throughout the development lifecycle and sign-off process.
The candidate will also be able to take on the role of Scrum master during the team sprint cycles and facilitate the team’s agile ceremonies.
Working for our organisation
The Business Intelligence (IIC) team is part of the Business Intelligence & Clinical Outcomes Section of the Digital & Data Services Department working towards the Trusts Digital & Data Journey to Change.
The Digital & Data Services Department is an award-winning, dynamic, and fast-paced environment consisting of over 140 multi-disciplined and talented staff across well structured, supportive, and friendly teams. This leads to many rewarding opportunities for development, self-growth and promotion which is demonstrated by low staff turnover and the significant amount of home-grown talent.
We cover a wide range of specialisms, from Business Intelligence to the provision of IT equipment and everything in-between. No matter where your passion lies, join our brightest minds in supporting our staff deliver the best care for our service users and carers.
You’ll join a team where flexibility, wellbeing and respect are highly valued, and you’ll be supported to be the best version of you!
Detailed job description and main responsibilities
Please see the attached standard job description for more details relating to the main responsibilities and essential criteria. If you would like to discuss the role further, please contact us.
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.
The responsibilities will include:
• To actively lead, contribute and engage with the IIC Team Agile sprint process including sprint planning, estimation of efforts, daily team huddles, sprint reviews, sprint retrospectives, technical and process developments to support the delivery of an effective service to our customers.
• To support with the review of internal IIC team processes to progress and embed innovative solutions to improve these
• To support the development lifecycle of the Trust’s dashboards, reports and alerts, working with customers, developers and end users to plan, develop and deploy products and features to meet user requirements.
• To gather, define and document user requirements that are clear, concise and testable; to translate those requirements to a plan of work that can be understood and implemented by the development team; to ensure the development meets the objectives and needs of the customer.
• To promote and champion the use and functionality of the IIC within the organisation
• To develop and maintain the Trust’s dashboards, reports and alerts that reside within the IIC portal, supporting the Trust’s Business Intelligence and Information agenda.
• To gather and define user requirements relating to developments to understand the objectives and needs of the customer and translate this to a plan of work.
• To actively contribute and engage with the IIC Team Agile sprint process including sprint planning, estimation of efforts, daily team huddles, sprint reviews and sprint retrospectives.
• To develop the reporting side of the IIC including user facing dashboards, reports and input forms (narrative and commentary functionality), ensuring all developments are built to meet the objectives of the customer before being transitioned into an operational environment.
• To provide specialist support for all Trust-wide IIC Systems. This includes co- producing detailed technical design documentation proposals for change controls, supplier upgrade paths and development proposals.
• To promote a data quality culture throughout the organisation to ensure accurate, complete and up to date information is available from IIC information system to support decision making and management.
• To ensure the Trust derives optimum operational functionality, level of support and best value from managed services and utilisation of systems, aiding clinical care and supporting business requirements. This involves development of close working relationships with clinical and corporate services and third-party suppliers.
• To undertake system testing of own and peer developments
• To develop and maintain appropriate documentation and knowledge to ensure business continuity and contingency.
• To assist in providing a systematic and modern approach to the use of information and its associated technology, thereby ensuring that Trust staff gain maximum benefit from its use.
• To assist and deputise, where appropriate, for the Business Intelligence Systems Manager across a range of information service issues.
• To line manage and support the growth and development of a small team of Business Intelligence Developers.
• To devise and deliver specialist training to internal staff and external customers on technical developments, and complex ideas and processes.
Person specification
Qualifications
Essential criteria
- Educated to Degree standard or equivalent preferably in an informatics related subject
- Equivalent experiential learning in the field of Information systems design, development and implementation.
Desirable criteria
- Post graduate qualification standard or equivalent or experiential learning in an informatics related subject
- Report development course certificate
Experience
Essential criteria
- Significant experience in creating Dashboards and Reports using Cognos or similar reporting tools
- Experience of developing and using Java within reports and developments
- Significant experience of using and writing advanced SQL and other system development languages
- Significant experience of planning and delivering change within an informatics environment
- Significant experience of managing and administering a large information system
- Significant experience of change control processes and producing technical specification options
- Experience of managing and supporting complex database management systems in busy, confidential settings
- Experience of gathering and defining user requirements
- Experience of supervising staff
- Experience of a customer led service
- Experience of NHS IT systems and services
- Experience in managing projects or work packages
- Experience of business process redesign
Desirable criteria
- Working in an NHS environment
- Experience in the management of third party suppliers
- Experience of working with large data
- Experience of working with analytical cubes
Knowledge
Essential criteria
- Demonstrable post-graduate level knowledge in the following areas: IBM Cognos product suite and how the various layers integrate
- Development cycle including requirements gathering, design, build, test, release and signoff
- Relational database management systems (RDBS)
- Integration between the data warehouse and Cognos reports to enable developments, fault finding and resolution
- Business process redesign techniques
- One or more computer system(s), hardware or software and procedures to develop reports, documents and spreadsheets
- Facilitation and training delivery techniques
- Software application platforms, e.g. (but not limited to) SQL, IBM, Oracle including practical applications
- System change control processes, upgrades paths and release management
- Knowledge of change management principles (ITIL)
- Standard PC applications (e.g. PowerPoint, Word, Excel)
Desirable criteria
- Knowledge of current NHS legislation, policies and procedures
- Knowledge of clinical processes
- Knowledge of corporate processes2
Skills
Essential criteria
- Excellent organisational planning skills
- Ability to grasp high level concepts and relate to operational detail
- 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, Java, End user interface design (UDFs)
- Use of IBM Cognos suite including Reporting Studio, Framework Manager, Analysis studio and Cognos Administrator
- Ability to resolve complicated data queries and issues that might resided at a data or report level
- Good numeracy and analytical skills
Desirable criteria
- Use of advanced analytical tools
- Facilitation of design workshops with customers
Personal Attributes
Essential criteria
- Able to work under pressure and meet deadlines.
- Committed to continual quality and service improvement.
- Self-aware and committed to continual professional and personal development. Able to accept and respond positively to feedback from supervision.
Documents to download
Further details / informal visits contact
- Name
- Alex Murdoch
- Job title
- Business Intelligence (BI) Systems Manager
- Email address
- [email protected]
- Telephone number
- 01642 374871
List jobs with Tees, Esk and Wear Valleys NHS Trust in Administrative Services or all sectors