Power BI & Data Analytics Specialist - #2198443
Vallum Associates
Power BI & Data Analytics Specialist
Location: Leeds (Hybrid)
Salary: £50,000 - £55,000 + Benefits
Employment: Permanent, Full-Time
Are you someone who genuinely knows their way around Power BI, SQL and data modelling?
I'm working with a growing business in the energy sector that's looking for a technically strong Power BI & Data Analytics Specialist to help shape how data is structured, analysed and used across the organisation.
This isn't simply a role where you'll be producing reports from existing dashboards.
You'll be getting hands-on with the data itself, developing reporting solutions from scratch, building meaningful data models and working with different departments to help them make better commercial and operational decisions.
The business is investing in its next generation of reporting and analytics, so there's a real opportunity to influence how Business Intelligence is used across the company.
What you'll be doing
- Developing and maintaining Power BI dashboards, reports and underlying data models.
- Writing SQL queries to extract, transform and analyse complex datasets.
- Using DAX and Power Query to build effective, scalable reporting solutions.
- Designing and working with Star Schema data models, including fact and dimension tables.
- Working closely with stakeholders across different departments to understand their reporting needs and translate these into practical solutions.
- Improving data quality, reporting accuracy and consistency.
- Turning complex information into clear, actionable insights that support business decisions.
What we're looking for
Power BI - Essential
- Advanced hands-on Power BI development experience.
- Strong understanding of DAX, including calculated columns, measures and their appropriate use.
- Experience with Power Query, data transformations and relationships between datasets.
- Understanding of Import and DirectQuery modes and when to use them.
SQL & Data Modelling - Essential
- Confident writing SQL queries independently, including joins, aggregations and more complex data manipulation.
- Practical understanding of Star Schema modelling and its application to BI solutions.
- Experience structuring, cleaning and preparing data for reporting.
Business & Stakeholder Engagement
- Ability to gather requirements from non-technical stakeholders and translate them into reporting solutions.
- Experience developing KPIs, identifying trends and presenting meaningful business insights.
- Strong Excel capabilities and an understanding of data quality and governance.
Nice to have
- Experience with Microsoft Fabric, PySpark or modern data architecture.
- Power BI certifications.
- Previous experience in energy, utilities or another data-intensive commercial environment.
What's on offer?
- £50,000 - £55,000 basic salary.
- Hybrid working in Leeds.
- 25 days' annual leave plus bank holidays.
- Health and wellbeing benefits.
- Ongoing professional development and training.
- An opportunity to help shape the future of reporting and analytics within a growing organisation.
Interested?
If you're a Power BI Developer, BI Analyst, Data Analyst or Reporting Specialist who enjoys getting into the technical detail, I'd be keen to have a conversation.
You don't necessarily need energy-sector experience. What matters most is your technical ability, curiosity and confidence in building BI solutions that genuinely make a difference.
Drop me a message or get in touch for a confidential conversation.
Daniel Martin
Associate Director - Energy & Utilities
Vallum Associates
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Housekeeping Attendant - Casual
Assistant Merchandiser
Wealth Manager