Data Consultant

Data Analyst – Workforce Analytics

Cedar are seeking a skilled and data-driven Power BI Analyst with a strong background in workforce analytics to join our healthcare organisation. This is a contract position that will last until the end of the year. In this role, you will use data to support strategic workforce decisions, improve operational efficiency, and contribute to workforce planning initiatives across clinical and non-clinical staff groups. You will be responsible for developing interactive dashboards, producing insightful reports, and analysing complex data sets to provide meaningful insights to HR, Finance, and Operational teams.

Key Responsibilities

• Design, maintain, and enhance Power BI dashboards to visualise workforce KPIs, trends, and forecasts (e.g., staff turnover, sickness absence, recruitment, skill mix, vacancies, rostering).
• Support workforce planning by analysing data on headcount, whole-time equivalents (WTE), agency usage, staff demographics, and role distribution.
• Extract, clean, and transform data from multiple HR, payroll, e-rostering (e.g., Allocate), and ESR systems.
• Provide data insights and scenario modelling to support workforce strategy and capacity planning.
• Work closely with colleagues in HR, Finance, and Operations to understand reporting needs and deliver tailored data solutions.
• Automate recurring reports and develop self-service analytics tools for key stakeholders.
• Ensure data accuracy, consistency, and compliance with NHS workforce standards and data governance protocols.
• Contribute to projects related to workforce transformation, staff retention, and equality, diversity and inclusion (EDI) monitoring.
• Keep up to date with best practices in healthcare analytics and Power BI developments.

Skills and Experience

Essential:

• Demonstrable experience in a Power BI Analyst or Data Analyst role, ideally within a healthcare or NHS setting.
• Strong proficiency in Power BI (including DAX, Power Query, and data modelling).
• Good understanding of workforce metrics and HR data structures.
• Skilled in SQL and advanced Excel techniques for data analysis.
• Experience working with data from ESR, e-rostering systems (e.g., Allocate), and HRIS platforms.
• Ability to communicate clearly and translate data into meaningful insights for non-technical audiences.
• Familiarity with UK data protection regulations (e.g., GDPR) and information governance within healthcare.

Desirable:

• Experience with NHS Digital workforce datasets, Model Health System, or NHSE/I workforce returns.
• Knowledge of additional analytics tools such as R or Python.
• Involvement in workforce redesign, transformation, or efficiency programmes.
• Awareness of EDI, wellbeing, and workforce supply challenges within UK healthcare.

If you are a data/workforce specialist on short notice and looking to join an exciting project please apply.