Data & Business Intelligence Analyst

West London Waste Authority; 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 your skills in Power BI and SQL will help transform public sector data management across six London boroughs. This role offers the chance to create insightful reports, enhance data processes, and collaborate with diverse stakeholders. With a focus on efficiency and sustainability, you'll play a pivotal role in shaping how information influences operational and environmental decisions. Enjoy 28 days of annual leave and the opportunity to make a significant impact in your community.

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 transformation.
• Ability to resolve data issues through stakeholder engagement.

Responsibilities

• Design and maintain automated dashboards using Power BI.
• Gather and validate data from boroughs and contractors.

Skills

Power BI

SQL

Data Modelling

DAX

Power Query

Data Integration

Cross-organisational Collaboration

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.