Senior AHP Analyst

Federal Home Loan Bank of Pittsburgh; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

Federal Home Loan Bank of Pittsburgh seeks a Senior AHP Specialist to support the Affordable Housing Program and other community-focused products. This role leads processing, analysis, reporting, and customer service within CID, coordinating with stakeholders and ensuring regulatory compliance.

The position requires strong experience in affordable housing, banking, and data analytics, with a focus on complex real estate transactions and program management.

Qualifications

• Bachelor’s degree in Finance, Business, Economics, Public Policy, Urban Planning or related major.
• Five+ years’ experience in banking, housing or economic development with at least four years in affordable housing.
• Experience developing reports with data analytics software such as Tableau or Power BI.
• Excellent analytical, communication, and administrative skills.
• Ability to underwrite complex real estate transactions.
• Experience with Microsoft Office, including Word, Excel, Access and PowerPoint; ability to create and modify databases.
• Three or more years of progressive experience in banking/finance, small business finance, community service or development, real estate, affordable housing development/finance, examination, auditing, and/or compliance will be considered for an alternative role.

Responsibilities

• Review grant applications for the AHP, including analysis of proposed projects with tax credit financing.
• Ensure projects meet regulatory and policy requirements.
• Determine project feasibility based on underwriting criteria.
• Underwrite funding transactions for approved AHP projects and monitor compliance.
• Review and approve recommendations for AHP disbursements and post-completion reports.
• Monitor and report on CID operations and data integrity.

Skills

Data analytics

Analytical thinking

Communication skills

Underwriting

Database design

Education

Bachelor’s degree in Finance, Business, Economics, Public Policy, Urban Planning or related major

Housing development training certificate (Grow America)

Tools

Tableau

Power BI

Microsoft Excel

Microsoft Access

PowerPoint

Job description

Position Summary

FHLBank Pittsburgh (FHLBank) is seeking a Senior AHP Specialist who will support the Affordable Housing Program and other community-focused products. This position is within the FHLBank's Community Investment department which manages seven affordable housing and community development grant and loan products. This role will lead critical processing, analysis, reporting and customer service for these products. We are looking for an energetic, dynamic and committed individual seeking to join a team passionate about affordable housing and community development. We work together to create a positive and collaborative work environment to serve our member financial institutions and our communities. This position is a great opportunity for an individual who has experience in affordable housing, community development, the finance industry, and other related work.

FHLBank community investment products include the Affordable Housing Program, First Front Door, Home4Good, Banking On Business, Community Lending Program and Blueprint Communities.

Primary Success Factors

• Reviews grant applications for the AHP, including analysis of proposed projects that involve tax credit financing and other complex real estate transactions;
• ensures proposed projects meet regulatory and policy requirements;
• determines project feasibility based on underwriting criteria as defined by FHLBank procedures.
• Underwrites funding transactions for approved AHP projects and performs compliance and monitoring functions throughout the AHP project compliance period.
• Manager, Affordable Housing may authorize position to review and approve other Analysts’ recommendations for AHP project disbursements and AHP post-completion reports.
• Leads, under supervision of Manager, Affordable Housing, certain components of the AHP’s operations, such as monitoring and required data reporting.
• This entails compliance with all applicable regulations, policies and procedures.
• For reporting, this includes ensuring data integrity, accurate and timely preparation and submission of monthly reconciliations for AHP and other Community products and reports to the FHFA, Board, Bank Management and other stakeholders, as necessary.
• Handles transaction analysis, qualification determinations, commitment and disbursement of funds and related file management.
• Develops new databases for Community products;
• interacts with Information Systems in the development, implementation, modification, and ongoing maintenance of Community product information systems;
• serves as Community Investment Department (CID) representative for Bank projects.
• Participates in CID’s business strategy and policies to ensure regulatory compliance, analyzes internal and external data to recommend policy decisions to management.
• Works with and presents to Affordable Housing Advisory Council when required.
• Participates in meetings of the Affordable Housing Advisory Council (Council), Board of Directors and Bank management.
• Supports the development of the Affordable Housing Program Implementation Plan.
• Participates in the development and implementation of new products and special assignments related to the Bank's mission and vision.
• Recommends more effective and efficient program/operation changes;
• periodically analyzes the Community Products to determine customer and project profiles;
• recommends program changes to management that will meet customer needs and expand program usage;
• conducts research to create marketing strategies, products, and mission-related investments.
• Provides quality customer service and technical assistance by communicating program parameters and processes to member financial institutions, housing developers and other key stakeholders;
• responds to customer requests and program eligibility questions;
• troubleshoots customer issues and concerns.
• Effectively communicates ideas and program information to the Bank’s management team, Council, Board of Directors and FHFA
• Ensures compliance with applicable policies, procedures and regulations to ensure safe and sound business operations.

Required Experience

• Bachelor’s degree in Finance, Business, Economics, Public Policy, Urban Planning or related major or equivalent experience;
• housing development training certificate from Grow America or equivalent organization is preferred
• Five or more years’ experience in banking, housing or economic development with at least four years in affordable housing;
• possession of a graduate degree in a related field may be substituted for one year of work experience Demonstrated experience developing reports with data analytics software such as Tableau or Power BI, or other experience using technology to support program operations is preferred
• Excellent analytical, communication, and administrative skills
• Ability to underwrite complex real estate transactions
• Experience with Microsoft Office, including Word, Excel, Access and PowerPoint; ability to create and modify databases and complex spreadsheets
• Three or more years of progressive experience in banking/finance, small business finance, community service or development, real estate, affordable housing development/finance, examination, auditing, and/or compliance will be considered for an alternative role.

It is the policy of the Federal Home Loan Bank of Pittsburgh to ensure equal employment opportunity (EEO) for all employees and applicants for employment without regard to race, religion, color, sex, national origin, age, disability status, genetic information, veteran's status, ancestry, sexual orientation or status as a parent as defined by applicable law. It is the Bank's policy to comply with applicable laws concerning the employment of persons with disabilities, including reasonable accommodation for applicants and employees with disabilities.

FHLBank Pittsburgh provides reliable funding and liquidity to its member financial institutions, which include commercial and savings banks, community development financial institutions, credit unions and insurance companies in Delaware, Pennsylvania and West Virginia. FHLBank products and resources help support community lending, housing and economic development. As one of 11 Federal Home Loan Banks established by Congress, FHLBank has been an integral and reliable part of the financial system since 1932.