Finance Modelling Specialist

Department: Business Services - Finance

Location: Bristol

About DAC Beachcroft

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.
The Opportunity

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.

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.

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 [email protected] in confidence with the vacancy reference in the subject line, and we’ll be happy to help.

We are happy to talk flexible working with our Flex Forward scheme. We would encourage you to talk to us about our approach to flexible working during the hiring process if you would like to explore this further.

Note for Recruitment Agencies
DAC Beachcroft manages all vacancies via our in-house recruitment teams, prioritising direct sourcing and referrals. When external support is required, roles are released to selected agencies on our Preferred Supplier List (PSL).

Speculative CVs sent to any DAC Beachcroft employee without prior instruction from our recruitment teams (LLP and CSG) will not be accepted, and no fees will be payable.

For PSL queries, please contact: [email protected] or [email protected]