Intelligence & Impact Analyst

Zohorecruit; Greater London; Hybrid; GBP 50,000 - 73,000; Full time

Job summary

Southwark Council is seeking an Intelligence & Impact Analyst to deliver evidence-based decision making through advanced data analysis and BI reporting. You will build Power BI dashboards, automate reporting, and provide insights to support service improvement.

The role is a 3-month contract in London with hybrid working and a 36-hour week. Ideal candidates will have strong Power BI experience (DAX) and a track record in the Microsoft Power Platform, plus excellent stakeholder management in

Qualifications

• Significant experience as a Data/Intelligence/Insight/Performance or BI Analyst.
• Advanced Power BI experience including Reporting Automation and DAX.
• Experience using Microsoft Power Platform.
• Experience developing automated workflows with Power Automate.
• Experience gathering and documenting business requirements.
• Experience working with service managers and stakeholders.
• Experience analysing large and complex datasets.
• Experience producing performance reports and management information.
• Ability to present complex information clearly and manage stakeholders.

Responsibilities

• Lead analytical and intelligence activities across assigned service areas.
• Analyse 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.
• Gather, document, and translate business requirements into reporting solutions.
• Deliver high-quality reports and management information products.

Skills

Analytical thinking

Stakeholder management

Data storytelling

Problem-solving

Communication

Education

Data Analytics degree

Statistics degree

Business Intelligence training

Tools

SQL

Python

Power Platform Development

MapInfo

Stata

SAS Enterprise

R

Job description

London, United Kingdom | Posted on 30/09/2026

Job Description

3 Months Contract with a Local Authority

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:

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

• 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.
• 2 days office based.
• Location: 160 Tooley Street, London, SE1 2QH.
• Supplier Submission Deadline: 2nd October 2026.