Senior Business Intelligence Analyst

JOB ROLE

The Senior Business Intelligence Analyst is responsible for providing expert analytical, reporting, and business intelligence support predominantly to external partner organisations, including hospices and other health and care providers. Working within the Connecting Systems Intelligence (CSI) team, the post holder will act as a trusted analytical partner, helping stakeholders understand their information requirements and translating these into high-quality data products, dashboards, reports, and insights.

The role combines advanced analytical and technical expertise with strong stakeholder engagement skills, requiring the post holder to build and maintain effective relationships across multiple organisations. They will lead on the development of complex datasets, reporting solutions, data pipelines, and automation processes, while ensuring high standards of data quality, governance, and information security.

PRINCIPAL DUTIES & RESPONSIBILITIES

Leadership

• Coaching/mentoring more junior Information Analysts within the team, providing motivation, support, and personal development.

• Hold the relationship with internal and external clients, escalating issues to senior staff as needed

• Be a visible and approachable member of the CSI team

• Manage supplier relationships, occasionally including delegated budget responsibilities.

Communication & Work Approach

• Support information users to define and clarify information requirements through enabling conversations.

• Communicate proactively, clearly and professionally, both verbally and in writing.

• Provide effort estimates and realistic delivery timescales for requested work.

• Present options clearly, including risks, benefits and trade-offs, to support decision-making.

• Work collaboratively as part of multiple project teams, providing technical expertise and advice.

• Provide updates on projects using project management software

Technical & Analytical Duties

• Design and create multiple and complex datasets using SQL, ensuring they are logical and efficient and optimised.

• Produce professional, high-quality reports and dashboards, typically using Power BI.

• Lead on data quality checking, cleansing and validation to ensure accuracy and completeness.

• Oversee the production and submission of statutory NHS returns and reports.

• Maintain an understanding of the complete data lifecycle, including operational processes

• Build and maintain data pipelines in Azure Data Factory

• Support Robotic Process Automation using tools such as UIPath.

• Undertake horizon scanning for new technologies, making recommendations and preparing business cases for adoption.

• Monitor and maintain automation and scripting technologies to ensure reliability of processes.

Quality

• Embed quality assurance into all aspects of analytical work, supervising the outputs of others where appropriate.

• Ensure systematic documentation of systems, processes, and methodologies.

• Contribute to the development and implementation of operating procedures, organisational policies and data governance standards.

• Ensure all work complies with information governance, cyber security, and change control processes.

Timeliness & Professionalism

• Manage workload effectively, ensuring users expectations and appropriately set and met even in the context of competing priorities.

• Demonstrate punctuality, reliability and professionalism, representing the organisation positively in all settings.

• Proactively communicate availability, progress, and any risks to delivery.

• Ensure work is completed to a high standard and handed over professionally when required.

PERSON SPECIFICATION

Learning and Development

Demonstrates ongoing commitment to professional development through degree-level education or equivalent experience. Proven aptitude for learning new technologies, including self-directed learning - Essential

Technical - SQL

Minimum of 18 months' experience in data transformation and report development using SQL, with a proven ability to work independently and at pace on advanced level problems - Essential

Technical – PBI/Reporting

High level of analytic skill and attention to detail, with at least 18 months experience of data analysis across multiple datasets, using tools such as Power BI (Fabric), Tableau, Excel or similar - Essential

Technical – RPA/ADF

Intermediate level knowledge and experience in at least one of the following (Essential):

• Building and maintaining data engineering pipelines from scratch using tools such as Azure Data Factory

• Building and maintaining UI based Robotic Process automations from scratch using tools such as UIPath

Values

Demonstrates commitment to Here’s purpose and values which can be found on our website. https://hereweare.org.uk/about/exceptional-care-for-everyone/ - Essential

Mentoring

Able to train, mentor, or coach junior analysts - Essential

Relationships

Proven ability to manage relationships and contracts with internal and external stakeholders, acting as the primary point of contact. Confident in representing the organisation professionally and escalating issues when appropriate - Essential

Successful Autonomous Working

Demonstrates self-motivation, accountability, and punctuality, with evidence of successful autonomous working in remote settings, showing strong ownership of tasks and professional handover when required - Essential

Communication

Communicates proactively, clearly and professionally in both written and verbal forms, setting expectations and responding promptly to support effective collaboration - Essential

Organisation and Time Management

Effectively manages time, workload, and competing priorities, proactively communicating availability and escalating risks to ensure deadlines are met. Able to scope work to set reasonable expectations - Essential

Team Work

Integrates seamlessly with operational teams, ensuring analysis is informed by and aligned with frontline perspectives - Essential

Cyber

Knowledge of cyber security principles and procedures with an awareness of the importance of information governance - Essential

Clinical Systems

Experience of configuring or administering a TPP SystmOne unit - Desirable

Decision Making

Able to appraise and propose different options for decision making and follow our organizational advice process - Desirable

Health System

Good understanding of health and social care systems and issues - Desirable

USE OF NEW TECHNOLOGY

We will make use of computer technology. Staff should expect to use automated information systems in their work in order to improve quality and coordination of services, and to enable faster and more accurate communication within and outside of the organisation.

CONFIDENTIALITY

As an employee of ‘Here’ you may gain knowledge of a highly confidential nature relating to the private affairs, diagnosis and treatment of patients, information affecting members of the public, matters concerning staff and details of items under consideration by ‘Here’. Under no circumstances should such information be divulged or passed to any unauthorized person. This includes holding conversations with colleagues concerning patients or staff in situations where the conversation may be overheard. Breaches of confidence will result in disciplinary action which may involve dismissal.

EQUAL OPPORTUNITIES

Our policies and practices are designed to ensure equality of opportunity in employment and service delivery. All staff are expected to comply with these policies and practices.

HEALTH AND SAFETY

All staff have a responsibility to perform their duties in such a way that accidents to themselves and to others are avoided, and to cooperate in maintaining their place of work in a tidy and safe condition, thereby minimising risk. Employees will, therefore, refer any matters of concern through their respective line managers. Similarly, it is each person’s responsibility to ensure a secure environment and bring any breaches of security to the attention of their managers.

NO SMOKING POLICY

We operate a no-smoking policy. This applies to all staff and visitors. This policy also includes travelling in ‘Here’ owned or leased vehicles during work time and whilst travelling in their own vehicles whilst on duty, in work time or whilst on ‘Here’ premises. It is a condition of employment for staff that they do not smoke whilst on duty or anywhere on the premises including the car park.

TRAINING AND DEVELOPMENT

All employees have a responsibility to undertake statutory and mandatory training that is required by ‘Here’. In accordance with the Training and Development Policy staff are expected to actively participate in the appraisal system and using this process to develop a Personal Development Plan (PDP).