Performance and BI Analyst

Civic Recruitment Limited; Bexley (OH); Hybrid; USD 47,000 - 74,000; Full time

Job summary

Civic Recruitment Limited in London Borough of Bexley area seeks a data analyst to produce timely performance reports for a local authority. You will design data pipelines using SQL/ETL and build Power BI dashboards to enable self-service insights and regulatory reporting.

The role emphasises data reliability, GDPR compliance, and cross-team collaboration, with responsibilities spanning data modelling, reporting automation, and documentation. Hybrid working on a 6‑month contract.

Qualifications

• 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.

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.

Skills

SQL

Power BI

Data analysis

Communication

Data quality

Education

Degree or equivalent experience

Tools

SSRS

Power Platform

Python

Job description

Bexley, United Kingdom | Posted on 02/07/2026

At Civic Recruitment and Limited, we know that individuals are more than just fixed expenses; they are the cornerstone of every thriving organisation. That’s why we are passionate about transforming recruitment in the public and private sectors.

In the modern job market, organisations in both public and private sectors face significant workforce challenges. Public sector entities, such as local councils and central government departments, often struggle with lengthy recruitment processes, limited access to qualified candidates, and stringent budgetary and regulatory constraints. Private sector businesses, on the other hand, encounter high turnover rates, difficulties managing a mix of permanent and temporary staff, and challenges in sourcing specialised talent for niche industries. These sector‑specific obstacles, coupled with the universal complexities of payroll management, create a pressing need for efficient workforce solutions.

Civic Recruitment Limited addresses these challenges with innovative recruitment and payroll solutions tailored for diverse organisational needs. Recognising the critical hurdles organisations face, the company leverages its expertise to streamline processes, reduce recruitment times, and alleviate administrative burdens. With an extensive database of over 1 million pre‑screened candidates, Civic Recruitment Limited is well‑positioned to cater to the specific needs of both public and private sectors.

Job Description

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)