Systems, Insight & Intelligence Analyst (Street Scene)

Civic Recruitment Limited; Chipping Barnet; On-site; GBP 35,000 - 46,000; Full time

Job summary

Civic Recruitment Limited is recruiting for a 6-month contract role with a Local Authority to deliver high-quality business intelligence and performance reporting for the Environment Directorate. The post holder will analyse complex datasets, develop meaningful insights and create automated reporting using Power BI and advanced Excel tools.

The role requires experience in data analytics, strong communication skills and the ability to translate statistical information for non-technical audiences.

Qualifications

• Degree-level qualification or equivalent experience in a related data field.
• 2+ years in reporting, statistics or BI solutions.
• Proficient in Power BI for dashboards and reporting.
• Advanced Excel skills required.
• Experience analysing large/complex datasets.
• Experience communicating findings to non-technical audiences.
• Ability to influence service planning with data insights.
• Experience with Python or R for data transformation.

Responsibilities

• Develop, maintain and deliver performance reports, dashboards and MI for Street Scene and Environment Services.
• Collect, analyse and interpret complex datasets from multiple sources.
• Produce actionable insights to support decision-making at operational and strategic levels.
• Develop Power BI dashboards and automated reporting solutions.
• Transform and model data with Excel, Python or R as appropriate.
• Support data migration, cleansing and governance across service systems.
• Provide guidance on performance data and analytical methodologies.

Skills

Analytical thinking and problem‑solv​i

Excellent written and verbal commu​n​i

Stakeholder management

Ability to manage multiple projects

Data-driven decision making

Education

Degree in Data Analytics/Data Science/Statistics/Mathematics/BI or related

Tools

Power BI

Excel

Python

R

GIS

Job description

Barnet, United Kingdom | Posted on 09/10/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 provide high-quality business intelligence, performance reporting, data analysis and insight services to the Environment Directorate, supporting operational and strategic decision-making across Street Scene and wider Council services.

The postholder will be responsible for collecting, analysing and interpreting complex datasets from multiple sources, developing meaningful intelligence products, and delivering evidence-based insights that support service improvement, performance management and corporate priorities. The role will act as a key link between data, systems and operational services, ensuring managers have access to accurate and timely information to inform decision-making.

Working within the Street Scene Service Support Team, the role will also support system development, automation, research projects and analytical initiatives across the Environment Directorate.

Key Responsibilities

• Develop, maintain and deliver performance reports, dashboards and management information for Street Scene and Environment Services.
• Collect, analyse and interpret complex datasets from multiple internal and external sources.
• Produce actionable insight to support operational and strategic decision-making.
• Develop and maintain Power BI dashboards, visualisations and automated reporting solutions.
• Use advanced Excel, Power BI and other analytical tools to generate performance intelligence.
• Undertake data transformation, modelling and analysis using Python and/or R where appropriate.
• Support the migration, cleansing, validation and management of data across service systems.
• Act as a super-user for Environment Directorate systems and applications.
• Monitor service performance against key performance indicators and corporate targets.
• Identify trends, risks, opportunities and areas for improvement through detailed analysis.
• Support managers in understanding and applying data to improve service delivery.
• Produce accurate and timely reports for senior managers, service leads and elected members.
• Translate complex statistical information into clear, accessible reports for non-technical audiences.
• Support business planning, service reviews and policy development through evidence-based analysis.
• Conduct research, surveys, audits and evaluations to support service improvement initiatives.
• Undertake literature reviews and evidence gathering to inform best practice and future service development.
• Develop and improve automated data collection, reporting and intelligence processes.
• Support corporate and service-specific projects requiring analytical expertise.
• Provide guidance and advice to managers and stakeholders on performance data and analytical methodologies.
• Contribute to the development of a data-driven culture across the Council.
• Support colleagues through training, knowledge sharing and analytical best practice.
• Maintain accurate documentation, standard operating procedures and data governance processes.
• Ensure compliance with data protection, information governance and confidentiality requirements.

Requirements

• Degree-level qualification in Data Analytics, Data Science, Statistics, Mathematics, Business Intelligence or a related discipline, or equivalent relevant experience.
• Minimum two years' experience producing reports, statistical analysis and business intelligence solutions.
• Strong experience using Microsoft Power BI for reporting, dashboard development and data visualisation.
• Advanced Microsoft Excel skills.
• Experience analysing and interpreting large and complex datasets.
• Strong understanding of performance reporting and management information.
• Experience communicating analytical findings to non-technical audiences.
• Ability to produce reports that influence service planning and decision-making.
• Strong numerical, analytical and problem-solving skills.
• Excellent written and verbal communication skills.
• Ability to manage multiple projects and competing priorities.
• Experience developing relationships with stakeholders across multiple service areas.
• Strong attention to detail and commitment to data accuracy.
• Knowledge of data governance and information management principles.
• Experience using Python and/or R for data analysis and transformation.
• Experience using mapping software, GIS or geospatial datasets.
• Project Management experience or qualification (PRINCE2, Agile or equivalent).
• Experience within Local Government, Environmental Services or Public Sector organisations.
• Knowledge of performance frameworks and public sector reporting requirements.
• Experience supporting service transformation and improvement programmes.
• Experience working with automated data processes and workflow solutions.

Additional Information