Senior Commercial Finance Analyst - Ad Waterfall

Future Publishing Limited; Bath; Hybrid; GBP 34,000 - 42,000; Full time

Benefits offered by this job

Uncapped leave

Enhanced parental leave

Private medical care

Share of profits with bonus

Refer a friend scheme

Colleague Assistant Programmes

Share Incentive Plan

Pension scheme

Free drinks and snacks

Job summary

Future Publishing Limited in Bath is seeking a Commercial Finance Analyst to join a hybrid team supporting digital content monetization across global brands. You will translate complex operational data into actionable insights, build financial models in Google Sheets and Excel, and partner with Ad Operations, Programmatic & Yield leadership.

You should have commercial finance experience, progress toward ACA/CIMA/ACCA, and strong data skills to analyse revenue, prices, and audience metrics across

Qualifications

• Experience in commercial finance or data analysis in 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.

Responsibilities

• Manage and update the Advertising Waterfall model and analyze revenue trends.
• Prepare month-end analyses, support budgeting cycles, and improve data reporting.
• Collaborate with Ad Operations, BI and Finance to assess opportunities and risks.
• Provide commercial finance guidance to operational teams and stakeholders.
• Review revenue and cost of sales for Display Advertising; support forecasting.

Skills

Commercial finance

Financial modelling

Data analysis

Google Sheets

Excel

Cross-functional collaboration

Curious analysis

Education

Accounting qualification progress (ACA/CIMA/ACCA)

Tools

Google Sheets

Excel

Job description

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.

#LI-Hybrid

#LI-HD11