Financial Modelling Analyst - M&A

Financial Modelling Analyst, M&A

Candidate Profile

• Bachelor's degree in engineering, mathematics, or accounting
• Relevant financial qualification (ACA; CFA; MBA)
• Minimum 2 years of direct financially relevant experience in a renewable energy environment (solar and wind preferred)
• Greek language skills (Native)
• Working knowledge of other European languages (advantage)

Skills

1. Exceptional Excel Skills: As a financial modelling analyst, excel skills are expected to be outstanding with exemplary proficiency in using pre-defined formulas, creating charts, building macros, and building flexibility into the model design (e.g. flagging, switches). Also, knowledge of VBA along with another programming language (such as Python) is a distinct advantage.
2. Knowledge of Investment Accounting Concepts & Terminology: The candidate will be expected to independently build highly detailed models which conform to sound accounting principles, for instance preparing investment appraisals using various financial techniques like DCF, NPV, IRR etc. It is essential the candidate have a strong grounding in core accounting theory (e.g., How financial statements link together; financial ratio calculations).
3. Problem-Solving Mindset: One of the primary responsibilities of the analyst is to solve problems inherent to creating financial models. Furthermore, the analyst must have the ability to build a robust model, ensuring that solving the problem at hand does not lead to another problem (e.g., re-sculpting debt to maintain appropriate capital structure which then violates key bank covenants).
4. Time Management & Organisation: The candidate will be working on many deals simultaneously, each with its own due diligence and investment structuring. Care will be needed to prioritise and deliver each deal based on evolving timelines s/he must proactively understand. Additionally, the candidate will communicate directly with stakeholders to obtain raw data to build models, necessitating an extremely organised approach to follow-up requests for information and archive that information in a logical way.
5. Ability to Build a Model that is Easy to Understand & Maintain: The model should be such that it aids the decision-making process of the organization. It follows that the analyst must be able to build the model that the decision-makers can easily understand (e.g., simplified, sequential formula structuring).

Responsibilities

• Build financial models in excel based on historical information and other available industry-specific operating metrics for renewable energy assets.
• Conduct scenario analysis based on microeconomic and macroeconomic factors to access business risk.
• Evaluate companies using various financial valuation methods, such as DCF, comparable company analysis, capital structure analysis etc.
• Ensure the accuracy of the new models while enhancing the quality of the existing models.
• Recommend and implement process improvement measures.
• Identify key financial as well as non-financial risks and advise mitigants for those risks.
• Conduct scenario and sensitivity analysis with the intent to support investment activities.
• Update the financial models after each earnings roll out or other similar corporate actions, as necessary.
• Analyse and identify data required to support model tracking.