Real Estate Portfolio Analyst - Affordable Housing

Arc70 Capital LLC; Burlingame (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Arc70 Capital LLC in Burlingame, CA seeks a Portfolio Analyst to support portfolio management across real estate investments, with 2-5+ years’ experience. You will monitor construction funding, benchmark asset performance, and update financial models.

The role involves coordinating with capital markets, managing deal flow, and generating investor reporting. Ideal candidates have strong Excel/PowerPoint skills, familiarity with AH housing, and comfort with high-pressure deadlines.

Qualifications

• Strong problem solving and resourcefulness.
• Attention to detail with quantitative/financial modeling skills.
• Ability to work in a high pressure environment and meet deadlines.
• Fluency in Excel/PowerPoint; Python/AI tools a bonus.

Responsibilities

• Monitor and approve construction funding and asset stabilization.
• Benchmark portfolio assets against underwritten proforma and update models.
• Collaborate with capital markets to optimize financing of assets.
• Manage deal pipeline across funds.
• Maintain the master datatapes for the portfolio’s assets.
• Monitor cash liquidity and net income; decide on capital calls and distributions.
• Update investment cash flow schedules.
• Build and present complex financial models to PM.
• Conduct market research on AH bonds and securitization to value assets.
• Evaluate special opportunities including secondaries and distressed debt.
• Create presentations, memorandums, and investor reports.
• Support asset, portfolio, and risk management across funds.

Skills

Problem solving

Financial modeling

Attention to detail

Excel

PowerPoint

Python/AI tools

Tools

Python

Job description

Arc70 Capital LLC in Burlingame, CA seeks a Portfolio Analyst to support portfolio management across real estate investments, with 2-5+ years’ experience. You will monitor construction funding, benchmark asset performance, and update financial models.

The role involves coordinating with capital markets, managing deal flow, and generating investor reporting. Ideal candidates have strong Excel/PowerPoint skills, familiarity with AH housing, and comfort with high-pressure deadlines.