Data & Business Intelligence Analyst

TN United Kingdom; Greater London; On-site; GBP 37,000 - 39,000; Full time

Job summary

Join a mission-driven organization as a Data & Business Intelligence Analyst, where you will play a crucial role in improving public services across six London boroughs. This position offers the opportunity to design and maintain automated dashboards, ensuring data quality and consistency while collaborating with various stakeholders. With a focus on data-driven decision-making, you'll help shape how information flows between organizations, making a tangible impact on operational and environmental outcomes. If you possess strong technical skills and a passion for public service improvement, this role is perfect for you.

Benefits

28 days holiday plus public holidays

Local Government Pension Scheme

Cycle to Work scheme

Employee Assistance Programme

Qualifications

• Proven experience using Power BI and SQL for data analysis.
• Strong skills in data integration and reporting across multiple sources.

Responsibilities

• Design and maintain automated dashboards using Power BI.
• Collaborate with stakeholders to enhance reporting accuracy and efficiency.

Skills

Power BI

SQL

Data Modelling

DAX

Data Integration

Tools

Power Query

Azure

Job description

Social network you want to login/join with:

Data & Business Intelligence Analyst, West Drayton

col-narrow-left

Client:

Location:

West Drayton, United Kingdom

Job Category:

Other

-

EU work permit required:

Yes

col-narrow-right

Job Reference:

4767c07f67a9

Job Views:

5

Posted:

05.05.2025

Expiry Date:

19.06.2025

col-wide

Job Description:

Data & Business Intelligence Analyst
Location: West Drayton, London
Contract: Permanent, Full-time (36 hours per week)
Salary: £37,007 - £38,821 (inclusive of London Weighting)
Benefits: 28 days holiday plus public holidays, Local Government Pension Scheme, Cycle to Work scheme, Employee Assistance Programme

About Us – West London Waste Authority (WLWA)
WLWA is a statutory public body responsible for managing waste disposal for six London boroughs: Brent, Ealing, Harrow, Hillingdon, Hounslow and Richmond upon Thames. Working on behalf of over 1.7 million residents, we manage the treatment, transfer and disposal of waste and recycling that local councils collect.

We coordinate complex waste operations, liaise with multiple contractors and public sector partners, and deliver environmental services with a focus on efficiency and sustainability. As the sector becomes more data-driven, we are investing in the way we collect, manage and use information across borough boundaries.

Make Public Sector Data Work Better Across Borough Boundaries
To support this transformation, we're looking for a Data & Business Intelligence Analyst (internally known as “MI Analyst”) who can work confidently at the intersection of data, systems and people.
This role is for someone who can build robust, insightful reports — while also working collaboratively across boroughs, finance teams and contractors to align data capture and reporting.

This is a delivery-focused position with the opportunity to shape how information flows between organisations and influences operational, financial and environmental decision-making.

What You'll Do
-Design, build and maintain automated dashboards and reporting tools using Power BI, DAX, Power Query, and SQL

-Gather, validate and integrate data from boroughs and contractors, ensuring consistency and quality

-Support statutory data returns (e.g. Waste Data Flow) and produce management and financial reports

-Investigate discrepancies, spot data issues early, and engage constructively with partners to resolve them

-Collaborate closely with internal colleagues and external stakeholders to deliver improvements in reporting accuracy, usability and efficiency

- Provide mentoring and task oversight to the MI Assistant to ensure consistent data practices across the team.

The Environment You'll Be Working In

This role spans multiple organisations with differing systems and priorities. It requires a proactive, analytical approach — and the ability to build trust and shared understanding across stakeholders.
-You'll need to communicate clearly, work interactively with others, and respond effectively to requests and issues as they arise.
-The role involves real-time collaboration and engagement as part of day-to-day delivery, especially when resolving data queries or aligning reporting practices.

Essential Skills and Experience

-Proven experience using Power BI, including DAX, Power Query, and data modelling techniques
-Strong skills in SQL or T-SQL for transforming, cleansing and integrating data
-Experience working with large, complex datasets from multiple sources
-Ability to identify, explain and resolve data issues through direct engagement with stakeholders
-Evidence you can drive a data issue to resolution – e.g. persuading a partner to correct their feed, coaching non-technical colleagues, or thrashing it out on a live call until the numbers balance.
-Experience working in a setting where cross-organisational collaboration or partner engagement was key to delivery

Highly Desirable Experience working in or with local government or public sector data.
-Understanding of environmental or waste management data
-Familiarity with statutory data submission processes or financial reconciliation reporting
-Hands-on data-engineering capability, ideally including: Designing and building a lakehouse architecture, Implementing Azure access-management controls, Setting up row-level security for Power BI reports

Why Join WLWA?

We're a small, mission-driven organisation with wide reach and big ambitions. You'll work in a role that combines technical hands-on data work with the chance to improve public services across six London boroughs.
We offer:
-28 days annual leave plus public holidays
-Membership of the Local Government Pension Scheme (LGPS)
-Opportunities to lead on meaningful improvements in data processes and reporting
-A varied, cross-organisational working environment with real-world impact

Apply Now

We welcome applications from all backgrounds and actively encourage people who bring diverse perspectives to apply. If you can combine strong technical skills with the ability to build relationships, explain complexity clearly, and drive improvement across varied stakeholders — we want to hear from you.

We are committed to creating an inclusive, diverse workplace and welcome applications from all backgrounds.