Data Quality & Reporting Analyst (Commercial Real Estate)

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 Data Quality & Reporting Analyst is responsible for ensuring the accuracy, completeness, consistency, and reliability of key data points across the organization’s systems and documentation and delivering key enterprise-level reporting to external partners. This role will partner closely with stakeholders from across the organization, including IT and business representatives, on data integrity and digitization efforts. The Analyst role will also monitor standard industry and academic housing, economic and community development data/report releases for integration and trend analysis opportunities, and generate, at minimum, geographic visualization outputs for impact and other communication purposes.

What You’ll Do

• Data Quality Monitoring & Validation
• Develop, document, implement, and maintain data quality rules and automated checks.
• Conduct routine audits on key datasets.
• Identify data anomalies, gaps, duplicates, or inconsistencies and notify data owners for resolution, in some instances updating data directly
• Partner with businesses to identify data gaps, research and validate external data sets where relevant, and partner with IT to develop and implement projects to access external data for one-time and/or recurring needs.
• Issue Management & Root Cause Analysis
• Investigate data issues reported by business users or discovered through monitoring.
• Perform root cause analysis to identify process, system, or integration gaps.
• Partner with IT, product, and operations teams to implement corrective actions or system enhancements.
• Data Governance & Standards
• Support enterprise data governance frameworks, including data catalogs, definitions, lineage, and stewardship.
• Ensure compliance with internal data management policies as well as investor/regulatory obligations (Freddie Mac, Fannie Mae, HUD, etc.).
• Reporting & Documentation
• Manage key annual external reporting submissions.
• Produce regular reporting on data quality trends, KPIs, and remediation progress.
• Document business-side data flows and processes, and propose new definitions.
• Visualization
• Partner with technology MSP to leverage internal data and integrate external data sets.
• Utilize mapping visualization application (preference is PolicyMap) to generate high impact analysis for use in internal and external collateral.
• Cross‑Functional Collaboration
• Work with business and technology teams to ensure correct data capture and system behavior.
• Participate in data migration, system implementations, and integrations, where relevant.
• Support automation and AI initiatives by providing validated, high‑quality data inputs.

Skills and Experience

• Master’s degree in Information Systems, Finance, Data Analytics, Business, or related field preferred.
• 2–5+ years of experience in data quality, business analysis, data governance, or data operations required.
• Experience using visualization applications to create high impact mapping/graphics required.
• Strong analytical mindset, attention to detail, and problem‑solving ability.
• Excellent communication skills, with the ability to collaborate across technical and non‑technical teams.
• Familiarity generating reports or inputs requiring data gathering from multiple functions.
• Familiarity with mortgage lending, servicing, or financial services workflows preferred.
• Experience developing and managing dashboards preferred.
• Experience with loan origination systems (LOS), servicing platforms, or ERP systems (e.g., NetSuite) preferred.
• Experience using IMPLAN a plus.
• Understanding of regulatory frameworks, publicly available data sets and/or partners generating key recurring reporting relevant to housing finance or CDFIs preferred.

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 https://communityp.com/about-us/careers/

This is a hybrid role where you will work from the Manhattan office two-three days a week. The salary range is $70,000 – $90,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.