Senior Financial Analyst / Financial Modeling – Federal Housing P3 Program

JLL; Washington (District of Columbia); Hybrid; USD 90,000 - 130,000; Full time

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

Skills

Financial modeling

Advanced Excel

Attention to detail

Quantitative analysis

Communication

Education

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

Tools

VBA

Python

Job description

Senior Financial Analyst - JLL

Senior Financial Analyst - JLL

What this job involves:

JLL is seeking a Senior Financial Analyst to join the financial modeling function of a federal advisory program supporting Department-wide privatized military housing portfolio. This is a hands-on, build-and-run modeling and program advisory role consisting of constructing, maintaining, and stress-testing financial models that underpin restructure, recapitalization, and new development analyses across a multibillion-dollar public-private partnership portfolio. You will work under the direction of the program's senior transactions and federal financial management advisors, translating deal structures and analytical questions into rigorous, well-documented models that senior government decision-makers rely on before public funds are committed. The role suits a strong analyst who wants deep exposure to complex real estate capital structures and public-sector deal-making.

What your day-to-day will look like

• Build and maintain project-level financial models for real estate restructure, recapitalization, and development transactions, including debt and equity waterfalls, coverage and reserve tests, refinancing analyses, and returns
• 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

Required 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 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

Preferred Qualifications

• Prior DoD clearance eligibility
• Experience with public-private partnerships, project finance, federal advisory work, or military housing / MHPI is a meaningful advantage but not required
• Expert-level Excel; experience with VBA, Python, or similar tools for model automation and data handling is a plus

Location

Based in Washington DC (hybrid with regular presence at JLL offices and client sites as program needs require)

About the Program

The Military Housing Privatization Initiative (MHPI) is one of the largest public-private partnership real estate programs in the United States: a portfolio of roughly $32 billion in privatized family and unaccompanied housing spanning 87 projects at approximately 150 military installations. The Office of the Deputy Assistant Secretary of War for Housing (ODASW(H)) oversees the program and has shifted from passive portfolio oversight to active investment management, with a live pipeline of project restructures, recapitalizations, and new unaccompanied housing development, each requiring a capital-structure optimization strategy before public funds are committed. JLL serves as the principal advisory team to ODASW(H), providing program management and advisory support across the full spectrum of MHPI oversight. The financial modeling function sits at the center of the program's transactions advisory workflow: it establishes the baseline model for each transaction, builds the sensitivity and scenario layers used to test and rank alternatives, and maintains the assumption libraries and templates that keep analysis consistent across the portfolio.