Intelligence & Impact Analyst

Civic Recruitment Limited; Greater London; Hybrid; GBP 81,278,000 - 84,034,000; Full time

Job summary

Civic Recruitment Limited supports Southwark Council in delivering evidence-based decision making as an Intelligence & Impact Analyst. You will develop Power BI dashboards, automate reporting processes, analyse complex datasets, and provide actionable insights to support service improvement and strategic planning.

The role is a 3-month contract with hybrid working, 36 hours per week, with 3 days remote and 2 days in the London office at 160 Tooley Street.

Qualifications

• Experience as Data Analyst, Intelligence Analyst, Insight Analyst, Performance Analyst or BI Analyst.
• Advanced Power BI experience: dashboard development, data modelling, data visualisation, reporting automation, and DAX.
• Experience using Microsoft Power Platform and Power Automate.
• Experience gathering and documenting business requirements and working with stakeholders.
• Ability to analyse large datasets and produce management information.
• Strong project delivery and stakeholder management skills.
• Excellent analytical, communication, and problem-solving abilities.

Responsibilities

• Lead analytical and intelligence activities across service areas.
• Analyze large datasets to identify trends, risks, and performance outcomes.
• Develop and maintain Power BI dashboards and visualisations.
• Build data models and reporting frameworks.
• Design automated reporting processes using Power Automate.
• Translate business requirements into reporting solutions.
• Produce high-quality reports, dashboards and MI products.
• Deliver insights to support service transformation and planning.
• Develop KPIs and outcomes frameworks.

Skills

Data Analysis

Power BI

Power Platform

Power Automate

DAX

Stakeholder management

Reporting

Education

Relevant qualification in Data Analytics / BI / Statistics

Tools

SQL

Python

MapInfo

SAS Enterprise

R

Power Platform Development

Job description

Job Description

3 Months Contract with a Local Authority

Umbrella - £31.89 per hour - Umbrella

Job Purpose

As an Intelligence & Impact Analyst, you will support Southwark Council in delivering evidence-based decision making through advanced data analysis, business intelligence reporting, and performance management. You will develop Power BI dashboards, automate reporting processes, analyse complex datasets, and provide actionable insights that support service improvement and strategic planning.

Key Duties/Accountabilities

• Lead analytical and intelligence activities across assigned service areas.
  
• Analyse large and complex datasets to identify trends, opportunities, risks, and performance outcomes.
  
• Develop and maintain advanced Power BI dashboards and visualisations.
  
• Build data models and reporting frameworks.
  
• Design and implement automated reporting processes using Power Automate.
  
• Gather, document, and translate business requirements into reporting and analytical solutions.
  
• Produce high-quality reports, dashboards, and management information products.
  
• Deliver insight that supports service transformation and improvement initiatives.
  
• Develop performance indicators, outcomes frameworks, and KPI reporting.
  
• Conduct forecasting, evaluations, and needs assessments.
  
• Support policy development through robust data analysis and evidence gathering.
  
• Identify and resolve data quality issues.
  
• Conduct data reviews and literature reviews.
  
• Present analytical findings to both technical and non-technical stakeholders.
  
• Maintain compliance with data governance and information security requirements.
  
• Build effective working relationships with services, managers, and external partners.
  

Essential Experience Required

• Significant experience working as a Data Analyst, Intelligence Analyst, Insight Analyst, Performance Analyst, or Business Intelligence Analyst.
  
• Advanced Power BI experience including:
  
  • Dashboard Development
    
  • Data Modelling
    
  • Data Visualisation
    
  • Reporting Automation
    
  • DAX
    
• Experience using Microsoft Power Platform.
  
• Experience developing automated workflows using Power Automate.
  
• Experience gathering and documenting business requirements.
  
• Experience working closely with service managers and stakeholders.
  
• Experience analysing large and complex datasets.
  
• Experience producing performance reports and management information.
  
• Experience presenting complex information in a clear and actionable format.
  
• Strong project delivery and stakeholder management skills.
  
• Excellent analytical, communication, and problem-solving abilities.
  

Desirable Experience

• SQL.
  
• Python.
  
• Power Platform Development.
  
• MapInfo.
  
• Stata.
  
• SAS Enterprise.
  
• R.
  
• Local Government or Public Sector experience.
  

Essential Qualifications Required

• Relevant qualification or equivalent experience in Data Analytics, Business Intelligence, Statistics, Performance Management, Information Management, or a related field.
  
• Right to Work in the UK.
  

Additional Information to Note

• Working hours: 36 hours per week.
  
• Hybrid working arrangement.
  
• 3 days remote working.
  
• 2 days office based.
  
• Location: 160 Tooley Street, London, SE1 2QH.
  
• Contract Length: 3 months.
  
• Interview Week Commencing: 5th October 2026.
  
• Supplier Submission Deadline: 2nd October 2026.
  
• We work on bi-weekly payment schedule.
  

Requirements

As an Intelligence & Impact Analyst, you will support Southwark Council in delivering evidence-based decision making through advanced data analysis, business intelligence reporting, and performance management. You will develop Power BI dashboards, automate reporting processes, analyse complex datasets, and provide actionable insights that support service improvement and strategic planning.