Investor Reporting Officer

Connecticut Housing Finance Authority • Rocky Hill, CT

19h • Hybrid

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.

Requirements

• Bachelor's degree in business, finance, accounting, or a related field preferred
• A minimum of two years of experience in financial operations, accounting, loan administration, or similar analytical role.
• 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).
• 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.

Nice To Haves

• 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.

Responsibilities

• 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

Benefits

• 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
• employee may be eligible for student loan forgiveness under Federal Loan assistance program

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level