Reporting and Data Analyst (Children's Social Care)

Hoople Ltd; Hereford; Hybrid; GBP 38,000 - 42,000; Full time

Benefits offered by this job

Flexible/hybrid working

LGPS

Generous annual leave

Learning & development

Wellbeing support

Job summary

Herefordshire Council is seeking a Reporting and Data Analyst for Children's Social Care. The role focuses on transforming complex data into clear, actionable intelligence, delivering dashboards and statutory reports, and supporting a data warehouse rebuild within Families First delivery.

The post requires strong SQL, Power BI and the ability to communicate insights to diverse audiences, with hybrid working and an emphasis on improving services for children and families.

Qualifications

• Experience producing high-quality analytical reports and dashboards.
• Strong SQL skills for extraction, transformation and validation.
• Experience using Power BI and data visualization tools.
• Ability to analyse large datasets and communicate insights to non-technical audiences.
• Knowledge of data quality, governance and assurance principles.

Responsibilities

• Develop and maintain reports, dashboards and performance products using SQL and Power BI.
• Deliver statutory reporting requirements for Children's Social Care.
• Analyse trends, demand and performance to inform decisions.
• Support forecasting and modelling for future service pressures.
• Ensure data quality and compliance across reporting systems.
• Assist in rebuilding the Children’s Social Care data warehouse and reporting solutions.
• Collaborate with stakeholders to define reporting requirements and data models.
• Present insights clearly to technical and non-technical audiences.

Skills

Analytical reports

Dashboards

SQL

Power BI

Data trends

Stakeholder comms

Governance

Prioritisation

Tools

Power BI

Data warehouse basics

Job description

About the Role

Reporting and Data Analyst (Children's Social Care)

Salary: HC08 £37,563 - £42,123 per annum
Location: Plough Lane, Herefordshire / Hybrid Working Available
Directorate: Corporate Services (Corporate Performance & Intelligence)
Hours:37 (12 months fixed term contract)
DBS Check: Required

Closing date: 04/11/2026

Interview date: w/c 16/11/2026

Number of Posts Available: 2 (one is Families First funded with a specific emphasis on supporting the CYP data warehouse rebuild project following the significant changes to the case management system and the other will have a mixed workload)

Help Shape Better Outcomes for Children and Young People

Are you passionate about turning data into meaningful insight that drives better services and improves lives?

Herefordshire Council is looking for an exceptional Reporting and Data Analyst to join our Corporate Services team, providing specialist analytical support for Children's Social Care and wider Children and Young People's Services.

This is a unique opportunity to combine advanced analytical skills with a role that has a direct impact on some of the most important services we deliver. Sitting within our corporate performance and intelligence function, you will work closely with Children's Social Care leaders, operational managers and partners.

About the Role

As our Reporting and Data Analyst, you will be the expert who transforms complex social care data into clear, actionable intelligence.

You will:

• Develop and maintain high-quality reports, dashboards and performance products using SQL, Power BI and other analytical tools.
• Deliver statutory reporting requirements including Children's Social Care returns and regulatory information.
• Analyse trends, demand and performance to help leaders make informed decisions.
• Support forecasting and modelling to understand future service pressures and opportunities.
• Ensure data quality, integrity and compliance across reporting systems and processes.
• Provide Support in rebuilding and developing the Children’s Social Care data warehouse, designing robust data structures, reporting solutions and intelligence products that support Families First delivery, statutory reporting and service improvement.
• Work with system, service and data stakeholders to define reporting requirements, data models and business rules that underpin the Families First reporting framework.
• Present insights clearly to both technical and non-technical audiences.
• Work collaboratively across the council, supporting a One Council approach to performance, intelligence and improvement.

This role sits within the Corporate Centre, offering the opportunity to influence strategic decision‑making while playing a key role in the transformation of Children’s Services data and intelligence capabilities.

What We’re Looking For

We are seeking a highly motivated analyst who combines technical expertise with curiosity, critical thinking and strong communication skills.

Essential Experience and Skills

You will have:

• Experience producing high-quality analytical reports and dashboards.
• Strong SQL skills including data extraction, transformation and validation.
• Experience using Power BI and data visualisation tools.
• The ability to analyse large and complex datasets and identify meaningful trends and insights.
• Experience communicating complex information clearly to non‑technical audiences.
• Knowledge of data quality, governance and assurance principles.
• Excellent organisational skills and the ability to manage competing priorities and deadlines.
• Experience working collaboratively with stakeholders at all levels.

Desirable

• Experience within Children’s Social Care, local government or public services.
• Knowledge of statutory children’s data returns (such as CIN, CLA or SSDA903).
• Experience using Python or R for automation, statistical analysis or forecasting.
• Experience working with data warehouses and semantic models.
• Knowledge of Mosaic or similar social care case management systems.
• Experience of DevOps, version control and reporting lifecycle management.
• Experience developing, enhancing or supporting data warehouses, data models or enterprise reporting solutions.
• Experience designing, rebuilding or enhancing data warehouses and semantic models, including supporting business transformation programmes.

Why Join Herefordshire Council?

At Herefordshire Council, our work is guided by our THRIVE values:

Trust | Honesty | Responsibility | Inclusivity | Value | Empathy

We are committed to creating a supportive, collaborative and inclusive workplace where people can thrive and develop their careers.

In return, we offer:

• Flexible and hybrid working arrangements.
• Local Government Pension Scheme.
• Generous annual leave entitlement.
• Learning and development opportunities.
• Employee wellbeing support.
• The opportunity to make a genuine difference to the lives of children, young people and families in Herefordshire.

Make an Impact Through Insight

If you enjoy solving complex problems, uncovering the story behind the data and using evidence to improve outcomes, we’d love to hear from you.

Join Herefordshire Council and help us use data and intelligence to deliver better outcomes for children, young people and communities across Herefordshire.

Commitments, Covenants and Statutory Obligations

The following candidates will be interviewed if they meet the essential criteria for the post they are applying for:

• Those who indicate that they have a disability. This is part of our commitment to the “Disability Confident” scheme.
• Those who indicate in their application that they are an Armed Forces Veteran or Reservist. This is part of our pledge to support the Armed Forces Covenant.
• Those who indicate in their application that they are a Herefordshire care leaver. This is part of our commitment to supporting young people leaving our care.

We take our commitment to safeguarding and promoting the welfare of children, young people and vulnerable adults seriously and expect all of our staff, visitors and volunteers to share in this commitment.

We are committed to safeguarding and promoting the welfare of children & young people and vulnerable adults. If you are offered this position, it may be subject to a Disclosure and Barring Service check.

Jessica Karia-Fitzgerald, Head of Corporate Performance and Intelligence, email: [e-mail]