Skip to main content

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

Please wait, loading

Job summary

Main area
Business Intelligence
Grade
NHS AfC: Band 6
Contract
Permanent
Hours
  • Full time
  • Flexible working
37.5 hours per week (The Trust will support staff to work from home for up to 60% of their working week)
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

Tees, Esk and Wear Valleys NHS Trust logo

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.

Employer certification / accreditation badges

We are a Living Wage EmployerApprenticeships logoNo smoking policyPositive about disabled peopleAge positiveImproving working livesMindful employer.  Being positive about mental health.Disability confident employer

Documents to download

Apply online now

Further details / informal visits contact

Name
Alex Murdoch
Job title
Business Intelligence (BI) Systems Manager
Email address
[email protected]
Telephone number
01642 374871
Apply online nowAlert me to similar vacancies