Multi-family Portfolio Analyst II
Federal Home Loan Bank of Atlanta, Atlanta, GA, United States
Affordable Housing Program Analyst
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 include preparing in-depth feasibility and subsidy evaluations of assigned Affordable Housing Program projects and community development programs, preparing intake processing and funding functions of Affordable Housing Program, Community Investment Program/Economic Development Program, and other community investment service products, preparing performance reports for management, presenting analysis or reports before committee(s), providing guidance to Multifamily Portfolio Analyst Is in Community Investment Services department policies, procedures and practices, ensuring Affordable Housing, Community Investment/Economic Development, and other community investment service product documentation complies with Bank policies and procedures, reviewing and interpreting language in loan closing documents, developing, designing, enhancing, and maintaining comprehensive financial spreadsheets, models, and form templates, assisting with developing, updating, and maintaining written departmental operating policies and procedures for all programs, providing technical assistance to members and project sponsors regarding lending and disbursement procedures and regulatory requirements, preparing training and presentations for the CIS Department, internal and external customers, conducting site visits for selected AHP projects to collect outstanding documentation, facilitating the resolution of non-compliance issues and/or document findings to report back to Bank management, independently traveling and giving presentations to represent the Bank at external events and meetings, and maintaining current operating knowledge of federal, state, and local programs affecting community investment activities. Knowledge, skills, and abilities include 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, experience in developing project financials, or underwriting single family and/or multifamily affordable housing and community economic development real estate deals, 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, advanced computer skills, including Microsoft Word, Excel, and PowerPoint, strong customer relationship management skills, strong communication, presentation, and problem-solving skills, ability to apply newly acquired professional development tools, information, and training, and ability to recommend solutions to new or highly complex problems independently. Minimum Requirements:
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 modelingexperience, or the equivalent combination of education and experience is necessary. A master's degree is preferred. Work location: This individual must reside within commuting distance from our Atlanta, GA office. This position may not be filled in New Jersey, either in-person or remotely. Work schedule: Onsite with an opportunity to work remote partially. Visa sponsorship: 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.
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 include preparing in-depth feasibility and subsidy evaluations of assigned Affordable Housing Program projects and community development programs, preparing intake processing and funding functions of Affordable Housing Program, Community Investment Program/Economic Development Program, and other community investment service products, preparing performance reports for management, presenting analysis or reports before committee(s), providing guidance to Multifamily Portfolio Analyst Is in Community Investment Services department policies, procedures and practices, ensuring Affordable Housing, Community Investment/Economic Development, and other community investment service product documentation complies with Bank policies and procedures, reviewing and interpreting language in loan closing documents, developing, designing, enhancing, and maintaining comprehensive financial spreadsheets, models, and form templates, assisting with developing, updating, and maintaining written departmental operating policies and procedures for all programs, providing technical assistance to members and project sponsors regarding lending and disbursement procedures and regulatory requirements, preparing training and presentations for the CIS Department, internal and external customers, conducting site visits for selected AHP projects to collect outstanding documentation, facilitating the resolution of non-compliance issues and/or document findings to report back to Bank management, independently traveling and giving presentations to represent the Bank at external events and meetings, and maintaining current operating knowledge of federal, state, and local programs affecting community investment activities. Knowledge, skills, and abilities include 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, experience in developing project financials, or underwriting single family and/or multifamily affordable housing and community economic development real estate deals, 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, advanced computer skills, including Microsoft Word, Excel, and PowerPoint, strong customer relationship management skills, strong communication, presentation, and problem-solving skills, ability to apply newly acquired professional development tools, information, and training, and ability to recommend solutions to new or highly complex problems independently. Minimum Requirements:
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 modelingexperience, or the equivalent combination of education and experience is necessary. A master's degree is preferred. Work location: This individual must reside within commuting distance from our Atlanta, GA office. This position may not be filled in New Jersey, either in-person or remotely. Work schedule: Onsite with an opportunity to work remote partially. Visa sponsorship: 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.