Commercial Analytics Manager

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

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.