Our client is a large local government organisation and looking for an experienced Finance Modeller to join their team
This is initially a 3 month contract which may be extended for the right applicant
You will
A finance modeller working within a local council (public sector) typically focuses on long-term financial planning, scenario analysis, and supporting policy decisions with robust data models. The role blends technical modelling with strategic insight and stakeholder communication. Here’s a clear breakdown of common duties:
Core Financial Modelling
*Build and maintain complex financial models (e.g. revenue forecasts, capital programmes, funding scenarios).
*Develop scenario analysis to assess the impact of policy changes, economic shifts, or funding cuts.
*Model long-term financial sustainability (often 5–10+ year horizons).
*Stress-test assumptions such as inflation, interest rates, and demand for services.
Budgeting & Forecasting
*Support annual budget setting and medium-term financial strategies (MTFS).
*Produce regular forecasts (monthly/quarterly) and variance analysis.
*Translate service-level data into financial projections.
Policy & Decision Support
*Provide financial insight to support council policies, investments, and transformation programmes.
*Evaluate business cases for capital projects (e.g. housing developments, infrastructure).
*Assess cost-benefit and value-for-money of initiatives.
Data Analysis & Reporting
*Analyse large datasets (service usage, demographics, costs).
*Produce dashboards, reports, and visualisations for senior leadership and councillors.
*Communicate complex financial outputs in a clear, non-technical way.
Stakeholder Engagement
*Work closely with service departments (housing, social care, transport, etc.).
*Present findings to finance leaders, directors, and elected members.
*Challenge assumptions and provide independent financial scrutiny.
Funding & Grants Analysis
*Model the impact of government funding changes, grants, and business rates retention.
*Support bidding for external funding with robust financial projections.
Risk Management
*Identify financial risks and opportunities within models.
*Develop mitigation strategies and contingency plans.
Systems & Process Improvement
*Improve modelling tools, templates, and financial systems.
*Automate processes using tools like Excel, Power BI, or Python where relevant.
Compliance & Governance
*Ensure models align with public sector accounting standards and audit requirements.
*Maintain transparency and documentation for audit trails.
PLEASE NOTE THIS ROLE IS INSIDE SCOPE OF IR35
HYBRID WORK AVAILABLE