Real Estate Financial Analyst

CABRERA CAPITAL PARTNERS LLC; Chicago (IL); On-site; USD 70,000 - 100,000; Full time

Job summary

Cabrera Capital Partners LLC in Chicago seeks a Real Estate Analyst to support sourcing, underwriting, and execution of deals across industrial, multifamily, student housing, and mixed-use properties. You will build and stress-test cash flow models and develop investment theses with senior leadership.

You will conduct primary and secondary market research, prepare investment committee materials, and assist in deal execution from LOI to close.

Qualifications

• Requires a Bachelor's degree in finance, real estate, economics, or related field.
• 2–4 years of experience at an institutional real estate firm or similar.
• Demonstrated experience owning financial models, not just populating templates.

Responsibilities

• Underwrite and build complex cash flow models across property types (industrial, multifamily, student housing, mixed-use).
• Develop and stress-test operating pro formas and investment return models (IRR, equity multiple, cash-on-cash).
• Conduct market research using institutional data sources and site visits; synthesize findings into investment theses and memoranda.
• Prepare investment committee materials and manage deal logs and databases.
• Support deal execution from LOI through closing and coordinate with lenders, brokers, and consultants.

Skills

Advanced Excel

PowerPoint

Python

VBA

AI tools

Written communication

Education

Bachelor's degree in finance, real estate, economics, or related analytical field

Tools

CoStar

Green Street

MSCI

Job description

ABOUT THE COMPANYCabrera Capital Partners is a national real estate development and investment platform focused on disciplined growth through long-term relationships. We partner with institutional capital and local stakeholders to originate and execute real estate opportunities across diverse markets. Our platform-driven strategy spans multiple real estate sectors, and emphasizes fundamentals, alignment, and repeatability, delivering durable assets and sustainable value.POSITION SUMMARY & PURPOSEThe real estate analyst is a core contributor to how we source, underwrite, and execute deals. You will work directly with senior leadership across the full transaction lifecycle, from initial market screening through investment committee approval and into asset management. The work is fast-moving, intellectually demanding, and consequential. We are a small team, which means your output matters immediately and visibility is high.ESSENTIAL DUTIES AND RESPONSIBILITIESUnderwriting & Financial AnalysisBuild and own complex cash flow models across property types including industrial, multifamily, student housing, and mixed‑useDevelop, review, and stress‑test operating pro formas and investment return models (IRR, equity multiple, cash‑on‑cash) across a range of capital structuresSensitize assumptions across key variables (e.g., rent growth, vacancy, cap rates, construction costs, financing terms) and translate outputs into relevant investment conclusionsSupport debt and equity structuring analysis, including joint venture and waterfall modelingMarket & Property ResearchConduct primary and secondary market research using institutional data platforms (e.g., CoStar, Green Street, MSCI, or equivalent), as well as site visits, broker conversations, and local market intelligenceSynthesize research into clear written investment theses and underwriting memoranda with a defined point of viewTrack sector, submarket, and competitive trends and maintain comparable and benchmarking analysesDeal Execution & Investment ProcessSupport transactions from initial screening through LOI, due diligence, and closingPrepare investment committee materials including executive summaries, underwriting exhibits, risk assessment, and recommendation frameworksCoordinate with third‑party consultants, brokers, lenders, and legal counsel throughout the diligence and closing processMaintain pipeline tracking, deal logs, and internal investment databasesProperty / JV / Platform FP&A & ReportingSupport property‑ and JV‑level financial performance analysis, connecting underwriting assumptions to actual and forecasted resultsAnalyze and communicate deal cash flows and partner economics, clearly showing sources and uses of capital across CCP and its partnersPrepare property, JV, and portfolio‑level reporting that explains performance, returns, and variance to plan for internal and external stakeholdersPresentation & CommunicationBuild polished, boardroom‑ready investment decks and IC approval materialsDistill complex financial and market analysis into clear, decision‑oriented narratives for senior leadership and external stakeholdersSupport preparation of materials for LP reporting, investor communications, and capital‑raising initiatives as neededMANAGEMENT & DECISION MAKING RESPONSIBILITIESOperates with a high degree of autonomy in financial analysis and deal support. Exercises judgment in underwriting assumptions, analytical framing, and investment recommendations provided to senior leadership.KNOWLEDGE, SKILLS & ABILITIES REQUIREMENTSTechnical SkillsAdvanced Excel required, including dynamic model‑building and the ability to build models from scratchPowerPoint fluency, with the ability to develop clear, well‑structured presentations that effectively communicate analysis and recommendationsAbility to automate repetitive analytical tasks (Python, VBA, or equivalent) is a meaningful differentiatorActively uses AI tools to accelerate research, drafting, and analysis, thoughtfully balancing their use with independent thinkingProfessional QualitiesExercises sound judgment, with the ability to identify key insights, prioritize relevant information, and filter out noise in both data and discussionsStrong written communication skills demonstrated through clear, analytical memos, emails, and presentation materialsResourceful and self‑directed, with a demonstrated ability to find answers independentlyIntellectual curiosity about markets, capital flows, and the drivers of real estate valueComfortable operating in ambiguous environments and building process where none existsDemonstrates persistence and follow‑through to bring work to completion without requiring close oversightEDUCATION & WORK EXPERIENCEBachelor’s degree required in finance, real estate, economics, or a related analytical field2-4 years of experience at an institutional real estate firm (investor, owner, operator, developer, REPE, REIT, or institutional advisory)Demonstrated experience owning financial models, not just populating templatesExposure to multiple property types and full‑cycle transaction experience through closing strongly preferredCFA candidacy, MSRE, or MBA a plus, but not requiredREQUIRED LICENSES & CERTIFICATESN/A