Senior Financial Analyst, MHPI Real Estate Modeling

JLL; Washington (District of Columbia); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

401(k) plan with match

Medical, Dental & Vision Care

Paid parental leave

Paid Time Off & Holidays

Early access to earned wages (DailyPay

Job summary

JLL is seeking a Senior Financial Analyst for the federal advisory program supporting MHPI, based in Washington, DC with hybrid work. The role builds and tests complex real estate financial models underpinning privatized military housing projects.

You will develop multi-tab financial models, run scenario analyses, and support portfolio reporting while documenting assumptions and maintaining templates for consistent analysis across the portfolio.

Qualifications

• Bachelor's degree in finance, real estate, economics, accounting, engineering, or a related quantitative field.
• 3+ years of financial modeling experience in real estate, infrastructure, project finance, or related field.
• Ability to build complex multi-tab Excel models from scratch, including debt and equity waterfalls, DSCR and reserve mechanics.
• US citizenship required.
• Ability to obtain a DoD Secret clearance.
• Strong understanding of real estate finance fundamentals: capital stacks, debt sizing and pricing, cash flow projections, returns analysis.
• Ability to explain model logic and results clearly to senior audiences who are not modelers.

Responsibilities

• Build and maintain project-level financial models for restructure, recapitalization, and development transactions including debt and equity waterfalls, coverage and reserve tests, refinancing analyses, and returns.
• Construct sensitivity and scenario layers to test alternative capital structures and operating assumptions; present results to senior decision-makers.
• Validate and reconcile third-party models and financial submissions; document findings.
• Maintain the program's assumption library, standardized templates, and version control to ensure consistency.
• Apply QA/QC: model integrity checks, source documentation, and change logs.
• Provide analytical support to portfolio-level performance reporting and KPI frameworks.
• Prepare model outputs, charts, and supporting exhibits for decision memoranda and client deliverables.
• Communicate model mechanics and results clearly to non-modelers within a multidisciplinary team.

Skills

Financial modeling

Excel advanced

Analytical thinking

Attention to detail

Written & verbal communication

US citizenship

DoD clearance eligibility

VBA / Python (tools)

Education

Bachelor's degree in finance, real estate, economics, accounting, engineering, or related quantitative field

Tools

VBA

Python

Job description

JLL is seeking a Senior Financial Analyst for the federal advisory program supporting MHPI, based in Washington, DC with hybrid work. The role builds and tests complex real estate financial models underpinning privatized military housing projects.

You will develop multi-tab financial models, run scenario analyses, and support portfolio reporting while documenting assumptions and maintaining templates for consistent analysis across the portfolio.