Job summary 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. About us 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 Date posted 04 November 2024 Pay scheme Agenda for change Band Band 6 Salary £37,338 to £44,962 a year per annum Contract Permanent Working pattern Full-time, Flexible working Reference number 346-CORP-158-24 Job locations Flatts Lane Centre Flatts Lane Normanby TS6 0SZ Job description Job 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. 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 Trusts 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 Trusts dashboards, reports and alerts that reside within the IIC portal, supporting the Trusts 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. Job description Job 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. 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 Trusts 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 Trusts dashboards, reports and alerts that reside within the IIC portal, supporting the Trusts 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 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 Post graduate qualification standard or equivalent or experiential learning in an informatics related subject Experience Essential Significant experience in creating Dashboards and Reports using Cognos or similar reporting tools Significant experience of using and writing advanced SQL and other system development languages. 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. Knowledge Essential Development cycle including requirements gathering, design, build, test, release and sign-off Integration between the data warehouse and Cognos reports to enable developments, fault finding and resolution Facilitation and training delivery techniques. System change control processes, upgrades paths and release management Standard PC applications (e.g. PowerPoint, Word, Excel) Desirable Knowledge of clinical processes Knowledge of corporate processes Skills Essential Excellent organisational planning skills End user interface design (UDFs) Use of IBM Cognos suite including Reporting Studio, Framework Manager, Analysis studio and Cognos Administrator Personal Attributes Essential 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. Person Specification Qualifications Essential 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 Post graduate qualification standard or equivalent or experiential learning in an informatics related subject Experience Essential Significant experience in creating Dashboards and Reports using Cognos or similar reporting tools Significant experience of using and writing advanced SQL and other system development languages. 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. Knowledge Essential Development cycle including requirements gathering, design, build, test, release and sign-off Integration between the data warehouse and Cognos reports to enable developments, fault finding and resolution Facilitation and training delivery techniques. System change control processes, upgrades paths and release management Standard PC applications (e.g. PowerPoint, Word, Excel) Desirable Knowledge of clinical processes Knowledge of corporate processes Skills Essential Excellent organisational planning skills End user interface design (UDFs) Use of IBM Cognos suite including Reporting Studio, Framework Manager, Analysis studio and Cognos Administrator Personal Attributes Essential 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. 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. Certificate of Sponsorship Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab). From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab). Additional 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. Certificate of Sponsorship Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab). From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab). Employer details Employer name Tees Esk and Wear Valleys NHS Foundation Trust Address Flatts Lane Centre Flatts Lane Normanby TS6 0SZ Employer's website https://www.tewv.nhs.uk/ (Opens in a new tab)