Fractional Executive Opportunity

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.

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.

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.