Senior Business Intelligence Analyst

Hereweare; Brighton; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

Hereweare is seeking a Senior BI Analyst to provide expert analytics, reporting, and BI support for external partners in health and care. You will lead on complex datasets, dashboards, and data pipelines while ensuring data quality, governance and security.

You will collaborate with multiple project teams, mentor junior analysts, and maintain relationships with internal and external stakeholders. The role requires strong SQL, Power BI skills, and experience with data integration tools such as

Qualifications

• Experience transforming and reporting data using SQL.
• Strong ability to design complex datasets and dashboards.
• Proven ability to work with stakeholders to shape information needs.
• Knowledge of data governance, security and lifecycle management.

Responsibilities

• Design and create complex datasets using SQL for dashboards and reports.
• Produce high-quality reports and dashboards (Power BI).
• Lead data quality checks, cleansing and validation.
• Oversee NHS returns and statutory reports where applicable.
• Build data pipelines (Azure Data Factory) and automate processes.
• Support RPA initiatives using UIPath and related tooling.
• Scan for new technologies and prepare business cases for adoption.

Skills

SQL

Power BI

Data analysis

Stakeholder engagement

Team collaboration

Education

Degree-level education

Tools

Azure Data Factory

UIPath

Excel

Tableau

Job description

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