Strategic Real Estate Capital Markets Analyst

Ambrose Property Group; Indianapolis (IN); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Ambrose Property Group, a vertically integrated investment manager for Class A industrial, logistics, and e-commerce real estate, seeks a Financial & Capital Markets Analyst. The role combines financial modeling, underwriting, portfolio analytics, debt/equity execution support, and investor reporting across departments to drive data-driven investment decisions and capital formation.

The analyst will build and maintain models, perform scenario analyses, track debt/equity transactions, and support

Qualifications

• Bachelor’s degree in Finance, Real Estate, Economics, Accounting, or related field is required.
• 2–5 years of experience in real estate investment, development, acquisitions, banking, or private equity.
• Strong Excel financial modeling skills and understanding of commercial real estate.
• Familiarity with Argus, Juniper Square, DealPath, Maybern, and similar real estate tech platforms is preferred.
• Strong written and verbal communication skills and able to manage multiple priorities.

Responsibilities

• Create, update, and maintain detailed financial models for development and acquisition opportunities.
• Perform sensitivity analyses and scenario planning to support investment decisions.
• Underwrite land acquisitions, speculative developments, build-to-suit projects, and acquisitions.
• Support disposition underwriting and project capitalization strategies.
• Build dashboards and reporting tools to support portfolio analysis.
• Build debt packages summarizing financing opportunities and lender comparisons.
• Track debt and equity transactions across funds and joint ventures.
• Support capital raising initiatives, fund forecasting, and capital planning efforts.
• Aggregate and analyze property-, portfolio-, and fund-level performance.
• Maintain fund models, forecasting tools, and performance reporting.
• Prepare Investment Committee memorandums, deal summaries, and investment presentations.
• Support quarterly and annual investor reporting packages.
• Maintain underwriting templates and reporting standards.
• Assist with DDQs, investor requests, and data room management.
• Manage CRM systems and support investor onboarding activities.

Skills

Financial modeling

Real estate analysis

Excel

Communication skills

Multitasking

Education

Bachelor’s degree in Finance, Real Estate, Economics, Accounting, or related field

Tools

Argus

Juniper Square

DealPath

Maybern

Job description

Ambrose Property Group, a vertically integrated investment manager for Class A industrial, logistics, and e-commerce real estate, seeks a Financial & Capital Markets Analyst. The role combines financial modeling, underwriting, portfolio analytics, debt/equity execution support, and investor reporting across departments to drive data-driven investment decisions and capital formation.

The analyst will build and maintain models, perform scenario analyses, track debt/equity transactions, and support