Children's Social Care Data & Insight Analyst

Wmjobs; England; Hybrid; GBP 38,000 - 42,000; Full time

Benefits offered by this job

Local Government Pension Scheme

Flexible and hybrid working

Generous annual leave

Job summary

Herefordshire Council is seeking a Reporting and Data Analyst to transform complex children's social care data into clear, actionable intelligence. You will develop reports and dashboards using SQL and Power BI, deliver statutory returns and support the data warehouse rebuild for Families First.

You will work with leaders and stakeholders to present insights clearly and ensure data quality and governance across reporting systems, helping drive improved outcomes for children and families.

Qualifications

• 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.
• Ability to analyse large and complex datasets and identify meaningful trends and insights.
• Experience communicating complex information clearly to non-technical audiences.

Responsibilities

• 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 data warehouse, designing robust data structures and reporting solutions.
• Define reporting requirements, data models and business rules underpinning Families First reporting.

Skills

SQL

Power BI

Data analysis

Communication

Data quality

Tools

Python

R

Job description

Herefordshire Council is seeking a Reporting and Data Analyst to transform complex children's social care data into clear, actionable intelligence. You will develop reports and dashboards using SQL and Power BI, deliver statutory returns and support the data warehouse rebuild for Families First.

You will work with leaders and stakeholders to present insights clearly and ensure data quality and governance across reporting systems, helping drive improved outcomes for children and families.