Portfolio Financial Modeler Analyst

Amea Power Group; Dubai; On-site; AED 180,000 - 300,000; Full time

Job summary

AMEA Power is seeking a Portfolio Financial Modeler Analyst to join our Asset Management team in Dubai. You will leverage advanced Excel skills to update live financial models, incorporate historical actuals, and project forward‑looking cash flows for portfolio projects.

You will assess debt service ratios, distributable cash flow, and covenants, prepare internal and lender reports, and support restructuring, negotiations, and due diligence with cross‑functional teams across the organization.

Qualifications

• Bachelor’s in math, accounting or finance; advanced degrees or CFA a plus.
• 3+ years updating and maintaining live financial models in asset management.
• Expert Excel (VBA, Power Query) with strong DCF/financial statement knowledge.

Responsibilities

• Update and maintain portfolio financial models with actuals and forward projections.
• Calculate debt service ratios and distributable cash flow per financing agreements.
• Prepare internal and lender reports and covenants certificates.
• Support restructuring, negotiations, and due diligence for portfolio projects.
• Collaborate with finance, project, legal, and SPV teams to align results.

Skills

Financial modeling

Excel VBA

Data analysis

DCF/valuation

Attention to detail

Education

Bachelor’s degree in mathematics, accounting, or finance

Master’s degree/CFA/diploma in financial planning a plus

Tools

MS Office Suite

Power Query

VBA

Job description

Portfolio Financial Modeler Analyst AMEA Power 2026-02-12T11:00:43+00:00

Portfolio Financial Modeler Analyst – Asset Management

Reporting to CFO Location Dubai

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 forward‑looking projections.

As part of the Asset Management team:

• Update the financial models with the actuals for the portfolio projects
• Maintain updated financial models that are regularly updated with historical actuals and project forward‑looking financial statements
• Carry out calculation of debt service ratios, estimation of distributable cashflow under the financing agreements
• Prepare financial reports, debt service ratios and covenants certificates for internal management reporting and for lenders
• Support any re‑structuring & re‑financing activities, analyze and advise on any other decisions related to portfolio projects

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.
• 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. co‑developers/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 expertise in financial modeling and financial analysis.

Person Specification

Qualifications & Experience

• Bachelor’s degree in mathematics, accounting, or finance; master’s degree, CFA, or diploma in financial planning a plus.
• 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

Related/Technical Skills

• Project Finance structuring (documentation, due diligence requirements, deal process) – Intermediate
• MS Office Suite – Expert
• Financial Modeling – Expert