Interim Power BI Specialist

First Mile; Greater London; On-site; GBP 80,000 - 100,000; Part time

Job summary

A rapidly growing company in the UK seeks an experienced Power BI Specialist to create and deliver insightful reports on sales and operational metrics. You will be responsible for connecting data from SQL and Excel, ensuring data quality, and publishing reports on Power BI Service. The ideal candidate should have strong skills in DAX and a good understanding of report performance. This contract is initially for 4-8 weeks with the possibility of extension, offering a competitive daily rate.

Benefits

Competitive rate

Social events throughout the year

Opportunities to volunteer

Collaborative workplace

Qualifications

• Experience in delivering accurate reports using Power BI.
• Ability to connect and combine data from multiple sources.
• Strong communication skills for collaboration with teams.

Responsibilities

• Build Power BI reports showing key metrics.
• Connect data from SQL and Excel.
• Document work and provide handover to the team.

Skills

Strong experience building Power BI reports

Good knowledge of SQL

Skilled in DAX

Experience with Actual vs Forecast vs Budget reporting

Good communication skills

Tools

Power BI

SQL Server

Excel

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

What We’re Looking For

· 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

A set of Power BI reports covering:

· Sales & Volume

· Price & Mix

· Costs & Margin

· Churn

· Documentation of the data model and measures.

· A short handover session for the internal team.

• 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, collaborate workplace in which you can learn, working for a rapidly growing, multi award-winning business in a sector that has never been more important.