At a Glance
- Tasks: Transform raw data into actionable financial insights using SQL and modern analytics tools.
- Company: Join a forward-thinking team at ZOE, revolutionising finance with data-driven strategies.
- Benefits: Enjoy a hybrid work model, competitive salary, and opportunities for professional growth.
- Other info: Streamlined hiring process and a supportive, inclusive company culture.
- Why this job: Be a key player in shaping commercial strategy and making impactful decisions.
- Qualifications: Strong SQL skills and a passion for data analytics in a finance context.
The predicted salary is between 45000 - 55000 £ per year.
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 behaviour.
- 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.
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.
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:
- Step 1: Intro chat with Talent Team (High-energy alignment check)
- Step 2: Hiring Manager Interview (Tactical conversation focused on your craft)
- Step 3: The Remote Loop (2 to 4 focused interviews assessing technical and collaboration skills)
- Step 4: 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
Commercial Finance Analyst (SQL/Data) employer: ZOE
As a Remote Lead Product Manager at our innovative company, you will thrive in a dynamic work culture that values creativity and collaboration. We offer competitive benefits, including flexible working hours and opportunities for professional development, ensuring you can grow your skills while making a meaningful impact on our members' lives. Join us in a role where your expertise will directly contribute to transforming nutritional science into accessible, life-changing habits for our community.
StudySmarter Expert Advice🤫
We think this is how you could land Commercial Finance Analyst (SQL/Data)
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like ZOE!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Commercial Finance Analyst (SQL/Data) at ZOE.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like ZOE.
✨Apply Directly through Our Website
When you find a suitable opening like Commercial Finance Analyst (SQL/Data) at ZOE, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Commercial Finance Analyst (SQL/Data)
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at ZOE, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at ZOE. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at ZOE
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at ZOE!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
