Reporting and Data Analyst (Children's Social Care)

Reporting and Data Analyst (Children's Social Care), 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.
  
  We are seeking a highly motivated analyst who combines technical expertise with curiosity, critical thinking and strong communication skills., 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., 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.
  
  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.

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.