Investor Reporting Officer

Job Description

Job Description

Investor Reporting Officer

ABOUT THE CONNECTICUT HOUSING FINANCE AUTHORITY:

Connecticut Housing Finance Authority ("CHFA") is a self-funded, quasi-public organization. Its mission is to alleviate the shortage of housing for low- and moderate-income families and persons in the state of Connecticut ("State") and, when appropriate, to promote or maintain the economic development of the State through employer-assisted housing efforts. CHFA is a mission-driven leader in creating affordable housing opportunities for families and individuals in Connecticut. We believe in the power of the diverse and inclusive communities we serve. We provide a challenging, progressive, and supportive environment that encourages and promotes employee development. We offer competitive salaries; tuition reimbursement; 457 deferred compensation, state-sponsored pension plan, comprehensive health, dental, life, and disability plan, paid vacation, sick, and holidays, hybrid work schedule, ongoing training, career development, and, if qualified, employee may be eligible for student loan forgiveness under Federal Loan assistance program.

ABOUT THE POSITION:

The position is responsible for assisting the Investor Reporting Manager with all aspects of monthly processing and reconciliation of Single-Family Investor Reporting loan data received from CHFA Loan Servicer portfolios. Format and import, or data enter monthly exceptions reported by CHFA servicers and communicate and work with servicers to correct any reconciliation or other issues.

SUPERVISION RECEIVED:

Receives direction from the Investor Reporting Manager, Finance, or a position of a higher grade.

SUPERVISION EXERCISED:

None.

POSITION SUMMARY:

• Import, review, and analyze monthly servicer exception reports.
• Reconcile servicer data with CHFA billing and resolve discrepancies.
• Balance mid‑month and month‑end collections to each servicer's Funds Transmittal Advice (FTA).
• Identify principal balance variances and timing differences, ensuring all items are resolved for the monthly period within deadlines.
• Generate and upload monthly billing, including overage/shortage adjustments, late remittance charges, and servicer exception cover letters.
• Review, identify, communicate, and where necessary, process daily wire activity.
• Review and process daily payoff receipts.
• Assist with or perform ad‑hoc and periodic reporting and reconciliations.
• Identify opportunities to streamline processes and improve efficiency.
• Research exceptions, discrepancies, and other issues identified in reports.
• Communicate with servicers and internal departments to resolve outstanding items.
• Effectively manage the relationship with CHFA servicers. Communicate and assist servicers, build confidence, gain trust, and strengthen rapport. Provide training, guidance and assistance to servicers as needed
• Prepare journal entries to address reconciliation issues.
• Import MBS files and reconcile as needed
• Develop and maintain job related procedural and process manuals
• Complete duties within required timeframes

MINIMUM QUALIFICATIONS REQUIRED:

Bachelor's degree in business, finance, accounting, or a related field preferred and a minimum of two years of experience in financial operations, accounting, loan administration, or similar analytical role.

OTHER REQUIREMENTS:

• Strong understanding of financial concepts, including loan amortization, interest calculations, and basic accounting principles.
• Advanced Excel skills required (e.g., pivot tables, VLOOKUP/XLOOKUP, SUMIFS, data validation, and comfort working with large datasets).
• Experience with mortgage servicing is helpful but not required; candidates should be comfortable learning industry‑specific processes.
• Ability to learn proprietary servicing systems, familiarity with enterprise content management tools (e.g., OnBase) and secure file‑sharing platforms (e.g., ShareFile) is a plus.
• High degree of accuracy and attention to detail when working with financial data.
• Strong analytical and reconciliation skills, with the ability to identify variances and investigate root causes.
• Ability to interpret reports, spot anomalies, and resolve discrepancies independently.
• Ability to explain findings, document issues, and follow up effectively.
• Comfortable collaborating across accounting, servicing, and operations teams.

ALL OTHER DUTIES AS ASSIGNED:

This is not an exclusive list of all job functions, and the employee is expected to complete all duties as assigned. Duties and responsibilities may be added, deleted, or changed at any time at the discretion of management, formally or informally. This job description in no way constitutes an employment contract or agreement.

CHFA EOE