Multi-family Portfolio Analyst I

Federal Home Loan Bank of Atlanta • Atlanta, GA

4d • Hybrid

About The Position

BASIC PURPOSE: Performs intake, processing, underwriting and funding functions associated with the Bank’s Affordable Housing Program. Reviews applications for funding, conducts eligibility and financial feasibility analyses and underwriting, reviews documents associated with disbursement of program funds. ESSENTIAL FUNCTIONS: 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 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 reports before committee(s), 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 pro formas, sources and uses statements, 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. 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. 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. Independently travels and gives presentations, as requested, to represent the Bank at external events and meetings. 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.
• 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.
• Ability to apply newly acquired professional development tools, information, and training.
• Ability to recommend solutions to new or highly complex problems independently.
• A bachelor’s degree in finance, accounting, or real estate, and a 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.

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.
• A thorough knowledge of the principles of community development finance and the operations of regulated financial institutions.
• A master’s degree is preferred.

Responsibilities

• 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 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 reports before committee(s), 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 pro formas, sources and uses statements, 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.
• 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.
• 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.
• Independently travels and gives presentations, as requested, to represent the Bank at external events and meetings.
• Maintains current operating knowledge of federal, state, and local programs affecting community investment activities.

Benefits

• In addition to an excellent work environment, the Bank offers its employees a flexible, highly competitive benefits package.
• For more information, please download our Summary of Benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level