Back to jobs

Commercial Analytics Manager

Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: onsite
From the employer’s posting
Employment
Not stated

What you’ll work on

Full posting

We’re seeking a highly skilled and data-driven Commercial Analytics Manager to modernise how we track and forecast our financial performance.

  • Lead the company's forecast and replace spreadsheet processes with SQL and Python

  • Report portfolio net margins covering revenue, cost of sales, debt and opex

  • Compare forecasts with monthly actuals and investigate variances

  • Support pricing decisions by interrogating the entire cost stack

  • Develop margin optimisation strategies on pricing, costs and processes

From the employer’s posting
We’re seeking a highly skilled and data-driven Commercial Analytics Manager to modernise how we track and forecast our financial performance. In this role, you’ll take ownership of our business forecasting processes and lead the transition away from legacy, multi-tab spreadsheets. By leveraging modern data tools, you will build robust, automated pipelines to analyse margins, investigate variances, and provide actionable insights that optimise OEB's financial performance. You’ll collaborate closely with our Data team, finance teams, and senior leadership to ensure our financial strategies align with the company's sustainable growth objectives.
Lead the development and management of the company’s forecast, ensuring accuracy and alignment with strategic goals.
Provide consistent portfolio level reporting for OEB to determine overall net margins.
Compare forecasts with monthly actuals and thoroughly investigate variances across the business's book.
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.

What you’ll bring

All qualifications

Core experience

  • Strong proficiency in SQL to extract, manipulate, and transform complex commercial data.
  • Experience using Python for data analysis, automation, or financial modeling.
Qualification wording
Strong proficiency in SQL to extract, manipulate, and transform complex commercial data.
Experience using Python for data analysis, automation, or financial modeling.

About Octoenergy

Octopus Energy for Business (OEB) is a rapidly scaling energy supplier with more than 130k business customers.

In the employer’s words · Read in context

Apply at Octoenergy

Posting record

Report an error

Actively hiringFirst seen by us 10 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 11, 202610 days ago
Recorded sightings
12
Last seen by us
Nov 22, 2026
Employer says posted
Nov 4, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 10

Similar jobs usually come down between day 5 and day 43.

At Octoenergy, jobs usually come down by about day 32.

From 16,009 similar postings that came down, and 21 of Octoenergy’s. Coming down is not always a hire.

Octoenergy is hiring

5 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring has slowed
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
Where the posting names them
- 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.
- 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.
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.

Your next step

Complete your application on jobs.lever.co. The employer’s form will show what is required.

Applying through Lever

  • No account needed: one form, and Lever reads your resume into the profile recruiters search.

Already applied? Track this application

Job description

View original posting ↗

About Octopus Energy for Business

Octopus Energy for Business (OEB) is a rapidly scaling energy supplier with more than 130k business customers. We aim to accelerate the business sector’s transition to net zero whilst providing low-cost energy that meets the needs of our customers.

We’ve pioneered PPA-backed supply for mid-market businesses through Electric Match, led the way for SME smart tariffs with Shape Shifters and are the established market leader for enabling EV public charging through energy supply and services.

 

About the role

We’re seeking a highly skilled and data-driven Commercial Analytics Manager to modernise how we track and forecast our financial performance. In this role, you’ll take ownership of our business forecasting processes and lead the transition away from legacy, multi-tab spreadsheets. By leveraging modern data tools, you will build robust, automated pipelines to analyse margins, investigate variances, and provide actionable insights that optimise OEB's financial performance. You’ll collaborate closely with our Data team, finance teams, and senior leadership to ensure our financial strategies align with the company's sustainable growth objectives.

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 a unique 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 recorded a podcast about our culture and how we empower our people. We’ve also been placed in the top 10 companies for senior leadership
• Visit our UK perks hub - Octopus Employee Benefits
 
If this sounds like you then we'd love to hear from you, tell us what you care about, why Octopus feels right and most importantly, bring us the real you! Applying for jobs can be a bit scary so have a nose through some of our tips first 🚀
 
P.S. Our process usually takes up to 4 weeks, but we’ll always do our best to flex around what works for you. Along the way, you’ll chat with our recruitment team and your Recruiter will help you throughout different stages. Got any burning questions before then? Drop us a message at talent@octoenergy.com and we’d love to help!
 
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. Whoever you are, if you like one of our jobs, we encourage you to apply as you might just be the candidate we hire. 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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

London (GB)

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.