Financial Modelling Manager/Associate Director - Infrastructure

Warner Scott; Greater London; On-site; GBP 85,000 - 120,000; Full time

Job summary

Warner Scott is recruiting a Manager/Associate Director to join its financial modelling team, advising domestic and international clients on infrastructure, healthcare, energy and transport using advanced analytics and modelling.

The role involves designing, building and reviewing complex models, developing dashboards, mentoring colleagues, and ensuring delivery to time and budget on UK and international projects.

Qualifications

• Strong financial modelling capability using Excel.
• Experience with data analytics tools and dashboards.
• Experience advising clients and delivering projects.
• Involvement in infrastructure projects or public policy programmes.
• Professional qualification desirable (ACA/CIMA/CFA).

Responsibilities

• Provide high-quality modelling support for clients.
• Develop a range of models: cash flow, acquisitions, risk.
• Automate data processes and deliver dashboards.
• Mentor colleagues and contribute to team methodology.
• Manage assigned areas including time and budget.
• Advise on financial aspects of PSA projects.
• Support skills development and training.
• Continue own professional development.

Skills

Financial modelling

Data analytics

Client advisory

Team leadership

Communication

Problem solving

Education

Professional qualification (ACA/CIMA/CFA)

Tools

Excel

Power BI

Python

SQL

Alteryx

Tableau

Job description

Our client is a global firm, who is looking for a bright and ambitious Manager and Associate Director to join their financial modelling team. This is an incredibly exciting opportunity for someone who desires to advise both domestic and international clients on a wide range of issues, such as healthcare, energy and transport through the usage of advanced analytics and modelling solutions.

The team works on some of the UK's largest and most high-profile infrastructure projects and public policy programmes. At their core these assignments are focused on creating value across the whole of the UK (and internationally) providing interventions that deliver economic and social benefits for current and future generations.

Responsibilities:

• Provide high quality modelling support, in terms of designing, building or reviewing models, for clients
• Develop a broad range of models including integrated financial models, business models, cash flow forecasts, options appraisals, pricing models, acquisition models, risk models etc
• Develop processes to help clients make more effective use of their data, improving efficiency via automation and providing insight through the use of dashboards/analytical methods
• Contribute to the development of Financial Modelling team methodology and market knowledge through involvement in technical and /or sector-based taskforces
• Take responsibility for assigned areas including work reviews and delivering works to time and budget
• Provide advice on financial aspects on projects and programmes within the PSA business
• Supporting the skills development of your colleagues through formal and informal sessions
• Continue to develop your own skills through internal and external training

Skills:

• Logical problem solver with the ability to create and review spread sheet based financial models (using Microsoft Excel). Additionally, expertise in data analytics (including Power BI (Dax/Power Query), Python, SQL, Alteryx, Tableau), is desirable
• Excellent analytical and communication skills and be able to articulate clearly, confidently and professionally to others internally and with clients
• Experience providing advice or analysis to internal or external clients
• Good verbal and written communication
• A commitment to diversity and inclusion
• A clear appetite for self-development demonstrated through the performance review and PDP processes
• Experience in delivering projects as part of a team
• Good inter-personal skills with the ability to engage with colleagues and clients on specialist subject matter
• Worked within or consulted into the public sector
• Experience of working on relevant infrastructure projects and public policy programmes
• Experience of building and reviewing integrated financial statement based models.
• A professional qualification (e.g. ACA, CIPFA, CIMA, CFA) is desirable
• Self-motivated individual with evidence of innovation and initiative
• Team player and confident in working on a number of projects in parallel

It would be great if you had some of the following skills, but don't worry if you don't tick every box, we'll help you develop along the way.