Capital Markets Operations Analyst
At a glance
Mid-level Investment & Corporate Development role at Octopus Energy Group. London · full-time · no salary stated · we estimate £52,500–£129,465.
Octopus Energy Group has not published a salary for this role. The figure below is our estimate, not theirs.
financeroles summary, based on the employer's posting.
What you'll do
- Build investor reports, facility-use tracking and loan-level data files, keeping each funding deliverable accurate and consistent
- Run recurring reports and cash sweeps, checking rental fees, termination amounts and buyback settlements
- Track lease-end events, defaults and buybacks to show reserve assets and borrowing capacity
- Check facility covenants and performance triggers, escalating possible breaches to the Capital Markets team
- Reconcile loan records against facility summaries, answer audit requests and improve SQL and Python workflows
What you bring
- A finance, economics, maths or related degree, plus one to three years in finance or large-scale data work
- Hands-on experience maintaining spreadsheet trackers and reconciliations, with checks that catch errors before reports go out
- Proof you can produce a complete reporting deliverable from raw data through to final output
- Working SQL skills to read, troubleshoot and change existing queries
Who this fits
This hands-on operations role suits someone who enjoys accurate recurring reporting and cash processes, then improving how that work gets done. You’ll work with Finance, Data and Operations and need to explain figures and raise issues with internal stakeholders. The role is based in London and requires at least two days a week in the office.
From the employer
We are a market-leading, mission-driven organisation focused on accelerating the transition to a net-zero economy through innovative financing solutions. As we enter a significant period of growth, we are recruiting for a key role within our Capital Markets operations team to support our increasingly sophisticated funding requirements.
You'll own the reporting and data behind our securitisation and warehouse funding lines. You'll produce investor reports from loan-level data tapes, run reconciliations and cash sweeps, and use SQL to improve and automate how we work. You won't just be checking data; you'll be the one directly producing the reports and deliverables that keep the capital behind a rapidly expanding leasing business flowing.
This is a hands-on data operations role, not an analytics or deal execution role. Around two-thirds of the role is owning recurring reporting and cash processes to a high standard of accuracy; the rest is making those processes better.
This role requires a minimum of two days per week in our London office.
What you'll do
-
Securitisation & Investor Reporting
-
Own the end-to-end production of investor reports, facility utilisation tracking, and loan-level data tapes - you build these reports directly, not just support them - ensuring high accuracy and consistency across all deliverables
-
Fund Sweep & Cash Operations
-
Facilitate facility cash sweeps by validating rental fees, termination totals, and buyback settlements across securitisation structures.
-
Portfolio & Asset Tracking
-
Maintain asset lifecycle trackers (e.g. end-of-lease, defaults, and buybacks) to provide real-time visibility over reserve assets and borrowing base capacity.
-
Covenant & Trigger Monitoring
-
Monitor transaction covenants and performance triggers across securitisation facilities, flagging potential breaches to the wider Capital Markets team.
-
Audit & Reconciliation
-
Run reconciliations between granular loan-level data tapes and facility summary reports, and prepare materials for investor audit requests, identifying and resolving discrepancies yourself.
-
Process & Data Optimisation
-
Process improvement and automation: maintain and improve our SQL/Python and Databricks workflows - fix issues, add automated checks and remove manual steps - working with Finance, Data and Operations teams.
In this role, you will own the team's recurring reporting and cash processes: a weekly sell-in report, monthly utilisation and servicing reports, end-of-lease and ineligible buyouts, and rental and early termination fee sweeps. You will also help keep our funding facilities running accurately and on schedule.
What you'll need...
-
A degree in Finance, Economics, Maths or a related discipline, plus 1 - 3 years of work or internship experience in finance, or in a role that involved working with large, complex datasets (tens of thousands of rows or more). You don't need a Capital Markets background specifically, but you do need real reps with numbers at scale.
-
Experience maintaining or auditing spreadsheet-based trackers and reconciliations to a solid working level. You understand how a single input error can propagate through a report, and you build in the checks to catch it before it ships.
-
A demonstrated ability to take ownership of a reporting deliverable start to finish, not just review or QA someone else's output. Even at a smaller scale, you've taken a dataset or report from raw numbers to a complete, accurate document on your own.
-
Working SQL: you can read, debug and modify existing queries.
-
A self-driven problem-solving mindset, with a genuine willingness to learn unfamiliar financial structures quickly and go talk to the right person across the business when something doesn't reconcile.
-
Clear written and verbal communication, comfortable explaining numbers and flagging issues to internal stakeholders.
-
Nice to have: Python (pandas), and exposure to lending, leasing, auto finance or securitisation reporting.
-
Genuine motivation to apply your financial and technical skillset to a business funding the transition to electric vehicles. The reports you produce are part of how that capital actually gets managed.
💚 Why else you'll love it here
- 💰 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. 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
- P.s. 🐶 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
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.