Business Intelligence Systems Manager (Band 8a) - Informatics - Oxleas NHS Foundation Trust

The successful candidate will be responsible for the smooth running and technical development of the Trust’s BI system. Developing and managing data flows into and out of the trust. They will lead on technical development improvements, designing and building systems in adherence with the software Development Life Cycle.

The focus of this role is ensuring the Business Intelligence system, and the products that have been developed within it, are supported from a technical perspective. This involves leading a database administration function; working with IT and 3rd parties who supply hardware infrastructure to ensure the system can support growth in the number of products; developing data structures such as Extract Transform and Load processes and Cubes; exploring and developing new systems such as mobile business intelligence, new web platforms and new database systems.

The post holder will also lead on change control and business intelligence support, developing and managing a robust change control process to ensure that changes to the database architecture or the source systems do not adversely impact the accuracy of Business Intelligence outputs.

Main duties of the job

The successful candidate will have at least 10 years experience in the business intelligence field with a focus on database administration and will have at least 2 years managerial experience. They will be responsible for managing software engineers, database administrator and product engineers.

Please see below and supporting Job Description for information regarding responsibilities.

Working for our organisation

Oxleas offers a wide range of NHS healthcare services to people in community and secure environment settings. Our services include community health care such as district nursing and speech and language therapy, care for people with learning disabilities and mental health care such as psychiatry, nursing and therapies. Our multidisciplinary teams look after people of all ages and we work in close partnership with other parts of the NHS, local councils and the voluntary sector and through our new provider collaboratives.

Our purpose is to improve lives by providing the best possible care to our patients and their families. This is strengthened by our new values:

• We Listen
• We Care

Detailed job description and main responsibilities

Technical Skills Required:

• Design and develop business and analytical reports.
• SQL Server objects: t-SQL, stored procedures, views
• SQL Server Reporting Services objects
• ASP.NET web applications with C# backend

Soft Skills Required

• Excellent communication skills, written and verbal with the ability to communicate complex technical information to a non technical audience
• Ability to devise best practice principles and lead on their implementation.
• Demonstrates a proactive approach and 'customer-focused' thinking.
• Advise the team on suitable technologies for use in applications
• Ability to manage, lead and develop a team of technical analysts

Main Duties

Hardware Support - ensure that the hardware in place supports the demand being placed on BI Systems. Support ICT in the procurement, installation and testing of new hardware ensuring the needs of the department are met.

Database Architecture - Lead on the design of the Business Intelligence System’s architecture, setting standards for data flow processes and identifying technical solutions to meet BI Developer requirements.

Software - Investigate new technologies and assess their suitability for adoption within the department.

Application Development - Put in place any data collections that might be required outside of existing systems, e.g. HTML forms or new 3rd party data collection applications.

Change Control - Develop a robust change control process to ensure that changes to the database architecture or the source systems do not adversely impact the accuracy of Business Intelligence outputs.

Business Intelligence Support - Lead the Business Intelligence support function to respond to customer requests for fixes or changes to existing Business Intelligence products.

Person specification

Qualification & Experience

• Computer Science Degree or 10 years equivalent experience
• Ability to communicate in different forms with stakeholders
• Ability to work autonomously and manage own time
• Planning and organisational skills
• Self-motivated and able to act on own initiative
• Knowledge and understanding of GDPR
• Understanding of Clinical Information/Patient Management Systems or equivalent systems

Skills/ Technical Knowledge

• Working with Data (SQL Server)
• Developing Reports (SSRS)
• Developing ETL Packages (SSIS)
• Use of development lifecycle
• Use of Source Version Control, e.g. Git
• Working in DevOps environment

We are committed to creating an inclusive workplace that welcomes and supports individuals of all abilities. If you require any adjustments to participate fully in the interview process, please let us know by adding the relevant details when scheduling your preferred interview date and time.

We encourage applicants to contact the hiring manager before their interview, if they have any questions about the role or the process.

Application numbers

This vacancy may close early if it receives a high volume of applications. Please complete and submit your application in good time to avoid disappointment.