Business Intelligence Lead

Job description

Job responsibilities

This list of duties and responsibilities, which follows, represents the broad range of tasks which may be required to be undertaken either routinely or periodically. This list is not exhaustive and the role may include additional duties which are not listed here:-

Lead on the continuous development of the organisation data warehouse, including all phases of planning, designing, development and roll out to the organisation. The data warehouse is the central data repository, and takes data feeds from various systems such as Adastra, EMIS Web, IQUS Rota Master, Health Call in Healthcare platform, MediBioSense Health-stream, TomTom Telematics, Opex, Patient Experience survey results and other locally developed solutions such as Impact, Communication Log and Clinical Audit system.

Responsible for managing the Data Warehouse, and where required, supporting other SQL based systems. Responsibilities include ensuring that the 3 data model, data loading, and information reporting is reliable, and that internal and external deadlines are consistently met.

Utilise specialist knowledge in designing the data warehouse architecture to ensure it meet the requirements of standard Business Intelligence (BI) tools, namely MS Power BI, and MS SQL Reporting Services.

Responsible for the translation of highly complex, and sensitive data from various systems in the Trust, and provide assurances to relevant staff, to assure the integrity of data, and mutual understanding when designing, and developing the data warehouse.

Responsible for the management and development of agreed reporting requirements within the data warehouse, together with planning and scheduling of associated work plans.

Lead in the development of comprehensive reporting solutions for data held on the organisations key systems

Lead in the development of business intelligence tools and, lead, train and assist the wider Digital team to develop technical solutions for reporting requirements

Responsible for automation of reports and processes, and the use of data visualization tools such as Power BI and MS SQL Reporting Services

Lead in gathering and refining the organisation requirements to plan, develop, and implement Business Intelligence tools.

Ensure the development and maintenance of clinical data analysis, trends and dashboards which aid clinical information analysis and supports decision making and patient improvement.

Produce, analyse and interpret highly-complex statistical information groups of users (both internal and external) in a clear and understandable way.

Develop and present information in various graphical and statistical formats.

Present highly complex information in a clear and understandable format to groups or meetings, including making formal presentations to large groups and/or workshops taking into account the background of the audience.

Provide leadership and input into the teams range of activities including, mentoring, training and change capability enhancements facilitating the development of multi-disciplinary and appropriately skilled digital support team

Build organisational capability by identifying digital team competencies required.

Provide expert knowledge and support to the Digital programme

Assist in the shaping and delivery of an effective communication strategy and assist in the design and promotion of performance management.

In conjunction with the Head of Digital and Performance and other managers in the Digital and Performance department, ensure linkages between projects and programmes of work are identified and managed.

Develop relationships and influence to ensure ownership of change is achieved and that supportive and sustainable performance management frameworks are in place.

To keep up to date with emerging good practices, technologies and business models whilst sharing and developing this knowledge with the Digital team

Mentor the development of staff across the Digital team

Responsible for the recruitment of team staff

Actively promote Digital services to internal and external audiences, developing links with individuals, groups and organisations

Manage own workload with minimal supervision

Work autonomously but within departmental procedures

Establish and maintain positive working relationships with the wider Digital, operational and management teams across the organisation

Support the Operational teams to facilitate change (this is inclusive of the CHoC workforce and the primary care workforce), working with the operational functions of the organisation to define clinical and non-clinical processes which can be enhanced and optimised through the use of Digital products and services

Support the corporate functions of the organisation, finance, business, rota management to facilitate digital change when needed.

Execute / support delivery of system changes within the organisation, working collaboratively within the Digital and Operations team ensuring that all changes are implemented seamlessly and do not have an adverse impact on the stability of the systems

Develop and support low code apps on the Microsoft Power platform utilising tools including but not limited to Teams, Power Apps, Power BI, Power Automate and Forms

Responsible for providing high quality professional support to all CHoC staff on all IT clinical and non-clinical systems used within the organisation

Provide technical administration services to the key systems within the directorate and be a Subject Matter Expert

Deputise for the Head of Digital and Performance as and when required

To carry out any other reasonable duties in departments/locations as and when required, subject to training and capabilities.

Person Specification

Skills and Aptitudes

Essential

• Be a fluent and effective communicator at all levels.
• Strong analytical skills with good attention to detail.
• Excellent administration and documentation skills.
• Skilled negotiator able to develop relationships and manage stakeholders within IT, the business and IT third parties
• A thorough understanding and knowledge of SQL
• Understanding of available data sources within a business and how these can be extracted and combined for the benefit of the organisation
• Excellent understanding of data modelling, report development, performance tuning and query optimisation techniques
• A thorough understanding of databases and data types
• Ability to analyse and document business reporting requirements with an understanding of the resulting technical implications
• Understanding of the workings of a NHS provider organisation

Desirable

• Knowledge of new digital communications tools and applications
• Experience of Office 365 suite of applications
• Development of strategic plans

Qualifications

Essential

• Degree level of education or equivalent experience in Information Management
• Evidence of continuous professional development (SQL, SQL Reporting Services, Power BI) and/or self-study

Knowledge

Essential

• Previous demonstrable experience operating in an analyst capacity in a technical environment
• Previous demonstrable Business Intelligence, Data Warehouse or DBA experience
• Current working knowledge and experience of using SQL
• Experience of developing dashboard, graphical and statistical reports Experience of NHS Information provision, local and national requirements
• Experience of working with a number of different business applications (systems) and databases, extracting and consolidating different data streams
• Previous experience of data modelling, report development and query optimisation
• Demonstrable experience in working with non-IT staff to implement digital solutions
• Experience in training a wide range of staff groups on IT systems

Desirable

• Experience of developing applications using Microsoft Power Apps
• Experience of collating data and writing board reports
• Experience of the whole project life-cycle and a structured project management methodology such as PRINCE2

Experience

Essential

• Respect confidentiality of patient information
• Problem solving and analytic skills
• Demonstrate excellent organisational skills
• Advanced Microsoft office skills
• Able to prioritise workload effectively
• Demonstrate good attention to detail
• Report writing skills
• Ability to analyse and interpret reports
• Flexible with an ability to multi-task and work in a fast-paced environment
• Excellent team player & ability to work autonomously
• Proven track record of working under pressure to strict deadlines
• Ability to communicate effectively with staff at all levels
• Ability to analyse complex facts and situations and develop a range of options for solutions
• Excellent customer-facing skills, with the ability to present technology in a clear and understandable way to any audience
• Adopts a logical and thorough approach with a positive can do attitude with the ability to see potential solutions and outcomes rather than obstacles
• Pragmatic, results orientated but with a flexible approach to how these might be achieved
• Excellent team player
• Commitment to continuous self-development

Personal Circumstances

Essential

• Positive
• Confident
• Well organised
• Well presented
• Good sense of humour
• Ability to build rapport and effective relationships at all levels
• Demonstrate initiative
• Flexible
• Live locally

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.

Employer details

Employer name

Cumbria Health On Call

Address

Capital Building

Hilltop Heights, London Road

Carlisle

Cumbria

CA1 2NS

Employer's website

https://www.chocltd.co.uk/ (Opens in a new tab)