Financial Modeller

Sanderson; Greater London; On-site; GBP 60,000 - 90,000; Full time

Job summary

Sanderson is seeking a Financial Modeller to develop, maintain and enhance the department's financial modelling capability. You will provide expert analysis and modelling support for reporting, forecasting, budgeting, technical accounting and finance transformation.

Working with finance professionals, data specialists, operational stakeholders and external delivery partners, you will build robust, auditable and scalable models, challenge assumptions and implement new systems and policies to

Qualifications

• Degree in Finance, Mathematics, Economics, Statistics, Actuarial Science or a related discipline.
• Part-qualified or fully qualified accountant (CCAB, CIMA) or substantial relevant financial modelling experience.
• Proven experience in designing and maintaining complex financial models.

Responsibilities

• Design, develop and maintain complex models supporting financial reporting, budgeting, forecasting and strategic decisions.
• Develop scenario, sensitivity and stress-testing models to assess financial performance and risk.
• Support models required for accounting and regulatory reporting requirements.
• Document modelling methodologies, assumptions and calculations clearly.
• Review and improve existing models for efficiency, robustness and usability.
• Ensure models meet departmental governance and control standards.

Skills

Advanced Excel

Financial modelling

Data analysis

Stakeholder engagement

Attention to detail

Communication skills

Model governance understanding

Education

Degree in Finance, Mathematics, Economics, Statistics, Actuarial Science

CCAB/CIMA or equivalent professional qualification

Tools

Power Query

VBA

Job description

The Financial Modeller will develop, maintain and enhance the Department’s financial modelling capability, providing expert analysis and modelling support for financial reporting, forecasting, budgeting, technical accounting and finance transformation.

Working with finance professionals, data specialists, operational stakeholders and external delivery partners, you will develop robust, auditable and scalable models, challenge assumptions, improve existing approaches and support new systems, accounting policies and reporting requirements. You will be highly analytical, detail-oriented and able to communicate complex financial concepts clearly.

Key Responsibilities

• Design, develop and maintain complex models supporting financial reporting, budgeting, forecasting and strategic decisions.
• Develop scenario, sensitivity and stress-testing models to assess financial performance and risk.
• Support models required for accounting and regulatory reporting requirements.
• Document modelling methodologies, assumptions and calculations clearly.
• Review and improve existing models for efficiency, robustness and usability.
• Ensure models meet departmental governance and control standards.

Financial Analysis and Reporting

• Provide quantitative analysis for management reporting, financial planning and business cases.
• Analyse financial performance and identify drivers, risks and opportunities.
• Support monthly, quarterly and annual financial reporting outputs.
• Analyse departmental assets, liabilities, income and expenditure as required.
• Support forecasting and long-term financial planning.

Controls, Validation and Governance

• Develop and maintain model validation procedures and quality assurance processes.
• Establish appropriate controls over models and underlying data.
• Perform reconciliations and reasonableness checks on model outputs.
• Support internal and external audit reviews with model governance evidence.
• Improve financial control processes and modelling standards.

Data Management and Improvement

• Collaborate with finance and data teams to improve data quality, completeness and accuracy.
• Support design and testing of data transformations and interfaces.
• Analyse large datasets to identify trends, anomalies and improvements.
• Assist with data cleansing and data quality initiatives.

Finance Transformation and Change

• Contribute to finance transformation, system implementation and process improvement projects.
• Support user acceptance testing and validation of finance system changes.
• Identify opportunities for automation and simplification.
• Help ensure new systems and processes meet financial reporting and control requirements.

Stakeholder Engagement and Other Duties

• Build relationships across Finance, Digital, Risk and Operations.
• Present methodologies, assumptions and findings to senior stakeholders.
• Provide technical advice and develop modelling capability across Finance.
• Support FCD colleagues, respond to ad hoc modelling requests and undertake other duties appropriate to the role.

Qualifications

• Degree in Finance, Mathematics, Economics, Statistics, Actuarial Science or a related discipline.
• Part-qualified or fully qualified accountant (CCAB, CIMA), equivalent professional qualification, or substantial relevant financial modelling experience.

Knowledge

• Financial accounting and reporting principles.
• Financial planning, forecasting and budgeting.
• Financial controls, governance frameworks and model governance best practice.
• Data analysis and quantitative techniques.

Skills and Abilities

• Advanced Microsoft Excel modelling skills, including building models using Power Query and VBA.
• Strong analytical and quantitative ability, attention to detail and structured problem-solving.
• Ability to interpret data, identify and resolve complex issues.
• Excellent written, verbal, presentation and stakeholder engagement skills.
• Ability to explain technical financial concepts to technical and non-technical audiences.
• Ability to build relationships, challenge constructively and influence decisions across multidisciplinary teams.

Experience

• Significant experience developing and maintaining complex financial models.
• Working with large and complex datasets.
• Supporting financial forecasting, planning and reporting.
• Documenting model methodologies and assumptions.
• Implementing and operating model controls and validation processes.