ZOE
Commercial Finance Analyst (SQL/Data)
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
About the Team
Our Commercial Finance team is evolving from a traditional reporting and forecasting function into a data-driven strategic powerhouse. We’ve completely ditched the clunky, manual spreadsheets of the past for a warehouse-first approach.
Operating at the intersection of Finance and Data Analytics, we use a modern stack (BigQuery, dbt, and Hex) to find the "why" behind our numbers. If you believe finance should be a proactive strategic partner to the business rather than just a reporting function, you'll fit right in.
About the Role & Impact
As our new Commercial Finance Analyst, you’ll be the bridge between raw data, financial health, and commercial action.
This is not a traditional corporate finance role. You will spend your days writing SQL queries, building scalable data pipelines, and transforming raw operational data into live, automated financial models in our modern data stack. Reporting is simply our groundwork, not the goal. The critical part is using clean data to guide the decisions we make as a business.
What You Will Do
- Replace manual workbook legwork with robust SQL code, automating recurring financial tasks and reporting so our team can move at lightning speed.
- Own and continuously scale our forecasting models, relying on warehouse data to perform scenario analyses and stress-test strategic plans.
- Partner with Marketing, Ops, and Growth to analyze customer acquisition cost (CAC), lifetime value (LTV), payback periods, and cohort behavior.
- Translate complex data into clear, concise financial commentary to help non-technical stakeholders (Product Managers, Marketing Leads) make data-driven decisions.
- Act as the "voice of the data"—shaping commercial strategy by telling the real story behind our monthly operational performance.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Who you are
⚠️ This is a hybrid data-finance position. An Excel-only approach will not work in this role. We have a dedicated technical loop in our interview process to test SQL capabilities.
- Strong SQL Proficiency (Required): You must be comfortable writing complex SQL queries from scratch (CTEs, window functions, complex joins) to extract and manipulate large datasets from BigQuery.
- Core Finance/Accounting Fundamentals: You have a firm grasp of subscription metrics, unit economics, P&L modelling, and accounting fundamentals (e.g., handling accruals and deferred revenue recognition for multi-month memberships).
- A D2C / Subscription Enthusiast: You understand the unique mechanics of subscription models. You intuitively connect acquisition spend to retention curves, churn, and cohort behaviour.
- Modern Analytics Mindset: You are either already proficient in—or obsessed with mastering—data visualisation and transformation tools (e.g., dbt, Python, Hex) to move beyond static spreadsheets.
- An AI-Forward Operator: You actively leverage modern tools, including LLMs, to streamline workflows, debug queries, and automate the mundane so you can focus on high-value strategic analysis.
- A Storyteller of Complexity: You can take raw, messy transactional databases (like Stripe billing records) and synthesise them into clean financial narratives that make sense to non-finance partners.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Our Hiring Journey
We Value Your Time. We’ve Designed a Streamlined, 4-step Process To Get Us From "Hello" To "Welcome To The Team" As Quickly As Possible
- Intro chat with Talent Team (High-energy alignment check)
- Hiring Manager Interview (Tactical conversation focused on your craft)
- The Remote Loop (2 to 4 focused interviews assessing technical and collaboration skills)
- The Finish Line (Offer, equity/benefits breakdown, and onboarding)
Ready to thrive? Apply Now
If you are genuinely excited about ZOE's mission and this opportunity, please don't hesitate to apply—even if you don't meet every single requirement listed. We fundamentally value potential and commitment above all else.
ZOE is an equal opportunity employer. If you require any reasonable accommodations during the interview process, just let us know—we are here to support you.
Not the perfect match? Join ZOE's Talent Community!
If this role isn't the exact right fit, or the timing isn't right, don't let the journey end here. Drop your resume here. When a role opens up that matches your unique superpowers, you'll be the first person we reach out to.
Stay Curious. Follow the Journey.
Want To See Life Behind The Scenes, Our Latest Health Breakthroughs, And How We're Changing The World Through Food? Follow Us On Our Socials
LinkedIn | Instagram | TikTok | YouTube | Facebook
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location