Power BI & Data Analytics Specialist

Vallum Associates

Leeds

Hybrid

GBP 45,000 - 65,000

Full time

18 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health and wellbeing benefits
Hybrid working in Leeds
20–25 days annual leave? (not standard
Professional development and training

Job summary

Vallum Associates is seeking a Power BI & Data Analytics Specialist to shape how data is structured, analysed and used across the organisation. You will work hands-on with data, develop reporting solutions from scratch and build meaningful data models to support commercial and operational decisions.

The role goes beyond producing dashboards, as you’ll influence BI usage across the company and collaborate with multiple departments to deliver practical, data-driven insights.

Qualifications

  • Advanced hands-on Power BI development.
  • Strong understanding of DAX, including calculated columns and measures.
  • Experience with Power Query, data transformations and relationships between datasets.
  • Understanding of Import and DirectQuery modes and when to use them.
  • Independent SQL writing, including joins and aggregations.
  • Star Schema modelling and its application to BI solutions.
  • Experience structuring, cleaning and preparing data for reporting.

Responsibilities

  • 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 to understand reporting needs and translate into practical solutions.
  • Improving data quality, reporting accuracy and consistency.
  • Turning complex information into clear, actionable insights that support business decisions.

Skills

Advanced BI development
DAX calculations
SQL querying
Data modelling
Stakeholder engagement
Data cleaning
Requirements gathering

Tools

Power BI
Power Query
DAX
SQL
Excel
Microsoft Fabric

Job description

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Specialist
Business Intelligence Specialist

MSA Data Analytics Ltd • Birmingham

Hybrid
GBP 45,000 - 60,000
Profit-related pay
Life insurance
Flexible working arrangements
Senior BI Developer - Power BI
Senior BI Developer - Power BI

Chapman Tate Associates • Wolverhampton

Hybrid
GBP 60,000 - 80,000
Power BI Developer
Power BI Developer

Harnham • Liverpool

Hybrid
GBP 64,575 - 73,800
Business Intelligence Developer - Power BI Specialist
Business Intelligence Developer - Power BI Specialist

Michael Page • Milton Keynes

On-site
GBP 60,000 - 65,000
Comprehensive pension scheme
Professional work environment
Opportunities for career development
Business Intelligence Developer
Business Intelligence Developer

Harnham • Greater London

Hybrid
GBP 41,000 - 50,000
Hybrid working
One day a week in London office
Career development
+1
BI Developer
BI Developer

Harnham • Sheffield

On-site
GBP 50,000 - 60,000
Stakeholder exposure
Career development
Investment in analytics
+1
Power BI Developer for Data & Cloud Transformation
Power BI Developer for Data & Cloud Transformation

TrustTech Recruitment • Chester

On-site
GBP 55,000 - 75,000
Staff BI Data Engineer | Databricks & Power BI
Staff BI Data Engineer | Databricks & Power BI

Datatech Analytics • Stanford Dingley

On-site
GBP 70,000 - 100,000
Power BI Consultant
Power BI Consultant

Hackajob Ltd • Belfast City District

Remote
GBP 61,000 - 101,000
Flexible/remote working
Career progression
Mentorship
+2
Power BI Developer
Power BI Developer

Synergy Resourcing Solutions, Company • Ipswich

Hybrid
GBP 42,000 - 52,000