Senior Financial Analyst: Federal Housing P3 Modeling

Financeroles; Washington; Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

401(k) plan with matching company

Comprehensive Medical, Dental & Vision

Paid parental leave at 100% of salary

Paid Time Off and Company Holidays

Early access to earned wages through *

Job summary

JLL in Washington, DC, is seeking a Senior Financial Analyst to join the federal advisory program supporting the MHPI portfolio. You will build and run complex financial models for real estate restructurings, recapitalizations, and development analyses, translating deal structures into rigorous analyses for senior government decision-makers.

You will maintain templates, perform QA/QC, and present results for memos and client deliverables while collaborating with a multidisciplinary team.

Qualifications

• Bachelor’s degree in finance, real estate, economics, accounting, engineering, or related quantitative field.
• 3+ years of financial modeling experience in real estate, infrastructure, project finance, or related field; exceptional candidates with fewer years considered.
• Ability to build complex, multi-tab Excel models from scratch, including debt and equity waterfalls, DSCR and reserve analyses.
• US citizenship and 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.
• Detail-oriented with documented assumptions, sources, and changes; able to explain model logic to senior audiences.
• Preferred: DoD clearance eligibility; experience with public-private partnerships; VBA/Python for automation.

Responsibilities

• Build and maintain project-level financial models for real estate transactions incl. debt/equity waterfalls and returns.
• Create sensitivity and scenario layers to test capital structures and funding sources.
• Validate and reconcile third-party models and financial submissions.
• Maintain the program’s assumption library, standardized model templates, and version control.
• Apply QA/QC to models and document changes.
• Provide analytical support to portfolio-level performance reporting and KPI frameworks.
• Prepare model outputs and exhibits for decision memoranda and client deliverables.
• Collaborate with a multidisciplinary team and communicate model mechanics to non-modelers.

Skills

Financial modeling

Excel proficiency

Real estate finance

Communication

Attention to detail

DoD clearance

Education

Bachelor's degree in finance or related field

Tools

Excel (advanced)

VBA

Python

Job description

JLL in Washington, DC, is seeking a Senior Financial Analyst to join the federal advisory program supporting the MHPI portfolio. You will build and run complex financial models for real estate restructurings, recapitalizations, and development analyses, translating deal structures into rigorous analyses for senior government decision-makers.

You will maintain templates, perform QA/QC, and present results for memos and client deliverables while collaborating with a multidisciplinary team.