Senior Real Estate Finance Analyst, Public-Private MHPI

JLL

Washington (District of Columbia)

Hybrid

USD 90,000 - 130,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

JLL in Washington, DC is seeking a Senior Financial Analyst to join the financial modeling function supporting the MHPI portfolio and federal advisory program. This hands-on role builds, tests, and documents complex real estate finance models used to inform capital restructurings and new developments for a multibillion-dollar public-private partnership portfolio.

The ideal candidate will have 3+ years in financial modeling within real estate or project finance, strong Excel skills, and US

Qualifications

Bachelor's degree in finance, real estate, economics, accounting, engineering, or a closely related quantitative field.
3+ years of financial modeling experience in real estate, infrastructure, project finance, or a closely related field; exceptional candidates with fewer years considered
Demonstrated ability to build complex, multi-tab Excel models from scratch, including debt and equity waterfalls, DSCR and reserve mechanics, refinancing and sensitivity analyses
US citizenship
Ability to obtain a DoD Secret clearance
Strong understanding of real estate finance fundamentals: capital stacks, debt sizing and pricing, cash flow projections, and returns analysis
Rigorous attention to detail and a habit of documenting assumptions, sources, and changes
Ability to explain model logic and results clearly, in writing and in conversation, to senior audiences who are not modelers

Responsibilities

Build and maintain project-level financial models for real estate restructure, recapitalization, and development transactions.
Construct sensitivity and scenario layers that test alternative capital structures, funding sources, and operating assumptions, and present results in a form senior decision-makers can act on
Validate and reconcile third-party models and financial submissions, identify assumption gaps and errors, and document findings
Maintain the program's assumption library, standardized model templates, and version control so that analysis is consistent, traceable, and auditable across transactions
Apply disciplined QA/QC to your own and others' work: model integrity checks, source documentation, and clear change logs
Provide analytical support to portfolio-level performance reporting and key performance indicator frameworks
Prepare model outputs, charts, and supporting exhibits for decision memoranda, briefings, and client deliverables
Work as part of a multidisciplinary team of transaction, credit, policy, and development specialists, and communicate model mechanics and results clearly to non-modelers