Senior BI Analyst: Power BI, SQL & Azure Data Factory Lead

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

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