Business Analyst

Job responsibilities

Analytical Leadership & Insight Generation

Candidates must be able to demonstrate previous experience of operating as a sole or senior analytical lead, with full ownership of analytical outputs and stakeholder engagement.

Define and prioritise key analytical questions in the absence of clear requirements

Conduct deep-dive analyses to identify trends, risks, opportunities, and root causes

Translate complex data into clear, actionable insight that informs decision-making

Develop benchmarking, targets, and performance frameworks to measure organisational success

Challenge assumptions and existing narratives using evidence-based analysis

Ensure outputs lead to action and measurable impact

Data Acquisition, Integration & Structuring

Identify, access, and interrogate multiple, interdependent data systems across the organisation and partner environments

Work with incomplete, inconsistent, or poorly structured data to create reliable and usable datasets

Design and implement data extraction, transformation, and integration processes

Develop robust data models and pipelines to support sustainable reporting and analysis

Structure data to enable meaningful insight and decision-making

Management Information & Decision Support

Define and deliver high-quality management information that supports operational, workforce, and strategic planning

Develop metrics and KPIs aligned to organisational priorities

Move reporting from descriptive outputs to diagnostic and, where appropriate, predictive insight

Provide clear recommendations alongside analysis to support decision-making at senior level

Lead end-to-end analytical initiatives in a low-structure environment by defining problem statements, developing methodologies from first principles, and delivering actionable insights despite incomplete or ambiguous data.

Operate independently to establish analytical frameworks, identify and source relevant data, and build scalable approaches that support decision-making in the absence of an established data function.

Dashboard & Reporting Development

Design and implement dashboards that drive decisions, not just display data

Ensure reporting outputs are focused, relevant, and aligned to organisational priorities

Eliminate low-value or redundant reporting and streamline analytical outputs

Develop automated, sustainable reporting solutions where appropriate

This role will require building analytical approaches, datasets, and reporting structures where none currently exist.

Data Quality, Governance & Standards

Establish and champion high standards of data quality, integrity, and governance

Define data standards, definitions, and documentation to improve consistency

Implement quality assurance processes to ensure accuracy and reliability

Work with system owners and stakeholders to resolve data issues and improve data maturity

Stakeholder Engagement & Influence

Work closely with senior leaders to understand business challenges and shape analytical approaches

Translate complex analysis into clear, accessible insights for non-technical audiences

Influence decision-making through evidence and structured thinking

Build trust and credibility as the organisations analytical expert

Capability Building & Continuous Improvement

Contribute to the development of a data-driven culture across the organisation

Identify opportunities to improve systems, processes, and analytical capability

Support colleagues in understanding and using data effectively

Continuously improve analytical tools, methods, and outputs

Systems & Tools

Power BI (or equivalent BI tools)

SQL (SQL Server / T-SQL)

Advanced Excel (including Power Query / DAX)

Microsoft Office Suite

Experience with complex datasets (e.g. NHS systems, workforce, operational systems) Note: Too

Qualifications

Essential

• Educated to degree level in a relevant subject (e.g. Mathematics, Statistics, Computer Science, Data Analytics, Information Management, or a related discipline), or able to demonstrate equivalent level of experience and expertise.
• Evidence of continuing professional development in data analysis, business intelligence, or related analytical fields.
• Demonstrable experience in the use of analytical and data visualisation tools, such as Microsoft Power BI, SQL, Excel (advanced), or similar platforms.
• Proven experience in extracting, transforming, and analysing data from multiple and interdependent systems.

Desirable

• Understanding of NHS data systems and reporting standards (e.g. ESR, Health Roster, TRAC, or similar workforce/operational systems).
• Knowledge of data governance, information standards, and GDPR requirements in a healthcare setting.
• Experience in developing and maintaining dashboards and management information reports to support organisational decisionmaking and performance monitoring.

Experience

Essential

• Significant experience of working in a data analysis, business intelligence, or information management role, ideally within a complex or multi-system organisation.
• Proven experience in extracting, manipulating, and integrating data from multiple, interdependent systems and databases
• Demonstrable experience in the design, development, and delivery of dashboards, reports, and analytical outputs that inform decision-making at operational and strategic levels.
• Experience in translating complex data into clear, meaningful insight for a range of audiences, including non-technical stakeholders and senior leaders.
• Experience of ensuring data quality, consistency, and governance across multiple data sources and reporting systems.
• Proven track record of working collaboratively with operational, workforce, and corporate teams to understand requirements and deliver datadriven solutions.
• Experience of using data visualisation and analytical tools such as Power BI, SQL, Excel (advanced), or similar software.
• Comfortable operating as the sole analytical resource, prioritising workload independently and shaping the role over time.

Desirable

• Experience of working within the NHS or wider public sector, with understanding of NHS data flows, reporting processes, and workforce or operational systems (e.g. ESR, Health Roster, TRAC).
• Experience in developing automated reporting processes and performance dashboards to support continuous improvement
• Involvement in data migration, system integration, or transformation projects
• Knowledge of project methodologies

Skills

Essential

• Advanced ability to analyse, interpret, and present complex data clearly and accurately.
• Strong working knowledge of data extraction, transformation, and integration across multiple systems
• Skilled in developing and maintaining interactive dashboards and management information reports (e.g. Power BI, Excel)
• Excellent understanding of data quality, governance, and information security standards (including GDPR).
• Strong problem-solving, critical-thinking, and data visualisation skills to support decisionmaking.
• Ability to communicate technical information effectively to non-technical audiences.
• Excellent attention to detail, accuracy, and data validation.
• Strong organisational and prioritisation skills, with the ability to manage multiple analytical projects.
• Ability to work collaboratively across teams and influence a data-driven culture.

Desirable

• Knowledge of NHS data systems and reporting frameworks (e.g. ESR, Health Roster, TRAC).
• Understanding of performance, workforce, and operational metrics within healthcare.
• Familiarity with data automation, process improvement, or data science tools (e.g. SQL, Python, R).

Personal Qualities

Essential

• Highly analytical, curious, and detail-oriented approach to problem-solving and data interpretation.
• Ability to work independently, exercising sound judgement and managing competing priorities with minimal supervision.
• Strong commitment to data accuracy, integrity, and ethical use of information.
• Excellent interpersonal and communication skills, with the ability to build effective working relationships across multidisciplinary teams.
• Resilient and adaptable, with a proactive approach to managing change and ambiguity in complex environments.
• Commitment to continuous professional development and improving analytical capability within the organisation.

Desirable

• Passion for using data to improve organisational performance, workforce planning, or service delivery
• Collaborative and supportive approach to developing a positive, data-driven culture.
• Confidence in challenging assumptions constructively and influencing decision-making through evidence.

Other

Essential

• Ability to work flexibly to meet organisational and reporting deadlines.
• Willingness to engage with multiple sites, teams, or systems as required by the role.
• Commitment to maintaining confidentiality and complying with data protection and information governance requirements.

Desirable

• Willingness to undertake occasional travel between organisational locations or partner sites.

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