Portfolio Financial Modeler Analyst AMEA Power

Position Purpose Asset Management team is looking for a dedicated financial modeler to join our growing company. You should have an excellent understanding of Excel, hands-on experience in live updating and manipulating complex financial models combining historical actuals and forwardlooking projections. As part of the Asset Management team: 1. Update the financial models with the actuals for the portfolio projects 2. Maintain updated financial models that are regularly updated with historical actuals and project forward-looking financial statements 3. Carry out calculation of debt service ratios, estimation of distributable cashflow under the financing agreements 4. Prepare financial reports, debt service ratios and covenants certificates for internal management reporting and for lenders 5. Support any re-structuring & re-financing activities, analyze and advise on any other decisions related to portfolio projects Responsibilities Update and Maintain financial models in AMEA portfolio • Model Updates: Regularly update the existing financial models with actual historical costs, revenues, production and other parameters, ensuring the alignment with the (un-)audited financial statements while maintaining the forward-looking mechanics and projections for valuing, monitoring, reporting and forecasting portfolio investments. • Data Management: Ensure accuracy of input data, maintain data integrity and model mechanics functionality, and update assumptions (e.g., inflation, FX rates) regularly. • Ratio Calculation: Regularly carry out calculation of debt service ratios, estimation of distributable cashflow as per signed financing agreements. Share and discuss calculations with lenders (and auditors). • Distributions estimation: Regularly estimate the distributable cash amount allowed under the financing agreements. Calculate and optimize the timing, amount and sequence of different types of distributions: dividends, principal and interest of shareholder loans, development fees, technical and asset management fees, share capital reductions, etc. • Reporting: Prepare financial reports, debt service ratios and covenants certificates for internal management reporting and for lenders. Create and present detailed investment reports for stakeholders and management to support decision-making. Job Description Portfolio Financial Modeler Analyst / Associate – Asset Management January 2026 • Performance Analysis: Conduct portfolio valuations, track cash flows (IRR, NPV), and evaluate performance against benchmarks. • Scenario Planning: Perform stress testing and scenario analysis to assess risk exposure based on micro/macroeconomic factors and operating conditions. • Collaboration: Work with corporate finance team, project finance team, legal team, technical team and SPV local teams to align models with operational results and (un-)audited financial statements. • Assist in negotiations and execution of any re-structuring & re-financing activities of portfolio projects. • Support due diligence, financial modeling and risk analysis for portfolio projects. • Provide financial modeling and analytical support for discussions with various stakeholders: Internal (e.g. work streams, Executive Management Team); and External (e.g. codevelopers/shareholders and Lenders). • Contribute to negotiations of MOUs, JDAs, PPAs, Concession Agreements, Tax / Investment Conventions, etc. • When needed, interface and lead external advisors and consultants. • Assist in updating project documentation to satisfy investors and management. Assist in optimizing returns • Assist in evaluation and decision-making on technical and engineering optimization of operating projects. • Assist in financial engineering schemes to improve project economics. • Contribute to risk analysis of projects. Support valuation of projects • Effectively use valuation tools for different project types and stages. • Possess and actively use an expertise in financial modeling and financial analysis. Job Description Portfolio Financial Modeler Analyst / Associate – Asset Management January 2026 Person Specification Experience Requirements • Hands-on experience in updating, managing and maintenance of live financial models at a portfolio / asset management department • Expert-level proficiency in Microsoft Excel (VBA, Power Query, modeling best practices) is essential. • Knowledge of basic accounting concepts and a solid understanding of financial analysis terminology and best practices, such as DCF and financial statements • A keen eye for detail and an ability to sift through large data sets to extract meaningful information • Excellent time management skills, including the ability to work under pressure to meet tight deadlines • More than 3 years of relevant work experience (some part of it preferably with a multinational organization / major bank / power developer / established advisory) • Understanding of the various power generation technologies and key business drivers • Education Requirements • A bachelor’s degree in mathematics, accounting, or finance; master's degree, CFA, or diploma in financial planning a plus Required Role Related/Technical Skills • Project Finance structuring (documentation, due diligence requirements, deal process) - Intermediate • MS Office Suite - Expert • Financial Modeling - Expert