Finance Business Modeller

  • Location

    Manchester, Greater Manchester

  • Sector:

    Morson, Aerospace Project Management

  • Job type:


  • Salary:

    £55000.00 - £60000.00 per annum

  • Contact:

    Kartik Masalawala

  • Contact email:


  • Job ref:


  • Published:

    11 months ago

  • Expiry date:


  • Client:


Job Profile

* Set up and drive application of modelling best practice across the Group, with implementation of Model Reviews / "internal audits" of business cases excel models, and work with divisional teams to improve.

* Become the 'business champion' for financial modelling and excel processes, being accountable for improving practices and developing new policies to improve standardisation and control of business procedures.

* Influence Business Units to develop new methods and approaches to financial modelling, providing more robust output and increased process efficiency.

* Utilise specialist experience and judgement to determine solutions for required improvements around the Group, and influence key stakeholders to change practices to increase efficiency and efficacy.

* Manual creation of models to suit business requirements and provide solutions to constantly changing business needs, such as developing a weekly rolling cashflow, WC forecast models and weekly cash dashboards and improvement of existing business case models.

* Work proactively with key business partners and stakeholders to develop successful partnering relationships

* Own, run and constantly improve the MAG group business planning financial model (including financing) to include scenario analysis and stress testing of business cases

* Work with the Head of Business Planning & Projects to produce the annual 5 year business plan

* Help in the production of output material (Board reports, management information, ad-hoc requirements, etc) and ensure consistency with model data

* Utilise best practice in the integration of SAP forecasting functionality within the model and help streamline forecasting process across the Group

* Work with the Head of Business Planning & Projects on business cases and strategy development as required

* Assist the business with ad-hoc improvements to existing processes as issues arise

Facts and Figures

* Group turnover >£800m with EBITDA >£350m across multiple Business Units

* c60m passengers per annum and increasing above market rate

* Investment of c£1.5bn across Manchester and Stansted Airport Transformation projects

Knowledge, Experience and Skills

* Advanced Excel skills (including VBA expertise, with ability to write and correct existing macros to facilitate modelling best practice)
* Knowledge of other MS Office programmes (especially PowerPoint)
* Strong track record of financial modelling, both business planning and transactional models, with ability to successfully lead improvements to existing financial processes, procedures and outputs
* Good understanding of financial valuation techniques, e.g. NPV, DCF and IRR
* Experience of utilising and effectively interfacing ERP systems into planning models, preferably SAP, in order to streamline business processes and obtain required information in the most efficient way
* Strong commercial acumen understanding of key business drivers, risks, competitive pressures Dynamic personality and excellent relationship builder at all levels across the business
* Demonstrate ability to critical evaluate and improve modelling processes
* First-class written and verbal communication and presentational skills
* Excellent analytical skills: the post-holder must be insight-focused and able to interpret meaning from disparate sources and formats of data
* The post-holder must be able to plan workloads effectively to ensure that multiple projects and responsibilities are delivered on time and to an appropriate standard
Professional Qualifications
* 2-3 year post qualified experience of working in business modelling team in big 4 or equivalent together with general business analysis and partnering or management consulting skills
* A numerate degree (2.1 or higher) or equivalent (for example in Finance/Maths/Engineering) with preferably a higher degree (or equivalent) in a relevant discipline