Systems & Reporting Analyst - Housing

FHLBCIN•Cincinnati, OH

1d•Hybrid

About The Position

Assists in the maintenance and administration of the Online Application System (OASYS), including the underlying applications (e.g., the Affordable Housing Program (AHP) Online Application, the Welcome Home Online System (WHO), Housing Back-End System (HOBE), etc.). Works closely with Software Engineers to develop requirements for application changes and then test the technological implementation of those changes. Performs data analysis for departmental reporting using software like Excel, SQL, and Tableau. Collaborates with Housing & Community Investment (HCI) Department management to update applications and supporting materials, prepare data for presentations, assess dashboard accuracy, being mindful of regulations, policies, and guidelines. Analyzes new AHP applications to ensure compliance with FHLB policies and Federal Housing Finance Agency (FHFA) regulations and Advisory Bulletins (ABs). Educates and assists other FHLB staff, Members, and project Sponsors with the use of FHLB and FHFA applications and works independently to meet expected deadlines with minimum supervision.

Requirements

Knowledge at a level normally acquired through completion of a Bachelor's Degree in Business, Finance, Information Systems, Computer Science, or a related field or equivalent experience.
Individual should be organized, detail and process-oriented with ability to follow through as necessary.
Strong technical skills required.
Analytical skills necessary to gather and interpret data and prepare reports.
Excellent verbal and written communications skills including interpersonal skills necessary to interact effectively and persuasively with internal and external contacts, including the capacity to speak both business and technical languages and translate between the two.
Demonstrates effective presentation skills including material preparation, recording webinars for training purposes and providing technical assistance as needed.
Working knowledge of Microsoft Word and PowerPoint and the ability to manage information in comprehensive databases.
Must be highly self-motivated with the ability to balance working autonomously with the need to build collaboration.
Demonstrates interest in working with a variety of backgrounds and perspectives that align with the Bank’s core value. Promotes an environment of empathy and respect to ensure the inclusion of all team members.

Nice To Haves

One to two years’ experience as systems test analyst, compliance analyst, business process analyst, or related experience is preferred.
Advanced knowledge of SQL, Tableau, Excel, and SharePoint, are highly preferred.
Familiarity with AI, systems implementation, and technical aspects of customized development are desirable.
Familiarity with using AI for analyses highly preferred.

Responsibilities

Prepares a variety of reports, analyses, and materials related to HCI program activities on a scheduled and ad hoc basis, keeping in mind some of these are done by regulation and are audited internally and externally.
Uses SQL and Tableau to query database to create and publish reports.
Works collaboratively with Software Engineering and Data & Analytics to improve technical systems, dashboards, and databases.
Participates in defining business system and/or reporting requirements based on business needs.
Updates/tests the AHP application and related forms for accuracy and consistency with the Affordable Housing Program Implementation Plan.
Assists in management of AHP offering process as directed and conducts technical assistance to external users throughout the offering period.
Participates in evaluation of AHP applications.
Provides program assistance to Members, Sponsors, housing developers, and project owners regarding the use of various HCI programs.
Performs comprehensive underwriting and analysis of applications, reservations, and disbursements for program eligibility, financial feasibility, and scoring assessment.
Tests online applications for conformity with specifications.
Maintains and updates procedures and educational materials related to the use of departmental systems.
Works with the Marketing Department to support the biannual Community Support Statement process.
Performs other duties and special projects as assigned by Management.