Data Analyst

Reporting and Data Analyst (Children’s Social Care)

Employer: Herefordshire Council
Location: Plough Lane, Herefordshire / Hybrid Working Available
Salary: £37,563 – £42,123 per annum (HC08)
Contract: Fixed Term – 12 months
Hours: 37 hours per week, Full-Time
Posts available: 2
DBS: Required
Closing date: 4 November 2026
Interview: Week commencing 16 November 2026
Reference: 3074 (HCWF01109468/HCWF01109551)

About the Role

Herefordshire Council is recruiting Reporting and Data Analysts to provide specialist analytical support for Children’s Social Care and wider Children and Young People’s Services.

The role sits within the council’s Corporate Performance and Intelligence function and offers the opportunity to use data, reporting and analysis to support better services and outcomes for children, young people and families.

Two positions are available. One post is Families First funded and will have a particular focus on supporting the Children and Young People’s data warehouse rebuild project following significant changes to the case management system. The second post will have a mixed analytical workload.

Key Responsibilities

You will:

• Develop and maintain 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 support informed decision-making.
• Support forecasting and modelling to identify future service pressures and opportunities.
• Ensure data quality, integrity and compliance across reporting systems.
• Support the rebuilding and development of the Children’s Social Care data warehouse.
• Help design data structures, reporting solutions and intelligence products.
• Work with system, service and data stakeholders to define reporting requirements, data models and business rules.
• Present complex information clearly to technical and non-technical audiences.
• Work collaboratively across the council to support performance, intelligence and service improvement.

Essential Skills and Experience

Applicants should have:

• Experience producing analytical reports and dashboards.
• Strong SQL skills, including data extraction, transformation and validation.
• Experience with Power BI and data visualisation tools.
• The ability to analyse large and complex datasets and identify meaningful insights.
• Strong communication skills, particularly when explaining complex information to non-technical audiences.
• Knowledge of data quality, governance and assurance principles.
• Good organisational skills and the ability to manage competing priorities.
• Experience working with stakeholders at different levels.

Desirable Experience

Experience in any of the following would be beneficial:

• Children’s Social Care, local government or public services.
• Statutory children’s data returns such as CIN, CLA or SSDA903.
• Python or R for automation, statistical analysis or forecasting.
• Data warehouses and semantic models.
• Mosaic or similar social care case management systems.
• DevOps, version control and reporting lifecycle management.
• Enterprise reporting solutions and data modelling.
• Data warehouse transformation or rebuild projects.

Benefits

Herefordshire Council offers:

• Flexible and hybrid working arrangements.
• Local Government Pension Scheme.
• Generous annual leave.
• Learning and development opportunities.
• Employee wellbeing support.
• The opportunity to contribute to services supporting children, young people and families.

Safeguarding and DBS

The council is committed to safeguarding and promoting the welfare of children, young people and vulnerable adults.

The successful candidate may be required to complete a Disclosure and Barring Service (DBS) check.

How to Apply

Applicants should submit an up-to-date CV and complete the application form, demonstrating their relevant experience, skills and abilities.

For an informal discussion about the role, contact Jessica Karia-Fitzgerald, Head of Corporate Performance and Intelligence, at j.karia-fitzgerald@herefordshire.gov.uk.

If shortlisted, Hoople Resourcing will contact applicants by email with details of the interview and/or assessment.