Interim Power BI Specialist

First Mile | Certified B Corp; Greater London; On-site; GBP 46,125 - 55,350; Part time

Benefits offered by this job

Competitive rate

Social events

Opportunities to volunteer

Fun and collaborative workplace

Job summary

A leading waste management company in Greater London seeks an experienced Power BI Specialist to design reports that analyze key metrics like Sales and Costs. Responsibilities include building end-to-end Power BI reports, ensuring data quality, and collaborating with Finance. The contract spans 4-8 weeks with an immediate start. The position offers a competitive daily rate of £250-£300, and the company promotes a fun and collaborative workplace.

Qualifications

• Strong experience building Power BI reports end-to-end.
• Good knowledge of SQL and combining data from multiple sources.
• Skilled in DAX, data modelling, and performance tuning.
• Experience with Actual vs Forecast vs Budget reporting.
• Able to work independently and deliver quickly in a short timeframe.
• Good communication skills to work with Finance and Commercial teams.

Responsibilities

• Build Power BI reports that show key metrics for Sales and Volume.
• Connect and combine data from SQL Server and Excel.
• Create a solid data model that supports fast and accurate reporting.
• Document work and provide a handover for report maintenance.

Skills

Building Power BI reports

SQL knowledge

DAX and data modelling

Analytical skills

Tools

Power BI

SQL Server

Job description

About The Role

We need an experienced Power BI Specialist to design and deliver clear, accurate reports that help us analyse Sales, Volume, Price, Costs, Margin, and Churn. These reports will show Actuals, Forecast, and Budget and allow users to slice the data by Channel, Customer Size, Waste Type, and Collection Type. You'll work with data from an SQL database (customer transactions) and Excel sheets, and turn it into easy-to-use Power BI reports for our team.

What You'll Do

• Build Power BI reports that show key metrics for Sales, Volume, Price, Costs, Margin, and Churn
• Include views of Actual vs. Forecast vs. Budget, with clear variance analysis
• Make sure reports can be filtered by Channel, Customer Size, Waste Type, and Collection Type
• Connect and combine data from SQL Server and Excel
• Create a solid data model that supports fast and accurate reporting
• Write DAX measures for KPIs like Sales, Margin %, Churn Rate, and variances
• Verify data quality and ensure numbers match source systems
• Publish reports to Power BI Service and set up refresh schedules
• Document your work and provide a short handover so the team can maintain the reports

Contract: 4‑8 weeks (possible extension)

Start Date: Immediately

Requirements

• Strong experience building Power BI reports end‑to‑end
• Good knowledge of SQL and combining data from multiple sources
• Skilled in DAX, data modelling, and performance tuning
• Experience with Actual vs Forecast vs Budget reporting
• Able to work independently and deliver quickly in a short timeframe
• Good communication skills to work with Finance and Commercial teams

Nice to Have

• Experience with Power BI Premium features
• Knowledge of Azure data tools (Data Factory, Synapse)
• Background in waste/environmental services or similar industries

Deliverables

• Sales & Volume
• Price & Mix
• Costs & Margin
• Churn
• Documentation of the data model and measures
• A short handover session for the internal team

Benefits

• Rate: £250 - £300 per day
• Head Office in the heart of Soho, a minute's walk from Oxford Street.
• Lots of drinks, food, socials, events throughout the year.
• Opportunities to volunteer throughout the year.
• But most importantly, a fun, positive, collaborative workplace in which you can learn, working for a rapidly growing, multi award‑winning business in a sector that has never been more important.

Referrals increase your chances of interviewing at First Mile | Certified B Corp by 2x