Interim Power BI Specialist

First Mile; City of Westminster; On-site; GBP 80,000 - 100,000; Full time

Job summary

A leading environmental services company based in Soho is seeking an experienced Power BI Specialist to design and deliver accurate reports for Sales, Volume, Price, and more. You will build interactive reports combining SQL and Excel data for insightful analyses. Strong expertise in Power BI, DAX, and SQL is essential. The role offers a daily rate of £250 - £300, along with a collaborative workplace culture rich in social events and learning opportunities.

Benefits

Lots of drinks, food, socials, events

Opportunities to volunteer

Fun, positive, 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 showing key metrics.
• Include views of Actual vs. Forecast vs. Budget.
• Connect and combine data from SQL Server and Excel.
• Create a solid data model for reporting.
• Document work and provide handover.

Skills

Building Power BI reports end-to-end

Good knowledge of SQL

Skilled in DAX

Data modelling

Performance tuning

Good communication skills

Job description

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.

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.

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

• 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.