Multi-family Portfolio Analyst II

Federal Home Loan Bank of Atlanta•Atlanta, GA

1d•Hybrid

About The Position

BASIC PURPOSE: Performs intake, processing, underwriting and funding functions associated with the Bank’s Affordable Housing Program and Set-Aside Program. Reviews applications for funding, conducts eligibility and financial feasibility analyses and underwriting, reviews documents associated with disbursement of program funds. ESSENTIAL FUNCTIONS: 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

Requirements

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.
A thorough knowledge of the principles of community development finance and the operations of regulated financial institutions.
Ability to develop comprehensive financial spreadsheets, models, and form templates is required.
Advanced computer skills, including Microsoft Word, Excel, and PowerPoint.
Strong customer relationship management skills.
Strong communication, presentation, and problem-solving skills are 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.
This individual must reside within commuting distance from our Atlanta, GA office.
Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Nice To Haves

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

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