Finance Modelling Specialist

DAC Beachcroft LLP; West of England; On-site; GBP 55,000 - 75,000; Full time

Job summary

DAC Beachcroft is seeking a Finance Modelling Specialist to join the Business Services - Finance team in Bristol on a 9-month fixed-term contract. You will own a portfolio of advanced Excel-based financial models used for forecasting and budgeting, working closely with senior finance stakeholders and the Finance Business Partnering team.

You will drive modelling best practices, challenge assumptions, and deliver robust tools while enabling knowledge transfer across the finance function.

Qualifications

• Significant experience developing, maintaining and enhancing complex Excel-based financial models within FP&A or a similar environment.
• Strong understanding of P&L, balance sheets and cash flow.
• Excellent communication and stakeholder management skills.

Responsibilities

• Maintain, support and enhance a portfolio of business-critical financial models supporting forecasting and budgeting processes.
• Ensure models remain accurate, robust and aligned to reporting requirements.
• Challenge assumptions and identify opportunities to improve modelling methodologies and outputs.
• Document assumptions, methodologies, calculations, dependencies and data sources to reduce risk and improve transparency.
• Develop user guides and support knowledge transfer activities across the finance team.
• Provide specialist modelling support on ad hoc projects and initiatives as required.

Skills

Excel-based models

FP&A experience

Stakeholder mgmt

Analytical thinking

Problem solving

Tools

Excel

Power Query

Power Pivot

VBA

Macros

SQL

Job description

Finance Modelling Specialist

Department: Business Services - Finance

Employment Type: Fixed Term Contract

Location: Bristol

Description

At DAC Beachcroft, we're a leading international legal business with more than 3,000 people across the UK, Europe, Asia-Pacific and Latin America. We provide a full-service claims, commercial, risk, health and insurance legal offering to a diverse client base, combining sector expertise with a forward-thinking approach to delivering legal and business solutions.

As our business continues to evolve, robust financial planning and decision-making are critical to our success. We're looking for an experienced Finance Modelling Specialist to join us on a 9-month fixed-term contract, supporting a key period of forecasting and budgeting activity across the firm.

This is a unique opportunity to take ownership of a portfolio of complex, business-critical financial models that support strategic planning across the firm. Working closely with senior finance stakeholders and our Finance Business Partnering team, you'll play a pivotal role in ensuring our forecasting and budgeting models remain accurate, efficient and fit for purpose.

We're seeking someone who combines exceptional technical modelling expertise with strong commercial awareness and a passion for continuous improvement. You'll have the opportunity to influence decision-making, challenge assumptions and enhance the tools that underpin the firm's financial planning processes.

Key Responsibilities

• Maintain, support and enhance a portfolio of business-critical financial models supporting forecasting and budgeting processes.
• Ensure models remain accurate, robust and aligned to organisational and reporting requirements.
• Challenge assumptions and identify opportunities to improve modelling methodologies and outputs.
• Ensure consistency between business unit models and consolidated reporting outputs.
• Act as the technical lead for complex modelling issues, providing expert guidance and solutions.
• Diagnose and resolve calculation errors, data integrity issues and performance challenges.
• Document assumptions, methodologies, calculations, dependencies and data sources to reduce risk and improve transparency.
• Develop user guides and support knowledge transfer activities across the finance team.
• Provide specialist modelling support on ad hoc projects and initiatives as required.

Skills, Knowledge and Expertise

We're looking for an individual with:

• Significant experience developing, maintaining and enhancing complex Excel-based financial models within FP&A, commercial finance or a similar environment.
• Strong understanding of profit and loss accounts, balance sheets, cash flow statements and integrated financial models.
• Excellent understanding of key commercial and financial performance drivers.
• Experience documenting complex models and implementing controls to reduce model risk.
• Experience coaching or training colleagues and supporting knowledge transfer initiatives.
• Strong stakeholder management skills with the confidence to influence and challenge senior finance stakeholders.
• Excellent analytical, problem-solving and communication skills.
• Experience within legal or professional services environments would be advantageous but is not essential.

You will have advanced skills across:

• Microsoft Excel, including complex formulas, Dynamic Arrays, advanced lookups and aggregations.
• Scenario modelling and sensitivity analysis.
• Financial modelling best practice and model optimisation.
• Power Query and Power Pivot.
• VBA and macros.
• Error diagnostics and troubleshooting.
• Structured data modelling techniques.
• Power BI maintenance and troubleshooting capability.
• Basic SQL knowledge.

Additional Information

As a Disability Confident Scheme employer, we're committed to providing an inclusive and accessible recruitment process. If you need any reasonable adjustments at any stage (including the application, assessment or interview process), please contact [e-mail] in confidence with the vacancy reference in the subject line, and we'll be happy to help.