At a Glance
- Tasks: Create impactful Power BI reports to analyse key business metrics.
- Company: Join a dynamic team in Holborn focused on data-driven decision making.
- Benefits: Competitive daily rate, flexible contract duration, and potential for extension.
- Why this job: Make a real difference by transforming data into actionable insights.
- Qualifications: Proven experience with Power BI, SQL, and DAX required.
- Other info: Fast-paced environment with opportunities for professional growth.
Contract: 4–8 weeks (possible extension)
Location: Holborn
Start Date: ASAP
Rate: £250 - £300 per day
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 will 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 Will 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.
- Ensure 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 Are 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
Interim Power BI Specialist in London employer: First Mile | Certified B Corp
Contact Detail:
First Mile | Certified B Corp Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Interim Power BI Specialist in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with Power BI or in finance. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio of your best Power BI reports and share them during interviews. This gives us a tangible way to see what you can do and how you approach data.
✨Tip Number 3
Prepare for the interview by brushing up on common questions related to SQL and DAX. We want to see how you think through problems, so be ready to explain your thought process clearly.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take that extra step.
We think you need these skills to ace Interim Power BI Specialist in London
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with Power BI, SQL, and DAX. We want to see how your skills match the specific needs of the role, so don’t hold back on showcasing relevant projects!
Showcase Your Achievements: When detailing your past work, focus on the impact you made. Did your reports help improve decision-making or save time? We love numbers, so include metrics that demonstrate your success in previous roles.
Keep It Clear and Concise: We appreciate clarity! Make sure your application is easy to read and straight to the point. Use bullet points for key achievements and keep paragraphs short. This helps us quickly see why you’re a great fit.
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it makes tracking your application super easy for both of us.
How to prepare for a job interview at First Mile | Certified B Corp
✨Know Your Power BI Inside Out
Make sure you brush up on your Power BI skills before the interview. Be ready to discuss your experience with building reports, especially focusing on key metrics like Sales, Volume, and Margin. Prepare to showcase specific examples of reports you've created and how they helped in decision-making.
✨SQL and DAX are Your Best Friends
Since the role requires strong SQL knowledge and DAX skills, be prepared to answer technical questions or even solve problems on the spot. Practise writing DAX measures and combining data from different sources, as this will likely come up during the interview.
✨Communicate Clearly
Good communication is key, especially since you'll be working with Finance and Commercial teams. Think about how you can explain complex data insights in a simple way. You might want to prepare a few scenarios where you successfully communicated findings to non-technical stakeholders.
✨Show Your Independence and Speed
This role demands quick delivery in a short timeframe, so be ready to discuss how you've managed tight deadlines in the past. Share examples of projects where you worked independently and delivered results efficiently, highlighting your ability to prioritise tasks effectively.