Business Intelligence Analyst

RGIT Australia; Guiseley; On-site; GBP 40,000 - 60,000; Full time

Benefits offered by this job

25 days annual leave (+ Bank Holidays)

Holiday Purchase Scheme – Buy up to 5+

Health and Wellbeing programme

Cycle to Work Scheme

Job summary

United Gas & Power (UGP) is looking for a Business Intelligence Analyst to join the IT team at the Guiseley Head office in Leeds. You will champion Power BI across the business, transforming data into clear insights using Power BI, SQL and Excel.

You will lead the development of reporting and analytics, improving data quality, accessibility and consistency to support strategic decisions and operational performance.

Qualifications

• Advanced knowledge of Power BI, including DAX, Power Query and data modelling.
• Strong SQL skills for data extraction, manipulation and analysis.
• Proficiency in Excel for data analysis, reconciliation and reporting.
• Understanding of data analysis, visualization and BI principles.
• Ability to translate complex data into actionable business insights.
• Knowledge of data quality, governance and reporting best practices.
• Experience developing and maintaining Power BI reports and data models.
• Experience writing SQL queries for data analysis and reporting.
• Experience translating business requirements into BI solutions and KPIs.
• Experience presenting findings to non-technical audiences.

Responsibilities

• Develop and maintain Power BI reports, dashboards and data models that support business reporting and decision-making.
• Analyze data using SQL, Power BI and Excel to identify trends, patterns, opportunities and risks.
• Work closely with stakeholders to understand their business needs, challenges and objectives.
• Translate business requirements into effective BI solutions, meaningful KPIs and actionable insights.
• Determine the most appropriate data, analytical methods and BI approach for each business requirement.
• Conduct ad hoc analysis to investigate business and data issues, presenting clear findings and recommendations.
• Ensure data and reporting outputs are accurate, consistent, reliable and fit for purpose.
• Communicate complex data and insights clearly to both technical and non-technical audiences.
• Independently assess data, identify areas for improvement and recommend actions.
• Balance stakeholder needs, data availability and technical feasibility when designing BI solutions.
• Identify and escalate significant data-quality, reporting or business-impact risks as appropriate

Skills

Power BI

SQL

Excel

Data analysis

Data modelling

DAX

Governance

KPI development

Stakeholder communication

Education

Data Analytics / Computer Science / Business Analytics degree or equivalent

Tools

Microsoft Fabric

PySpark

Job description

Posted 11 Sep 2026

Description

As one of the fastest-growing and highest-rated commercial energy suppliers in the UK, we are looking to recruit a Business Intelligence Analyst to join our IT team, based at our Guiseley Head office in Leeds.

The successful candidate will champion the use of Power BI across the business, transforming complex data into clear, actionable insights using Power BI, SQL and Excel. Working closely with cross-functional teams and key stakeholders, they will understand business needs and translate them into effective dashboards, reports and self-service BI solutions.

The role will lead the development of our next generation of reporting and analytics, helping to improve data quality, accessibility and consistency across the organisation. By identifying key trends, opportunities and risks, the successful candidate will provide valuable insights that strengthen operational performance and support informed strategic decision-making.

UGP is an inclusive organisation, and we aim to attract people from diverse backgrounds. We welcome applications from everyone regardless of age, race, gender, religion or beliefs, disability, gender identity, or sexual orientation.

Responsibilities

• Develop and maintain Power BI reports, dashboards and data models that support business reporting and decision-making.
• Analyse data using SQL, Power BI and Excel to identify trends, patterns, opportunities and risks.
• Work closely with stakeholders to understand their business needs, challenges and objectives.
• Translate business requirements into effective BI solutions, meaningful KPIs and actionable insights.
• Determine the most appropriate data, analytical methods and BI approach for each business requirement.
• Conduct ad hoc analysis to investigate business and data issues, presenting clear findings and recommendations.
• Ensure data and reporting outputs are accurate, consistent, reliable and fit for purpose.
• Communicate complex data and insights clearly to both technical and non-technical audiences.
• Independently assess data, identify areas for improvement and recommend appropriate actions.
• Constructively challenge assumptions and reporting requirements when the data supports an alternative approach.
• Balance stakeholder needs, data availability and technical feasibility when designing BI solutions.
• Identify and escale significant data-quality, reporting or business-impact risks as appropriate

The Individual

Essential Knowledge and Skills

• Advanced knowledge of Power BI, including DAX, Power Query and data modelling.
• Strong SQL skills, with the ability to extract, manipulate and analyse data.
• Proficiency in Excel for data analysis, reconciliation and reporting.
• Sound understanding of data analysis, data visualisation and business intelligence principles.
• Ability to translate complex data into meaningful business insights that support informed decision-making.
• Good understanding of data quality, governance and reporting best practices.
• Proven experience developing and maintaining Power BI reports, dashboards and data models.
• Demonstrable experience writing SQL queries for data analysis and reporting.
• Experience using Excel to analyse, reconcile and report data.
• Experience gathering business requirements and translating them into effective BI solutions and meaningful KPIs.
• Experience analysing complex data to identify trends, issues, risks and actionable insights.
• Experience working with business stakeholders and presenting findings clearly to non-technical audiences.
• Experience collaborating effectively with data, technology and business teams.

Essential Qualifications

• A degree or equivalent qualification or experience in Data Analytics, Computer Science, Business Analytics, Information Technology or a related discipline.

Desirable Knowledge and Experience

• Knowledge of Microsoft Fabric, PySpark and modern data architecture.
• Power BI certification would be advantageous.
• Knowledge of Microsoft Fabric and modern data architecture would be advantageous.

Join the Team

• Excellent salary based on your experience
• 25 days annual leave (plus Bank Holidays)
• Holiday Purchase Scheme – Buy up to 5 additional days of leave per year
• Health and Wellbeing programme including GP consultations, Mental Health support and discounted gym memberships
• Ongoing training & guidance provided
• A great working environment with a real team spirit
• Company social events
• Cycle to Work Scheme

Company Overview

United Gas & Power (UGP), is a business energy supplier based in Yorkshire that truly puts customer service at the heart of its organisation. We supply businesses across the UK and handle the entire end-to-end switching process to make your switch as hassle free as possible.