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

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) 

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.

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?

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.

How to apply

To apply for a position, please upload an up-to-date CV and complete the application form demonstrating your experience, skills and abilities for the role.

For more information or to arrange an informal discussion about the role, please contact: 

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

Be sure to include reference to the job description and person specification or role profile! If you are successfully shortlisted, Hoople Resourcing will contact you via email to arrange your interview and/or assessment. They will confirm the date, time and location of your interview, so please keep an eye on your email inbox - check your spam/ junk folder too. Good luck, we’re looking forward to meeting you!