6 Month Contract With A Local Authority

Job Purpose

To analyse and interpret data in order to produce accurate, timely, and meaningful performance reports that support service delivery, statutory reporting, and organisational decision-making. The role involves developing and maintaining data pipelines and reporting systems using SQL, ETL processes, and Power BI to enable effective self-service reporting and insight across the Council. The postholder ensures data is reliable, compliant, and used to drive service improvement and meet regulatory and inspection requirements.

Key Responsibilities

• Analyse data requirements and design reporting solutions to meet statutory, regulatory, and operational needs.
• Develop, maintain, and optimise data pipelines using SQL and ETL processes to integrate data from multiple systems into a centralised data warehouse.
• Design and build Power BI models and interactive dashboards to provide actionable insight across services and directorates.
• Produce, maintain, and automate performance reports, reducing manual reporting and improving efficiency.
• Ensure accuracy, consistency, and quality of data used for performance monitoring, statutory returns, and external inspections.
• Create and maintain technical documentation, data definitions, and user guides.
• Test, validate, and troubleshoot reports and data outputs, resolving issues in a timely manner.
• Support service areas in interpreting data and using insight to drive service improvement.
• Provide technical advice on data feasibility, structure, and reporting approaches.
• Contribute to needs assessments, equality analysis, and insight into local population needs, including minority groups.
• Ensure compliance with data protection, GDPR, and other relevant legislation and Council policies.
• Support continuous improvement of reporting tools, systems, and data processes across the organisation.
• Work collaboratively with internal teams and external partners to deliver a “One Council” approach.
• Provide guidance and support to colleagues and contribute to the development of reporting capability within the team.