Data Quality & Reporting Analyst (Commercial Real Estate)

The Community Preservation Corporation • New York, NY

8h • $70,000 - $90,000 • Hybrid

About The Position

The Community Preservation Corporation (CPC) is seeking a Data Quality & Reporting Analyst to ensure the accuracy, completeness, consistency, and reliability of key data points across the organization’s systems and documentation. This role will also be responsible for delivering key enterprise-level reporting to external partners. The Analyst will collaborate with stakeholders from IT and business units on data integrity and digitization efforts. Additionally, the role involves monitoring standard industry and academic housing, economic, and community development data/report releases for integration and trend analysis opportunities, and generating geographic visualization outputs for impact and communication purposes.

Requirements

• 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.
• Applicants must be authorized to work in the United States.
• Candidates are responsible for ensuring they meet all minimum qualifications for the position at the time of application.

Nice To Haves

• Master’s degree in Information Systems, Finance, Data Analytics, Business, or related field preferred.
• 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.

Responsibilities

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

Benefits

• 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

What This Job Offers

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