2026 Summer Undergrad Internship Program - CSP

The Community Preservation Corporation•New York, NY

1d•$20 - $20•Hybrid

About The Position

The Community Preservation Corporation (CPC) is a nonprofit multifamily finance company that was founded in 1974 to provide financial and technical resources to stabilize and revitalize underserved communities in New York City. Today, CPC operates nationally and stands as one of the largest Community Development Financial Institutions (CDFI) Fund in the country solely committed to investing in multifamily housing through its construction lending, mortgage lending and equity investing businesses. CPC uses its decades of expertise in housing finance and public policy to expand access to affordable housing and drive down the costs of housing production, advance diversity and equity within the development industry, and address the effects of climate change in our communities through the financing of sustainable housing. Since its founding, CPC has invested over $15 billion to finance the creation and preservation of more than 230,000 units of housing and has approximately 4,500 affordable units under ownership. CPC is a carbon neutral company and has been rated AA- by S&P. Visit CPC at communityp.com, and on Facebook, LinkedIn and X. Community Stabilization Partners (CSP) is a joint venture between The Community Preservation Corporation and Related Fund Management, established to asset manage and service a portfolio of commercial loans secured by approximately 1,100 multifamily buildings and ~35,000 housing units in New York City, the majority of which are rent stabilized. These loans were formerly held by Signature Bank. The CSP Summer Intern will work on CSP’s Portfolio Management team and gain exposure to a fascinating segment of NYC’s rental housing market by assisting with portfolio analytics, data analysis and data validation. The intern will assist in analyzing portfolio data to identify physically distressed properties and will contribute to the development of automated reporting tools in Power BI to enhance ongoing monitoring. They will support research and evaluation by reviewing public datasets and recommending inputs for ongoing monitoring. The intern may also be asked to assist with ad hoc analysis for transactions, management reports, and internal quality control reviews.

Requirements

Must be currently pursuing an undergraduate degree.
Must be available for the full duration of the internship program: Monday, June 1 – Friday, August 7, 2026.
Must be able to work from the New York City office at least three days a week, with a remote option up to two days a week.
Experience with Power BI is a plus.
Familiarity with AI for data scraping is a plus.
Experience with SharePoint is a plus.
Experience with data analysis and data validation.
Ability to analyze portfolio data.
Ability to research public datasets and review data dictionaries.
Ability to assist with ad hoc analysis.
Ability to review escrow agreements.
Ability to assist with data cleaning and record reconciliation.
Ability to verify data.
Ability to document glitches and confirm readiness for production.

Nice To Haves

Experience with Power BI.
Familiarity with AI for data scraping.
Experience with SharePoint.

Responsibilities

Analyzing portfolio data to identify physically distressed properties.
Developing an automated Power BI report that can be refreshed regularly.
Researching appropriate public datasets, reviewing data dictionaries, and developing technical specs for manager’s review.
Reviewing results of preliminary analysis and identifying issues with design needing reiteration.
Assisting with quick ad hoc analysis to prepare for closings.
Analyzing lender holdback escrow data to determine eligibility for release or for the lender to apply funds to outstanding unpaid principal balance (UPB).
Assisting in data cleaning and record reconciliation projects.
Developing a dataset to use for compliance monitoring purposes for loan modifications involving principal forgiveness.
Verifying inherited data from Signature on the number of rent stabilized units in each collateral property.
Using the test SharePoint site, documenting glitches and helping confirm readiness for production.