FP&A Analyst - Empirical Search

Role Description

Produce under supervision the group’s financial plan and updates. Translate all data used in the production of the group’s annual and quarterly financial plans into the group’s financial planning software. Reconcile data to the budget and forecasted source data to ensure accuracy and work with the providers of data to ensure smooth transition and continuous improvement to data quality and accuracy.

Undertake stress testing and scenario/mitigation analysis on the group’s business plan for a wide range of economic scenarios and variables. Analyse and report on the outcomes on a regular basis. Develop new methods for stress testing the group and design outputs to assist in the analysis of risk.

Translating the group’s financial plan into the annual financial forecast return (FFR) submission to the Regulator of Social Housing. Work on improving the integration of data from the group’s financial planning software into the FFR submission. Reconcile the return to the group’s statutory accounts and provide feedback to managers on the outputs.

Undertake the production of the business plan for credit rating purposes, producing analysis as required for the annual S&P credit submission. Provide monthly analysis of peer benchmarking in relation to credit rating. Support the group’s monthly cash flow forecast and reporting on outputs to stakeholders, contributing to the development of the cash flow forecasting process.

Monitor and report on the group’s Key Performance Indicators (KPI’s) and assist in the development of new reporting methods through the group’s financial planning process. Assist in extracting development data from the group’s development system and converting to the format required for input into the groups business planning software. For each instance of updated development data, reconcile to the latest available development forecast and ensure all assumptions remain relevant.

Preparation of the quarterly and annual living business plan document as required. Provide assistance in the development of new business plan reporting functionality and reporting. Produce the monthly development metrics report which is sent to the group’s investment panel and based on feedback from the panel, work with the group’s development analyst to continuously improve the outputs.

Produce and monitor the group’s net worth equalisation model to analyse the lender’s covenant position and advise on the most appropriate entity designation for new development projects. Develop reports using the finance tools available to improve the access to data required by the Treasury department and work to reduce manual tasks in the team. Any other support as required to the Head of FP&A or Director of Treasury.

Role Requirements

• Relevant treasury/finance qualification/business degree or equivalent experience
• Experience of financial planning and analysis of complex consolidated group structures
• Experience in scenario and stress testing with a good understanding of operational triggers and mitigation strategies
• Knowledge and understanding of financial information derived from financial statements and accounting standards, able to present findings to stakeholders including at board level
• Experience in cash flow analysis and cash flow forecasting
• Excellent knowledge of general IT technologies
• Excellent organisational skills
• Excellent time management skills
• Has an understanding of a Treasury function – desirable
• Proficient in Microsoft applications, advanced excel skills
• Able to use business Information/analysis tools and financial planning tools
• Strong communication skills, confident and comfortable working across all levels of the organisation
• Able to build an understanding of the technical requirements of the department to aid administrative activities
• Clear understanding of the importance of customer service