Logo for The Community Preservation Corporation

Senior Investor Reporting Analyst

Roles & Responsibilities

  • Bachelor’s degree in business, Accounting, Finance, or a related field
  • 3+ years of experience in commercial mortgage servicing, Investor Reporting, Cash Management, or related financial operations
  • Strong understanding of Agency (Fannie Mae, Freddie Mac), FDIC, and other Investor reporting requirements
  • Proficiency with the McCracken Strategy and advanced Excel (pivot tables, VLOOKUP/XLOOKUP) and reconciliation formulas

Requirements:

  • Prepare and deliver Investor reporting packages and data files (monthly, quarterly, annual, and ad-hoc) ensuring accuracy and timely submissions
  • Reconcile and validate loan-level data against Investor reports and servicing system records to ensure data integrity
  • Support process automation and continuous improvement initiatives to enhance reporting efficiency, accuracy, and internal controls
  • Mentor junior team members and prepare recurring and ad-hoc reports for senior leadership, highlighting trends and risks

Job description

About Us:

The Community Preservation Corporation (CPC) believes stable and sustainable affordable housing is the foundation of strong communities and we strive to contribute to comprehensive neighborhood revitalization through our lending and partnerships. A nationally recognized leader in affordable housing finance, CPC has provided a consistent source of capital to underserved housing markets throughout New York State since our inception in 1974.

Today, CPC stands as the largest CDFI solely committed to investing in multifamily housing, having invested more than $15 billion to finance the creation and preservation of more than 230,000 units of quality housing in neighborhoods across New York State and beyond. CPC has a robust construction lending platform, a mortgage bank, and equity and impact investment platforms that focus on our three goals: Expanding Affordable Housing, Closing the Racial Wealth Gap and Investing in the Green Economy.

As a member of our team, you'll have the opportunity to work on impactful projects that make a real difference in people's lives. We're looking for talented individuals who are passionate about our mission and share our values of commitment, respect, excellence, accountability, and collaboration.

Role Summary:

The Senior Investor Reporting Analyst is responsible for preparing, reviewing, and delivering accurate, timely, and compliant reporting to Investors and internal stakeholders for a portfolio of commercial multifamily mortgage loans. This role manages complex reconciliation activities, leads issue resolution, maintains data integrity across servicing systems, and ensures adherence to Investor, regulatory, and contractual reporting requirements. The role partners closely with Finance/Accounting, Servicing, Asset Management and external partners to support high‑quality servicing operations, strengthen internal controls, and drive continuous improvement across the Investor Reporting function.

What You’ll Do:

  • Prepare and deliver Investor reporting packages and data files, including monthly, quarterly, annual, and ad‑hoc reports required by Investors. Ensure all reporting, certifications, remittances, and supporting documentation are accurate, complete, and submitted within required deadlines.

  • Reconcile and validate loan‑level data against Investor reports and servicing system records to ensure data integrity. Review Investor files, account reconciliations, payment activity, and wire instructions for accuracy, completeness, and compliance with Investor requirements.

  • Support and drive process automation and continuous improvement initiatives to enhance reporting efficiency, accuracy, and operational controls.

  • Assist in coordinating internal and external audits, including preparing documentation, managing timelines, and serving as a liaison with auditors and internal stakeholders.

  • Facilitate and support compliance‑related meetings by preparing agendas, documenting discussions, and tracking follow‑up actions to ensure timely completion.

  • Mentor junior team members by providing guidance, reviewing work, and contributing to team development and knowledge‑sharing initiatives.

  • Prepare recurring and ad‑hoc reports for senior leadership, highlighting trends, variances, risks, and key exceptions.

  • Collaborate with Finance, Asset Management, and other servicing teams to resolve reporting issues and support internal control requirements.

Skills and Experience:

  • Bachelor’s degree in business, Accounting, Finance, or a related field.

  • 3+ years of experience in commercial mortgage servicing, Investor Reporting, Cash Management, or related financial operations. Strong understanding of Agency (Fannie Mae & Freddie Mac), FDIC, and other Investor reporting requirements.

  • Proficiency with the McCracken Strategy, Excel including pivot tables, VLOOKUP/XLOOKUP, and reconciliation formulas.

  • Strong analytical, reconciliation, and problem‑solving skills with exceptional attention to detail.

  • Proven ability to manage multiple deadlines and perform effectively in a high‑volume, deadline‑driven environment.

  • Excellent written and verbal communication skills, with the ability to collaborate professionally across internal teams and external partners.

  • Ability to work independently while contributing effectively within cross‑functional teams.

  • Ability to travel, as needed.

What We Offer:

  • Competitive compensation

  • 401(k) retirement plans with employer match

  • Medical, dental, and vision benefits for employees and their dependents

  • Commuter benefits

  • PTO for vacation, personal days, sick leave, holidays, jury duty, bereavement, parental leave, and disability

  • Tuition assistance program

  • Two “work from anywhere” weeks per year

  • Summer Fridays

  • Collaborative working spaces

  • Service days to support our communities

  • Employee development and engagement events

  • More about our offerings and culture here

This is a remote role available in Missouri and Texas. Periodic travel to our Manhattan or Chappaqua, NY office may be required. The salary range is $80,000 – $95,000, dependent on experience.

Applicants must be authorized to work in the United States. The Community Preservation Corporation does not provide employment sponsorship of any kind. Candidates are responsible for ensuring they meet all minimum qualifications for the position at the time of application.

The Community Preservation Corporation is an Equal Opportunity Employer, and all employment-related decisions including recruitment, selection, evaluation, promotion, compensation, training and termination are made without regard to race, creed, color, national origin, sex, disability, marital status, status as a veteran, sexual orientation or gender identity, or any other protected status.

Related jobs

Other jobs at The Community Preservation Corporation

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.