Senior Financial Analyst / Financial Modeling – Federal Housing P3 Program

Jones Lang LaSalle Incorporated; Washington (District of Columbia); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Jones Lang LaSalle Incorporated is seeking a Senior Financial Analyst to join the federal MHPI advisory program in Washington, DC. You will build and stress-test complex financial models supporting privatized military housing transactions and provide analytical input for decision-makers.

The role requires a Bachelor’s in a quantitative field, 3+ years of financial modeling, advanced Excel (DSCR, waterfalls), and DoD clearance eligibility.

Qualifications

• Bachelor’s degree required in a quantitative field.
• 3+ years of financial modeling experience in real estate or related sectors.
• Ability to build multi-tab Excel models with cash flow, DSCR, and waterfalls.
• US citizenship and ability to obtain DoD Secret clearance.

Responsibilities

• Build and maintain project-level financial models for real estate restructure, recapitalization, and development transactions.
• Create sensitivity and scenario analyses to test capital structures and funding sources.
• Validate third-party models and document findings with clear change logs.
• Support portfolio-level performance reporting and KPI frameworks.
• Prepare model outputs and exhibits for memoranda and client deliverables.
• Collaborate with a multidisciplinary team and communicate model mechanics clearly.

Skills

Financial modeling

Advanced Excel

US citizenship

DoD clearance eligibility

Analytical communication

Education

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

Tools

VBA

Python

Python

Job description

## Senior Financial Analyst / Financial Modeling – Federal Housing P3 ProgramApply: On-site: Washington, DC: Full time: Posted Today: REQ538624**JLL empowers you to shape a brighter way**.Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.**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.This position does not provide visa sponsorship. Candidates must be authorized to work in the United States without sponsorship. **Expected compensation for this position:** 85,000.00 – 110,000.00 USD per year *Final compensation packages are determined by various considerations including but not limited to candidate qualifications, location, market conditions, and internal considerations.*