Analyst

ensemble

Philadelphia (Philadelphia County)

On-site

USD 90,000 - 130,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

ensemble is seeking a data-driven Analyst to support the full real estate development and investment lifecycle. You will build underwriting models, analyze returns, and help finance, design, construction, leasing, and stabilization decisions.

Expect significant responsibility and exposure to decision-making processes in a fast-paced in-office role. The ideal candidate excels in Excel, understands real estate finance concepts, and embraces emerging AI tools like Claude to enhance research and

Qualifications

  • Bachelor's degree in Real Estate, Finance, Accounting, Economics, Business.
  • Advanced proficiency in Microsoft Excel and demonstrated experience building sophisticated financial models.
  • Strong understanding of real estate financial concepts (development costs, cash flows, debt/equity, IRR, cap rates).
  • Proficiency with ChatGPT and/or Claude for AI-assisted analysis in professional workflows.
  • Strong analytical and quantitative skills with exceptional attention to detail.

Responsibilities

  • Evaluate new development opportunities from initial concept through construction and stabilization.
  • Build, maintain, and update detailed project pro formas including sources/uses, budgets, financing, and cash flows.
  • Prepare acquisition underwriting models with purchase price analysis and financing assumptions.
  • Analyze project- and investment-level returns (IRR, equity multiples, cash-on-cash, NPV).
  • Conduct sensitivity and scenario analyses on rents, costs, timing, and terms.
  • Assist with financing analyses (construction loans, permanent financing, refinancings).
  • Maintain and improve financial models and develop new analytical tools as needed.
  • Prepare investment committee materials, lender presentations, and investor reports.
  • Review market studies, appraisals, budgets, and broker opinions.

Skills

Excel modeling
Real estate finance
Analytical thinking
AI tools (Claude/ChatGPT)
Attention to detail

Education

Bachelor's degree in Real Estate/Finance/Economics/Business

Tools

ARGUS Enterprise
Claude
ChatGPT

Job description

Description

The Analyst will work across the full real estate development and investment process—from evaluating new opportunities and building initial underwriting models through financing, design, construction, leasing, and stabilization. The right candidate will have the opportunity to develop into a well-rounded real estate professional with experience across the entire development and investment lifecycle.

Requirements
Qualities

The ideal candidate is highly proficient in Excel, has an understanding of real estate financial concepts, is intellectually curious, and is comfortable using emerging AI tools—including Claude—to improve the quality and efficiency of their work. The successful candidate will be someone who is smart, analytical, highly motivated, and genuinely interested in real estate. We are looking for someone who can do more than simply populate a model—they should understand what the model is telling them, recognize when something does not make sense, and be able to explain the implications to the broader team.

This is an in-office position and is intended for an individual who wants significant responsibility and exposure to real estate development and investment decision-making.

Key Responsibilities

Responsibilities include, but are not limited to

  • Supporting the development team in evaluating new development opportunities from initial concept through construction and stabilization.
  • Building, maintaining, and updating detailed project pro formas, including sources and uses, construction budgets, development costs, operating assumptions, financing, cash flows, and returns.
  • Preparing acquisition underwriting models for potential investments, including purchase price analysis, operating projections, financing assumptions, exit analysis, and investment returns.
  • Analyzing project-level and investment-level returns, including IRR, equity multiple, cash‑on‑cash returns, NPV, and development yield.
  • Performing sensitivity and scenario analyses around rents, construction costs, timing, financing terms, absorption, operating assumptions, exit values, and other key variables.
  • Assisting with financing analyses, including construction loans, permanent financing, refinancing, loan extensions, interest reserves, and debt sizing.
  • Maintaining and improving existing financial models and develop new analytical tools as needed.
  • Assisting with the preparation of investment committee materials, lender presentations, investor reports, and other financial analyses.
  • Reviewing and analyzing third‑party information, including market studies, appraisals, construction budgets, broker opinions, and comparable projects.
  • Tracking project performance against approved budgets and underwriting assumptions and identify material variances.
  • Conducting market research and analyzing comparable sales, rents, development activity, construction costs, and other relevant market data.
  • Assisting with due diligence and the organization and analysis of property‑level information.
  • Developing concise analyses and presentations that clearly communicate key findings to senior management.
  • Utilizing Claude and other AI tools to improve research, analysis, financial modeling workflows, document review, and productivity and Identifying opportunities to automate repetitive analytical and reporting tasks.
  • Developing effective AI‑assisted workflows while independently validating outputs and maintaining appropriate judgment and attention to detail.
  • Assist with ad hoc financial and strategic analysis across the company's portfolio and development pipeline.
  • Work with accounting, construction, property management, leasing, legal, and other internal and external teams as needed.
  • Support senior management with time‑sensitive analyses and special projects.
Qualifications
Required
  • Bachelor's degree in Real Estate, Finance, Accounting, Economics, Business, or a related discipline.
  • Advanced proficiency in Microsoft Excel and demonstrated experience building sophisticated financial models.
  • Strong understanding of real estate financial concepts, including development costs, operating cash flows, debt, equity, IRR, equity multiples, cap rates, and valuation.
  • Proficiency with ChatGPT and/or Claude, with an understanding of how to use AI tools effectively as part of a professional analytical workflow.
  • Strong analytical and quantitative skills with exceptional attention to detail.
  • Ability to organize large amounts of information and translate it into clear, concise analysis.
  • Ability to manage multiple projects and priorities in a fast‑paced environment.
Preferred
  • 2–3 years of experience in commercial real estate investments, real estate development, investment banking, private equity, lending, real estate consulting, or a related field.
  • Familiarity with ARGUS Enterprise a plus.
  • Experience underwriting commercial real estate development or acquisitions.
  • Experience with construction budgets and development schedules.
  • Experience with debt and equity underwriting.
  • Familiarity with commercial real estate market research and comparable property analysis.
  • Experience creating professional presentations and investment materials.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Associate, Real Estate Investments
Senior Associate, Real Estate Investments

Petiole Asset Management • New York (NY)

On-site
USD 120,000 - 180,000
Analyst
Analyst

Hines • Los Angeles (CA)

On-site
USD 97,300 - 111,900
Senior Financial Analyst
Senior Financial Analyst

Newmark • Los Angeles (CA)

On-site
USD 70,000 - 100,000
Real Estate Development Analyst — AI-Enhanced Modeling
Real Estate Development Analyst — AI-Enhanced Modeling

ensemble • Philadelphia

On-site
USD 90,000 - 130,000
Real Estate Analyst
Real Estate Analyst

Platinum Storage Group • Newport Beach (CA)

On-site
USD 65,000 - 95,000
Senior Analyst, Capital & Investments
Senior Analyst, Capital & Investments

Keller Augusta • Boston (MA)

On-site
USD 90,000 - 150,000
Real Estate Analyst (FTC, 12 mos)
Real Estate Analyst (FTC, 12 mos)

GreenLight Workforce Solutions Inc • San Francisco (CA)

Hybrid
USD 55,000 - 110,000
Investment Associate (Atlanta-Based)
Investment Associate (Atlanta-Based)

ACG Professionals, Inc. • Atlanta (GA)

On-site
USD 65,000 - 90,000
CRE Accounting Analyst - AI Evaluation Team
CRE Accounting Analyst - AI Evaluation Team

REAL • Boston (MA)

On-site
USD 70,000 - 90,000
Real Estate Researcher
Real Estate Researcher

MSCI Inc • New York (NY)

On-site
USD 120,000 - 180,000