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.
Requirements
- Degree or equivalent experience in a relevant field.
- Experience in data analysis, reporting, or business intelligence within a complex organisation.
- Strong SQL skills (including T-SQL, stored procedures, and CTEs).
- Experience developing dashboards and reports using Power BI (or similar tools).
- Understanding of data warehouse principles and ETL processes.
- Experience working with large datasets and multiple data sources.
- Ability to translate business requirements into technical reporting solutions.
- Strong analytical, problem-solving, and data quality assessment skills.
- Excellent communication skills with the ability to present complex data clearly.
- Knowledge of data protection legislation (GDPR, Freedom of Information Act).
- Experience with SSRS, Power Platform, Python, or Liquidlogic systems (desirable).
- Ability to manage priorities, work collaboratively, and support service improvement through data insight.
Additional Information
- Location: London Borough of Bexley (Hybrid/Office-based as required)
- Hours per Week: 36 Hours
- Pay: Bi-Weekly Payments
Performance and BI Analyst in London employer: Civic Recruitment Limited
Civic Recruitment Limited is an excellent employer, offering a dynamic work environment where strategic leadership in the Special Educational Needs service can truly make a difference in children's lives. With a strong focus on collaboration and professional development, employees are encouraged to grow their skills while contributing to meaningful outcomes in the Bromley community. The supportive culture and commitment to high-quality services make this an attractive opportunity for those looking to lead impactful change.
