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.

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
• Strong communication skills, including the ability to engage with others responsively and interactively to reach shared solutions
• Experience working in a setting where cross-organisational collaboration or partner engagement was key to delivery
  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

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

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