Financial Modeller

Job Description

Salary - £37,300 - £40,248 + (Up to) £5,000 Accountancy AllowanceThe Government Property Agencys mission is to provide great places to work for civil servants. We are using our scale and commercial expertise to do this effectively, efficiently and sustainably, helping to support growth in all parts of the UK. We aregrowing rapidly through acquisition of Government properties from departments. Turnover has risen from £0.4bn in 20/21 to around £1bn in 21/22 and it will continue to grow as more properties are transferred and run by GPA. Similarly, our assets have grownto £0.85 billion and are expected to grow significantly each year. Creating a first-class finance function to service our clients is a key priority of our transformation programme.The GPA offer flexible working with the ability to work from home with occasional travel required to any of the GPA locations with Finance presence with offices in Birmingham, Leeds, London, Manchester, Newport, Norwich, Nottingham and Swindon.The Financial Modeller will be responsible for the content, quality and structure of all financial analysis prepared by the GPA for internal use and for third parties. Output will include undertaking analysis for the Economic and Financial Case sectionsof the GPAs business cases for real-estate acquisition/re-location, drafting business case content for the same sections, GPA portfolio valuation, data analysis and reporting.The responsibilities of the Financial Modeller will include

• Supporting internal and external stakeholders with the development of modelling behind business cases (Financial and Economic Analysis).
• The modeller will be responsible for technical modelling by developing/ enhancing options analysis models that will evaluate the financial and economic outcomes for various options and reflect the impact of decisions for the business case(s).
• Support decisions by building models that reflect forecast cash flows, NPVs, balance sheet impact from decisions such as leasehold vs freehold.
• The role is for technical modelling and the modeller will not own the assumptions but rather assist in gathering and updating them from a technical perspective.
• Liaise with stakeholders from across GPA to gather and challenge assumptions, improve the accuracy of the models, discover new data sources and get the maximum impact with end users.
• Ensure that models are robust and effective and follow best practice modelling techniques. Highlight modelling risks as appropriate.
• Stay informed of the ways the organisation uses its data and modelling best practices.
• Sense-check data and weed out outliers or seek clarifications on data that looks inconsistent. Flag data problems noted to the source.
• Ensure that the required outputs are produced completely and highlight all assumptions/ exceptions made.
• Produce monthly KPI reporting for the board performance report.

Key Skills & ExperienceEssential Criteria:

• Technical excel skills with knowledge of best practice modelling techniques
• Corporate Finance, Financial and operational modelling
• Manage and develop models efficiently, allied with a strong appreciation for the appropriate analytical techniques which can be employed to provide robust analyses at pace.
• Excellent written and verbal communication skills to articulate complex data challenges in simple language and to produce drafts of the financial case of complex projects.
• Ability to produce outputs that use visualisation techniques and data analytics.
• Experience using excel and modelling to manipulate data and building and maintaining a model suite.
• Excellent problem solving skills.
• Self-starting and inquisitive attitude, proactively seeking solutions to programmes analytical needs.
• Passion for continuous improvements.
• Understanding of the financial and economic parts of a business case.
• Understanding of project appraisal techniques (e.g. IRR, NPV etc)
• Experience of project work with deadlines in a fast paced changing environment.
• Team player and ability to work in multidisciplinary teams (finance, commercial, capital projects, client solutions etc).
• To be engaging and enthusiastic whilst helping others to achieve the team goals.

Desirable Criteria:

• Experience using excel modelling to support a finance function
• Experience in constructing and evaluating business cases
• Possess a commercial (not necessarily real estate based) acumen
• VBA Knowledge

For more information or an informal discussion, please apply via the link, or contact Michael Swinburn or Jack White at our retained search agent, Robertson Bell.

Keyskills :
FinanceFinancial AnalysisModellingExcel