Management Information Officer - Waste Services
*Annual Salary: Approximately £16 per hour
*Location: Rotherham (Hellaby / Hybrid)
*Job Type: Full-time, 37 hours per week
Join our Waste and Street Scene Services department as a Management Information (MI) Officer. This role is crucial for supporting Waste Services by collecting, analysing, and reporting on management information to enhance service performance, efficiency, and compliance. The focus is on handling large datasets, producing accurate reports, and providing insights primarily using Microsoft Excel and other data tools.
Day-to-day of the role:
*Data Management & Analysis:
*Extract, manipulate, and analyse large datasets related to household waste collection, recycling rates, missed collections, and fleet and route performance.
*Maintain and update datasets ensuring accuracy, consistency, and integrity.
*Clean and validate data from multiple systems such as CRM, in-cab systems, and weighbridges.

*Reporting & MI Production:
*Produce regular performance reports (daily, weekly, monthly) for operational teams and senior management.
*Develop and maintain Excel-based dashboards and trackers.
*Provide statutory returns and respond to ad hoc data requests from managers and stakeholders.

*Excel & Technical Work:
*Utilise advanced Excel functions including pivot tables, VLOOKUP/XLOOKUP, and Power Query.
*Automate reporting processes to improve efficiency.
*Support the development of standardised MI templates.

*Performance & Insight:
*Identify trends, issues, and opportunities within waste service data.
*Support service improvement by providing evidence-based insights.
*Work closely with operational managers to interpret data findings.

*Stakeholder Support:
*Liaise with internal teams (operations, customer services, finance).
*Translate complex data into clear, understandable information.
*Support audits and performance reviews.

Required Skills & Qualifications:
*Strong experience working with large datasets.
*Advanced Microsoft Excel skills (pivot tables, lookups, formulas).
*Experience producing MI reports or performance dashboards.
*Strong analytical and problem-solving ability.
*High attention to detail and data accuracy.
*Ability to explain data to non-technical stakeholders.
*Desirable: Experience within local government or waste services, knowledge of WasteDataFlow or environmental reporting, experience with Power BI or other visualisation tools.
Benefits:
*Competitive hourly rate.
*Hybrid working options.
*Opportunity to contribute to public service improvement through data-driven decision-making.
How to apply:
To apply for the Management Information Officer position in Waste Services, please submit your CV and cover letter detailing your relevant experience and why you are interested in this role.