Senior Commercial Finance Analyst - Ad Waterfall
At a glance
Senior FP&A role at Future Publishing. Bath · £34,000–£42,000 base.
financeroles summary, based on the employer's posting.
What you'll do
- Maintain the Advertising Waterfall model to follow impressions, pricing yields, and digital revenue movement
- Compare month-end results with forecasts and last year, including performance across geographic brands
- Work with Ad Operations and BI to assess inventory capacity and find revenue opportunities
- Help build annual budgets, quarterly forecasts, and updated financial estimates
- Review Display Advertising revenue and cost of sales in month-end accounts
What you bring
- Commercial finance experience, including analysis of revenue, costs, or audience measures
- Experience modelling finances or handling complex data in Excel or Google Sheets
- An accounting qualification in progress or completed, or equivalent hands-on experience
- Practical knowledge of forecasting, budgeting, or month-end reporting
Who this fits
This role suits a senior analyst who enjoys commercial modelling, detailed data analysis, and working with finance and operational teams. It is hybrid, with two days per week at the Bath office.
From the employer
Who we are
We create trusted, expert content that helps millions of people discover more about the things they love, need and care about. From technology, gaming and entertainment to fashion, lifestyle, sport, finance and beyond, our specialist brands connect people with their passions every day.
Across websites, magazines, newsletters, social channels and events, we bring expert content to audiences around the world. We combine our deep specialist knowledge with innovative technology and data to create engaging experiences, build valuable communities and help people make better-informed decisions.
Behind it all are our people - passionate experts, creators, innovators and problem-solvers who are shaping the future of media.
The Team You'll Join
Our Commercial Finance team in Bath acts as an essential partner supporting Future's digital content monetization across iconic global brands. Based in our Bath head office on a hybrid basis (2–3 days per week), we translate complex operational data into actionable insights that guide commercial strategy. You'll join an agile, data-focused team working closely with Ad Operations, Programmatic, and Yield leadership. This role offers an exciting opportunity to shape revenue analysis, optimize inventory yield, and support sustainable commercial growth across global media titles.
What you'll do
Reporting to the Senior Commercial Finance Manager in Bath, you'll manage the Advertising Waterfall model to analyse how Future monetizes digital content. You'll work closely with the VP for Ad Operations, Programmatic & Yield, alongside Business Intelligence and Management Accounts teams. In this role, you'll evaluate impression volumes, pricing yields, and audience metrics across UK and US markets to identify revenue opportunities.
On a daily basis, you'll build and update financial models in Google Sheets and Excel to evaluate Display Advertising revenue and cost of sales. You'll prepare month-end performance summaries, support annual budgeting cycles, and collaborate with BI teams to enhance data reporting. Additionally, you'll act as a trusted finance partner, providing commercial guidance to operational teams across the business.
- Manage and update the Advertising Waterfall model to track impression volumes, pricing yields, and digital revenue trends.
- Prepare month-end financial analysis comparing actual performance against forecasts, prior year results, and geographic brands.
- Partner with Ad Operations and BI teams to evaluate inventory capacity and uncover new monetization opportunities.
- Support the production of annual budgets, quarterly forecasts, and ongoing financial estimates.
- Review month-end management accounts covering Display Advertising revenue and associated cost of sales.
- Collaborate across Finance and operational teams to evaluate risks, opportunities, and reporting accuracy.
What you’ll bring
- Demonstrable experience in commercial finance, financial modelling, or data analysis within a commercial environment.
- Full qualification or active progress toward an accounting qualification (ACA, CIMA, ACCA) or equivalent practical experience.
- Proficiency in managing large data sets and building financial models using Google Sheets or Excel.
- Strong analytical skills with the ability to identify data discrepancies and resolve operational queries.
- Collaborative communication skills with a proven ability to build positive relationships across cross-functional teams.
- A curious approach to financial analysis with a desire to evaluate business performance trends.
Minimum Requirements
- Commercial finance experience or background analysing revenue, cost, or audience metrics.
- Experience building financial models or working with complex data sets in Excel or Google Sheets.
- Ability to collaborate with cross-functional stakeholders from our Bath head office on a hybrid basis (2–3 days per week).
- Practical understanding of forecasting, budgeting, or month-end reporting processes.
What we offer
- Uncapped leave
- Enhanced parental leave
- Discounted rates with Dental care and Private Medical care
- When we hit our targets, enjoy a share of our profits with a bonus
- Refer a friend scheme - with payment following the successful hire.
- Well-being support with access to our Colleague Assistant Programmes
- Opportunity to purchase shares in Future, with our Share Incentive Plan
- Salary sacrifice Pension scheme up to 5% match
- Free drinks and snacks in our offices
The expected range for this role is £34,000 - £42,000
This is a hybrid role, working 2 days per week from our Bath Office.
Internal job family level P6
Inclusion and Diversity at Future
At Future, we’re working to attract, retain and foster diverse talent, educating our colleagues in the importance of diversity, and review our internal processes so that they remain as free from bias as possible. We recognise that, in order to reach diverse communities through our content, we must first ensure ours is a culture in which diversity can thrive.
Find out more about Our Future, Our Responsibility on our website.
If you need any reasonable adjustments, please let us know, and we'll be happy to support you.