FP&A Analyst

Octopus Energy

FP&A Analyst analyzing financial data to support electric vehicle leasing growth at Octopus. Collaborating across teams to enhance cash flow forecasting and performance reporting.

Posted 7/22/2026full-timeLondon • 🇬🇧 United KingdomJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong financial analysis capabilities with expertise in SQL and Excel, ensuring accurate cash flow forecasting and data integrity. Effectively communicates financial insights to non-technical stakeholders while collaborating with cross-functional teams to enhance data infrastructure.

Highest-signal resume keywords

SQL Query WritingFinancial Planning & Analysis (FP&A)Data Visualization Tools (Power BI, Looker)Expert-Level Excel SkillsUnderstanding of P&L, Balance Sheet, and Cash Flow

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Cash Flow ForecastingData Analysis3-Statement ModellingFinancial ModellingVariance Analysis

Soft Skills

High Accuracy OrientationClear Communication

Tools & Technologies

DatabricksPower BILookerGoogle Sheets

Certifications & Qualifications

ACCACIMAACA

Industry Keywords

Commercial FinanceData AnalyticsFinancial AnalysisClimate Change

Tech Stack

Tools & technologies

PythonSQL

About the role

Key responsibilities & impact

Maintain and update short-term and long-term cash flow forecasts (3-statement modelling), monitoring cash positions across various funding facilities and operational activities.
Write, maintain, and optimise SQL queries in Databricks to extract and transform data from large operational datasets. You will be the first line of defence for data quality, identifying anomalies and documenting issues with clear business context.
Track actual performance against budget, analyse variances, and identify key drivers. You will develop and maintain FP&A dashboards ensuring they remain accurate and fit-for-purpose.
Produce ad hoc financial analysis for the CFO and teams across the business—including Strategy, Procurement, and Operations—connecting numbers to commercial outcomes.
Partner with Tech and Product teams to ensure data infrastructure is fit for the FP&A function, translating finance requirements into clear briefs to improve forecasting accuracy and scalability.

Requirements

What you’ll need

1-2 years of experience in FP&A, commercial finance, data analytics, or a similar analytical role (Part-qualified or studying towards ACCA, CIMA, or ACA is a bonus).
Strong SQL skills (you write queries confidently) and expert-level Excel / Google Sheets skills (you can build robust, auditable models from scratch). Exposure to data visualisation tools (Databricks, Power BI, Looker) or Python is a plus.
High accuracy orientation. You notice when something doesn't add up and you don't move on until you understand why. You also possess a solid understanding of how the P&L, balance sheet, and cash flow relate to each other.
You are comfortable working with imperfect data. You can size the materiality of a data problem and communicate it clearly rather than ignoring it or being paralysed by it.
Clear written and verbal communication, particularly when explaining data limitations or financial assumptions to non-technical stakeholders.
Be genuinely motivated to apply your financial and technical skillset to play an important role in the FP&A team and help drive a business tackling climate change.

Benefits

Comp & perks

💰 Wondering what the salary for this role is? Just ask us! On a call 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! 🎁 Visit our perks hub - Octopus Employee Benefits
🏆 Octopus Electric Vehicles, part of the Octopus Energy Group, won the Sunday Times best company to work for in 2024, 2025 and 2026. We were named 6th out of the top 100 start-ups to work for by Tempo in 2025 and on Glassdoor we were voted 50 best places to work in 2022. 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
🐶 *Just to let you know, we are dog friendly company so you may see our 4 legged friends in the offices - feel free to bring yours! Rest assured though, we've taken lots of precautions for those who have allergies*