Project Analyst

tendersglobal.net

Job Description

The Project Analyst will provide analytical support for the processing of new and portfolio transactions. This includes data analytics for transaction reviews, support of the development of portfolio and pipeline analysis tools, and analytical and technical support for the audit and the development of coherent financial models based on best practice and ADB’s standards and templates for the private sector operations of ADB. The staff will also provide analytical support to other areas in line with RAU’s mandate.
The incumbent will report to designated International Staff or senior National Staff.
Responsibilities:
Pipeline and Portfolio Analytics:

Support the design and implementation of pipeline and portfolio analysis tools, and the data extraction processes for them;
Design and apply benchmarking tools and dashboards in transaction reviews interprets the outputs for understanding the risk profiles of proposed obligors;
Review outputs of portfolio analytics tools, provides commentary and conclusions from the data analysis, particularly as to the impact of different risk drivers of overall portfolio risk profile and performance.

Financial Modeling and Audit:

Build well-designed, well-structured and user friendly bespoke financial models for different types of companies and infrastructure projects, for debt and/or equity investments, in line with industry best practice and PSOD’s criteria, and incorporating key findings from due diligence and comments from the deal teams and clients as appropriate;
Review, audit, modify and sensitize financial models (including proper documentation of all changes) for corporates in various sectors and infrastructure projects which have been designed and built by sponsors or ADB’s deal teams for the use in ADB’s risk assessment process;
Conduct walkthrough of the bespoke financial models with counterparties;
Develop and conduct training programs on best practice in financial modeling and key accounting fundamentals and their integration to financial models;
Conduct financial analysis and due diligence to understand key business drivers of the companies and use findings to design and build bespoke financial models;
Conduct benchmark analysis using relevant peers to validate the reasonableness of the assumptions and stress scenarios used in the financial model; and
Perform other tasks, as may be required.

Risk Appraisal of New Transactions:

Review, assess, and provide recommendations for key transaction risks, covering, inter alia, sponsor, commercial, and structure risks in proposed financing transactions;
Provide advice and recommendations to deal origination teams on appropriate risk mitigation measures, deal structuring, security arrangements, and financial covenants throughout the risk appraisal process; and
Participate in drafting risk appraisals for nonsovereign loan, guarantee, and equity transactions in both the concept review and final approval stages.

Others:

Participate in selected due diligence conference calls and missions;
Assume ad hoc project duties and other forms of assignments, as required; and
Provide support to other divisions and units in PSOD as and when needed for special projects and tasks.

Qualifications:
Relevant Experience & Requirements:

Bachelor’s degree in business administration, Finance, or relevant fields, preferably with advance training and/or qualification as Certified Public Accountant (CPA), Chartered Financial Analyst (CFA);
At least 5 years work experience preferably in international bank, rating agency, accounting firm, or multilateral/bilateral development organization, in financial modeling, risk management, deal origination or investment appraisal;
Solid knowledge and understanding of accounting fundamentals (including sector-specific accounting standards) and application of these concepts in building bespoke financial models;
Demonstrated skills in data visualization and data analytics, such as building dashboards for risk tracking;
Demonstrated experience in: (i) designing and building financial models for different types of obligors, (ii) modifying and auditing complex financial models for various project finance and corporate finance deals, and (iii) back-testing of financial models;
Strong financial analysis and forecasting skills, problem-solving skills, and attention to details;
Mastery in Microsoft Excel with ability to build highly granular models and various sensitivity scenarios for debt and equity transactions;
Good command of Power BI, Power Query and other similar tools used in big data analysis is a plus;
Strong coordination, interpersonal and diplomacy skills;
Good familiarity with risk rating tools, and developments in the area of risk management.
Strong report-writing and communication skills in English