Real Estate and Impact Investments Analyst

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time. Job Purpose and Summary We are seeking a detail-oriented and proactive Real Estate and Impact Investment Strategy Analyst to provide critical support to the Asset, Investment and Awareness Managers in overseeing Aetna’s growing real estate investment portfolio and awareness strategy. This portfolio includes: Commercial mortgage loans Affordable housing equity investments Joint venture equity investments (JVs) The Analyst will provide analytical, reporting, and operational support to the Real Estate Investments (REI) and Impact Investment Strategy (IIS) teams, with primary responsibility for asset management–related activities across a diverse real estate and affordable housing investment portfolio. The Analyst will support the monitoring and performance of commercial mortgage loans, affordable housing equity investments (LIHTC investments), and joint venture equity investments, while also assisting with selected IIS activities related to reporting, awareness, and cross‑enterprise coordination. This role is designed for an early‑career professional (0–3 years of experience) and offers exposure to real estate asset management, impact investing, and enterprise collaboration. The Analyst will work closely with Asset Managers, Investment Managers, and senior IIS team members to ensure accurate reporting, strong portfolio oversight, and timely execution of internal and external deliverables. Primary Job Duties & Responsibilities Portfolio Support & Asset Management Assist in tracking and updating key performance metrics for commercial mortgage loans, affordable housing equity investments, and JV equity investments. Collect, organize, and review borrower, developer, and syndicator reporting to ensure completeness, accuracy, and timeliness. Support quarterly and annual asset reviews by preparing preliminary financial analyses, property performance summaries, and risk indicators. Maintain organized investment files and ensure accurate and consistent data entry across internal systems and reporting platforms. Assist with monitoring higher‑risk assets by compiling data, summarizing issues, and escalating findings to senior team members. Reporting, Forecasting & Financial Analysis Prepare draft portfolio reports, schedules, and presentation materials for internal stakeholders. Support basic financial modeling related to cash flows, net investment income, and tax benefit projections. Assist in reviewing capital call requests, budgets, and cash flow projections for affordable housing and JV investments. Help reconcile data across multiple sources to support accurate enterprise reporting. Investment Operations & Transaction Support Coordinate documentation related to post‑closing activities, including consent requests, loan modifications, and funding events. Assist with rate lock documentation, capital funding requests, and internal approval processes. Provide administrative and analytical support during underwriting, closing, and onboarding of new investments. Impact Investment Strategy & Awareness Support Support IIS reporting and information packages, including state and year‑end materials. Assist with maintaining IIS SharePoint content, trackers, and internal reference materials. Help compile information for internal enterprise requests related to impact investments and affordable housing initiatives. Provide analytical and organizational support for select events, presentations, and awareness initiatives led by senior IIS staff. Process Improvement & Special Projects Assist in identifying opportunities to streamline reporting processes and improve data quality. Support system updates, process documentation, and cross‑team coordination efforts. Participate in special projects, portfolio reviews, and ad‑hoc analyses as assigned. Education Required: Bachelor’s degree in Finance, Real Estate, Accounting, Economics, or a related field. Preferred: Coursework or exposure to real estate finance, affordable housing, or impact investing. Prior Relevant Work Experience Required: 0–3 years of relevant experience in finance, real estate, investment management, asset management, consulting, or a related analytical role (internships included). Essential Qualifications & Skills Knowledge of: Basic principles of real estate finance and investment analysis. Fundamental concepts related to affordable housing and LIHTC investments (or willingness to learn). Financial statements, budgeting, and cash flow analysis. Skill In: Strong analytical, quantitative, and organizational skills with high attention t Apply tot his job Apply To this Job