Commercial Analytics Manager

Octopus Energy

Greater London

Hybrid

GBP 55,000 - 75,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

UK perks hub

Job summary

Octopus Energy is seeking a Finance/Data Analyst to oversee portfolio level reporting, forecast management, and margin analysis. You will join a data-driven team, translating complex commercial data into actionable insights that guide pricing and cost strategies.

You'll automate forecasting tools with Python and SQL, consolidate variance analysis, and present clear narratives to senior stakeholders. This role blends finance and analytics in a fast-growing energy business with strong emphasis on

Qualifications

  • Strong SQL to extract, manipulate, and transform complex commercial data.
  • Experience using Python for data analysis, automation, or financial modeling.
  • Minimum of 3 years using data and coding to solve commercial, pricing, or financial problems.
  • Proven ability to untangle legacy spreadsheet processes and replace them with automated solutions.
  • Strong financial acumen, particularly with margins reporting, forecasting, and variance analysis.
  • Ability to summarise complex findings into clear narratives for senior non-technical stakeholders.

Responsibilities

  • Provide consistent portfolio level reporting for OEB to determine overall net margins.
  • Lead development and management of the company’s forecast, ensuring accuracy and alignment with strategic goals.
  • Interrogate the cost stack to influence pricing decisions.
  • Develop margin optimisation strategies including pricing adjustments and cost reductions.
  • Improve accuracy of gross margin calculations with Finance and Pricing teams.
  • Lead meetings with senior management to present clear options for decisions.
  • Work with pricing to influence tariff decisions and margins.
  • Provide monthly reporting packs to monitor performance and variances.
  • Gather inputs for accurate forecasting from business units.
  • Improve forecasting tools by moving from spreadsheets to Python and SQL-based analysis.
  • Compare forecasts with monthly actuals and investigate variances across the book.

Skills

SQL proficiency
Python for data analysis
Data storytelling
Forecasting & variance analysis
Financial acumen

Tools

SQL
Python

Job description

What you'll do
  • Provide consistent portfolio level reporting for OEB to determine overall net margins. This will include revenue, cost of sales, debt and operational expenditure.
  • Lead the development and management of the company’s forecast, ensuring accuracy and alignment with strategic goals.
  • Work with the team to interrogate the entire cost stack to influence pricing decisions.
  • Develop margin optimisation strategies, including pricing adjustments, cost reductions, and process improvements.
  • Improve accuracy of gross margin calculations in partnership with Finance and Pricing teams.
  • Lead meetings with colleagues and senior management to provide clear options in the decision making process.
  • Work closely with the pricing team to influence key decisions to ensure we provide customers with a wide range of tariffs which are set with a conscious view of outturned margins.
  • Provide monthly reporting packs to monitor different aspects of performance including budgets and variance analysis.
  • Work closely with business units to gather key inputs and assumptions for accurate forecasting.
  • Improve the tools behind our forecasting, moving away from spreadsheet-heavy processes towards Python and SQL-based analysis.
  • Compare forecasts with monthly actuals and thoroughly investigate variances across the business's book.
What you'll need
  • Strong proficiency in SQL to extract, manipulate, and transform complex commercial data.
  • Experience using Python for data analysis, automation, or financial modeling.
  • A minimum of 3 years experience of using data and coding to solve commercial, pricing, or financial problems.
  • A proven track record of untangling complex, legacy spreadsheet processes and replacing them with streamlined, automated solutions.
  • Strong financial acumen, particularly with reporting margins, forecasting, and variance analysis.
  • The ability to bridge the gap between commercial finance and data analytics, summarising complex findings into clear narratives for senior, non-technical stakeholders.
  • A self-starter mentality with the confidence to take ownership of a growing area, solve complex problems, and constantly introduce new processes.
  • Ideally, previous financial, commercial, or pricing experience within the energy industry (considered a strong bonus, though we are open to exceptional data-driven candidates from other sectors).

Why else you'll love it here

  • Wondering what the salary for this role is? Once you're in the interview process with one of our recruiters, it's something we always cover as we genuinely want to match your experience with the correct salary. The reason why we don't advertise is because we honestly have a degree of flexibility and would never want salary to be a reason why someone doesn't apply to Octopus - what's more important to us is finding the right octofit!
  • Octopus Energy Group is aunique culture. An organisation where people learn, decide, and build quicker. Where people work with autonomy, alongside a wide range of amazing co-owners, on projects that break new ground. We want your hard work to be rewarded with perks you actually care about! We were named the UK's top company to work for in 2025, and we ranked in the top ten in the Sunday Times Best Places to Work 2026. Our Group CEO, Greg has recordeda podcast about our cultureand how we empower our people. We’ve also been placed in thetop 10 companies for senior leadership
  • Visit our UK perks hub -Octopus Employee Benefits

Are you ready for a career with us? We want to ensure you have all the tools and environment you need to unleash your potential. Need any specific accommodations? Whether you require specific accommodations or have a unique preference, let us know, and we'll do what we can to customise your interview process for comfort and maximum magic!

Studies have shown that some groups of people, like women, are less likely to apply to a role unless they meet 100% of the job requirements.

Across Octopus, we're looking for genuinely decent people who are honest and empathetic. Our people are our strongest asset and the unique skills and perspectives people bring to the team are the driving force of our success. As an equal opportunity employer, we do not discriminate on the basis of any protected attribute. Our commitment is to provide equal opportunities, an inclusive work environment, and fairness for everyone.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Commercial Analytics Manager
Commercial Analytics Manager

Octopus Energy Group • Greater London

On-site
GBP 70,000 - 110,000
Octopus Employee Benefits
Staff Data Analyst - Commercial
Staff Data Analyst - Commercial

Octopus Energy Group • Greater London

On-site
GBP 90,000 - 120,000
Head of Commercial Analytics
Head of Commercial Analytics

octoenergy • Greater London

On-site
GBP 90,000 - 120,000
Staff Data Analyst - Commercial
Staff Data Analyst - Commercial

Data Co Lab X • Greater London

On-site
GBP 90,000 - 120,000
Head of Commercial Analytics
Head of Commercial Analytics

Octopus Energy • Greater London

On-site
GBP 110,000 - 160,000
Octopus Employee Benefits
Commercial Analytics Leader — UK & Global
Commercial Analytics Leader — UK & Global

Octopus Energy • Greater London

On-site
GBP 110,000 - 160,000
Octopus Employee Benefits
Group Strategic Finance Analyst
Group Strategic Finance Analyst

Octopus Energy Group • Greater London

On-site
GBP 60,000 - 90,000
Management Accountant
Management Accountant

Octopus Energy Group • Greater London

On-site
GBP 65,000 - 90,000
Commercial Manager
Commercial Manager

Octopus Energy Group • Greater London

On-site
GBP 60,000 - 95,000
Junior Management Accountant (12 month FTC)
Junior Management Accountant (12 month FTC)

Octopus Energy Group • City Of London

Hybrid
GBP 28,000 - 36,000