Business Intelligence Systems Manager: Sponsorship Available

Oxleas NHS Foundation Trust

Job Summary

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.

Job description

Job responsibilities

Technical Skills Required:

  • Design and develop business and analytical reports.
  • SQL Server objects: t-SQL, stored procedures, views
  • SQL Server Reporting Services objects
  • SQL Server Integration Services packages
  • 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 Systems 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

Essential

  • Computer Science Degree or 10 years equivalent experience

Desirable

  • 2 Years Management experience

Competencies

Essential

  • 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
  • Leadership skills

Desirable

  • Knowledge and understanding of GDPR
  • Understanding of Clinical Information/Patient Management Systems or equivalent systems

Skills/ Technical Knowledge

Essential

  • Working with Data (SQL Server)
  • Developing Reports (SSRS)
  • Developing ETL Packages (SSIS)
  • Writing code (HTML, JavaScript, C#, Python, PowerShell or other)

Desirable

  • Use of development lifecycle
  • Use of Source Version Control, e.g. Git
  • Working in DevOps environment

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).

Closing Date: 28 January 2025

To apply for this job please visit apps.trac.jobs.