Senior AHP Analyst

FHLBank Pittsburgh; Pittsburgh (Allegheny County); On-site; USD 90,000 - 130,000; Full time

Job summary

FHLBank Pittsburgh is seeking a Senior AHP Specialist to support the Affordable Housing Program and other community-focused products within the Community Investment department. You will lead processing, analysis, reporting and customer service for AHP and related programs, ensuring regulatory compliance and data integrity.

The role requires 5+ years in banking or housing, a relevant degree (or equivalent), and experience with data analytics tools like Tableau or Power BI.

Qualifications

• Bachelor’s degree in Finance, Business, Economics, Public Policy, Urban Planning or related field.
• 5+ years in banking, housing or economic development with at least 4 years in affordable housing.
• Experience with data analytics tools (Tableau or Power BI) or similar.
• Strong analytical, communication and administrative capabilities.
• Experience underwriting complex real estate transactions.
• Proficient with Microsoft Office and database/spreadsheet tools.

Responsibilities

• Review AHP applications, analyze projects with tax credit financing and complex real estate.
• Underwrite funding transactions and monitor AHP post-completion reports.
• Prepare monthly reconciliations and diverse department reports for FHFA, Board, and management.
• Develop new databases and improve CID information systems.
• Provide quality customer service to member institutions and developers; answer eligibility questions.
• Ensure compliance with policies and regulations; present to Advisory Council and Board as required.

Skills

Analytical skills

Communication skills

Project management

Education

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

Housing development training certificate from Grow America or equivalent

Tools

Tableau

Power BI

Microsoft Excel

Microsoft Access

Job description

Position SummaryFHLBank 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 FactorsSupports the major functions of FHLBank Pittsburgh’s affordable housing real estate development grant program, Affordable Housing Program (AHP) and similar affordable programs such as the voluntary housing grant (VHG), including: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 FHFAEnsures compliance with applicable policies, procedures and regulations to ensure safe and sound business operations.Required ExperienceBachelor’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 preferredFive 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 experienceDemonstrated experience developing reports with data analytics software such as Tableau or Power BI, or other experience using technology to support program operations is preferredExcellent analytical, communication, and administrative skillsAbility to underwrite complex real estate transactionsExperience with Microsoft Office, including Word, Excel, Access and PowerPoint; ability to create and modify databases and complex spreadsheetsThree 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.