Performance and BI Analyst

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.

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

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

• Location: London Borough of Bexley (Hybrid/Office-based as required)
  
• Hours per Week: 36 Hours
  
• Pay: Bi-Weekly Payments