Commercial Lead Data Analyst

SSE Airtricity; Belfast City District; Hybrid; GBP 50,000 - 75,000; Full time

Benefits offered by this job

Private healthcare

Gym membership

Online GP

Counselling service

Cycle to Work

Maternity/Adoption pay

Paternity leave

Job summary

SSE Airtricity is seeking a Lead Data Analyst to strengthen pricing foundations by building models, dashboards and data-driven insights. You will work across pricing, profitability and forecasting to support informed commercial decisions.

In this role you will automate manual processes, improve reporting and create scalable data workflows using tools like Python, SQL and Databricks, with a focus on delivering concise, actionable insights for the Pricing team.

Qualifications

• Strong numerical and analytical thinking with complex data and commercial assumptions.
• Advanced Excel skills and experience with Power BI dashboards.
• Familiarity with Python, Databricks, SQL or similar tools for large data sets.

Responsibilities

• Build, maintain and improve pricing, profitability and forecasting models across the Commercial team.
• Develop tools, dashboards and reports to visualize pricing performance, margin and trends.
• Transform raw data into structured, analysis-ready datasets for pricing decisions.
• Make complex calculations, reports and models easier to understand and reuse.
• Collaborate with IT, data and business units to improve data sourcing and governance.

Skills

Advanced Excel

Power BI

Python

Databricks

SQL

Numerical reasoning

Communication

Tools

Excel

Job description

Base Location: You'll be expected to spend 50% of your working week in either our Dublin or Belfast office

Salary: €65,300 - €97,900 (ROI) or £50,100 - £75,100 (NI) + performance-related bonus + a range of benefits to support your finances, wellbeing and family.

Working Pattern: Permanent | Full Time | Flexible First options available

The role

Our Commercial function helps SSE Airtricity make better pricing decisions across our electricity and gas customer portfolios. We do this by building strong commercial models, reliable reporting, clear business processes and insight that helps the business understand what is driving performance.

As a Lead Data Analyst, you will play a key role in improving the tools, models and processes used by the Pricing teams within the Commercial function. This is a role for someone who enjoys solving business problems with data; building models, improving reporting, automating manual processes and turning complex information into clear, useful insight.

Rather than focusing only on day-to-day pricing activity, this role will help strengthen the foundations that pricing decisions are built on. You will work across areas such as customer profitability, pricing models, wholesale cost inputs, demand data, contract performance, margin reporting and scenario analysis.

A typical project could involve building a new pricing model in Excel or Python, creating a Power BI dashboard for the wider team, improving how data flows into a pricing process utilising tools such as Databricks, or helping automate a manual reporting process that currently takes too much time.

You will

• Build, improve and maintain pricing, profitability and forecasting models used across the Commercial team to support repeatable business processes
• Develop tools, dashboards and reports to give clearer visibility of pricing performance, margin, risk and commercial trends, to help Pricing colleagues make faster, clearer and better-evidenced decisions
• Work with large volumes of customer, contract, consumption, pricing and market data, turning raw information into structured, analysis-ready datasets
• Support the wider pricing team by making complex calculations, reports and models easier to understand, use and maintain
• Work with IT, data and business colleagues to improve how data is sourced, structured, governed and used in commercial decision-making

You have

• Strong numerical reasoning and the ability to work confidently with complex data, calculations and commercial assumptions, in order to break down complex issues and build practical solutions
• Advanced Excel skills and experience using Power BI to create dashboards, visualise performance and communicate insight
• Familiarity with Python, Databricks, SQL or similar tools, particularly when used to handle large volumes of data
• Strong communication skills, with the ability to explain technical work in plain English and articulate the value of what you have built

About SSE

SSE’s purpose is to be restless every day until we make electricity clean, affordable and available for all.

We do this by developing, building, operating and investing in electricity infrastructure and businesses needed in the energy transition. This includes electricity transmission and distribution networks, onshore and offshore wind farms, hydro-electric power and flexible thermal generation. We also provide products and services for businesses and other customers.

Our investment plan will see SSE invest £33bn in critical electricity infrastructure to 2030.

With over 725,000 electricity and gas customers across the island of Ireland, SSE Airtricity helps homes and businesses play their part in the clean energy transition. We're more than just an energy provider, delivering energy saving services to homes and businesses, help them become more efficient and cost-effective.

Flexible Benefits To Fit Your Lif

Enjoy discounts on private healthcare and gym memberships. Wellbeing benefits like a free online GP and 24/7 counselling service. Interest-free loans on tech and transport season tickets, or a new bike with our Cycle to Work scheme. As well as generous family entitlements such as maternity and adoption pay, and paternity leave.

Work with an equal opportunity employer

SSE will make any reasonable adjustments you need to ensure that your application and experience with us is positive. Please contact Andy on [e-mail] / 01738 340826 to discuss how we can support you.

We're dedicated to fostering an open and inclusive workplace where people from all backgrounds can thrive. We create equal opportunities for everyone to succeed and especially welcome applications from those who may not be well represented in our workforce or industry.