Posted 20 days ago
Finance Modelling Specialist
BristolHybrid
AI Summary
Finance Modelling Specialist maintaining and enhancing complex Excel-based financial models for forecasting and budgeting, providing technical leadership and model optimisation for a legal firm.
About this role
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.
Skills, Knowledge & 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.
Technical Expertise
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.
Benefits
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 recruitment@dacbeachcroft.com in confidence with the vacancy reference in the subject line, and we’ll be happy to help.
Skills
Dynamic ArraysError DiagnosticsExcelFinancial ModellingMacrosModel OptimisationPower BIPower PivotPower QueryScenario ModellingSensitivity AnalysisSQLStructured Data ModellingVBA
Explore related jobs
More jobs at DAC Beachcroft
Similar Dynamic Arrays jobs
Jobs in Bristol
Head of TechnologyProctor and Stevenson · Bristol, Bristol- Paid Media ExecutiveHybrid News Limited · Bristol, England
Lead SAP ConsultantSnap Analytics · Bristol, UK- Senior Software Engineerkaluza · Bristol, England
- Software Engineering Managerkaluza · Bristol, England
Accounting Manager - UKParallel Wireless · Bristol
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.