Apply on Employer Site

Federal Home Loan Bank of Atlanta · 1 day ago

Multi-family Portfolio Analyst II

Atlanta, GA

Full-time

Hybrid

Senior Level

5+ years exp

Federal Home Loan Bank of Atlanta is seeking a Multi-family Portfolio Analyst II to perform intake, processing, underwriting, and funding functions associated with the Bank’s Affordable Housing Program. The role involves reviewing applications for funding, conducting financial feasibility analyses, and preparing performance reports for management.

BankingFinancial ServicesInsurance

Comp. & Benefits

No H1B

Responsibilities

Develops and recommends technical solutions to new or highly complex problems that cannot be solved using existing methods or approaches. Promotes those solutions with a successful outcome to senior management

Provides feedback and input on problems, and challenges that are complex and impact the business and operational objectives of the Bank

Anticipates and appropriately communicates the implications of events or decisions for various stakeholders and plans strategy accordingly

Develops and recommends feasible process improvement, resource deployment, quality control, and/or automation concepts and ideas that advance the department’s Performance Metric and Business Standards environment

Prepares, approves, and performs the preparation of in-depth feasibility and subsidy evaluation of assigned Affordable Housing Program projects and community development programs, including applications, takedowns, modifications, progress reports, and extensions using the Bank’s format of valuation methodology to estimate loan quality, valuation, and ensures compliance with Bank policy, procedures, and regulations

Prepares intake processing and funding functions of Affordable Housing Program, Community Investment Program/Economic Development Program, and other community investment service products

Prepares performance reports for management to enable them to make informed decisions

Presents analysis or report before committee, as required

Provides guidance to Multifamily Portfolio Analyst Is in Community Investment Services department policies, procedures and practices

Ensures Affordable Housing, Community Investment/Economic Development, and other community investment service product documentation complies with Bank policies and procedures

Reviews, analyzes, and interprets financial data contained in project proformas and sources, and uses statement and development budgets, and makes funding recommendations

Reviews and interprets language in loan closing documents such as promissory notes, closing statements, deeds, etc., that indemnify the Bank and its members against potential losses

Develops, designs, enhances, and maintains comprehensive financial spreadsheets, models, and form templates to facilitate the analysis and monitoring of the Bank’s Affordable Housing Program

Meets established performance metrics and standards

Assists with developing, updating, and maintaining written departmental operating policies and procedures for all programs

Provides technical assistance to members and project sponsors regarding lending and disbursement procedures and regulatory requirements

Participates in system elaboration and user acceptance testing for department systems

Prepares training and presentations for the CIS Department, internal and external customers

Conducts site visits for selected AHP projects to collect outstanding documentation, facilitates the resolution of non-compliance issues and/or document findings to report back to Bank management

Travels and gives presentations, as requested, to represent the Bank at external events and meetings without accompaniment

Maintains current operating knowledge of federal, state, and local programs affecting community investment activities

Qualification

Real estate financeFinancial analysisUnderwriting experienceCommunity development financeFinancial modelingMicrosoft ExcelCustomer relationship managementCommunication skillsPresentation skillsProblem-solving skills

Required

Bachelor's degree in finance, accounting, or real estate

Minimum of five years experience in the analysis of residential construction or commercial real estate, lending, or underwriting, with specific experience in loan documentation, appraisal review, due diligence, and cash flow analysis and modeling experience, or the equivalent combination of education and experience is necessary

A thorough understanding of the principles of real estate or mortgage finance, strong math skills, and the ability to identify and resolve complex financial problems are essential

Ability to develop comprehensive financial spreadsheets, models, and form templates is required

Advanced computer skills, including Microsoft Word, Excel, and PowerPoint

Strong communication, presentation, and problem-solving skills are required

Strong customer relationship management skills

Preferred

Experience in developing project financials, or underwriting single family and/or multifamily affordable housing and community economic development real estate deals is preferred

A thorough knowledge of the principles of community development finance and the operations of regulated financial institutions

Master's degree is preferred