• Own, and architect, and build internal datasets for business intelligence reporting • Manage existing infrastructure such as ingestion of data from MySql database to Big Query, Curation of semantic layer between raw source data and Power BI,, internal CRM database, Power Query (M Language), Salesforce, etc. • Build automated, accurate reporting dashboards • Designing, developing, and maintaining business intelligence solutions using Power BI • Manage consumption and access of Power BI reporting across the company • Manage and improve existing data models and relationships • Create DAX based calculations and resolve issues • Resolve any issues related to loops and hierarchy • Create and review models and KPIs • Create and review visualizations • Mature BI model to allow for users to build their own reports (self service) • Work cross-functionally to improve business intelligence architecture and reporting • Troubleshoot and resolve issues related to performance, environments, monitoring and operability of Power BI reports. • Build and manage relationships with key stakeholders across business and IT organizations. • Implement enterprise grade best practices in data ingestion, semantic layer, and reporting layer

• Analyze the impact of member growth, retention and movement on Star Ratings working with claims, clinical and quality data • Develop insights that inform business strategies and operational improvements to support Star Rating goals • Prepare high-quality, data-driven materials for VP and senior leadership discussions • Participate in strategic conversations, providing actionable insights and recommendations • Communicate complex analytical findings in a clear and compelling manner to non-technical audiences • Collaborate with cross-functional teams to assess and enhance Stars performance • Act as a subject matter expert, explaining the intricacies of Stars methodology and metrics • Create executive-level dashboards and presentations that showcase key metrics, trends and improvement opportunities • Ensure data accuracy, consistency and clarity in all reporting and analysis

Own the design and deployment of Power BI dashboards, analyze marketing and sales data to track conversion rates, and collaborate with global teams to provide actionable insights for revenue operations.

Title: Senior Investor Reporting Analyst (Commercial Mortgage Servicing/Multifamily Housing) Location: Chappaqua Office - Chappaqua, NY Department: Portfolio Services 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 hybrid role where you will work from the Chappaqua office two – three days a week. 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.