Strategy Consultant Real Estate Projects

1. Model Development for Real Estate Projects:
o Design and build comprehensive, dynamic financial models for real estate development projects.
o Include detailed cashflow projections covering pre-development, construction, financing, operations, and exit phases.
o Develop and integrate GP/LP waterfall structures with flexible promote arrangements into the models.
2. Financial Analysis:
o Calculate and analyze key real estate financial metrics, including project and investor-level internal rates of return (IRRs) and equity multiples.
o Perform sensitivity analyses to assess the impact of various financial, operational, and market variables on project outcomes.
3. Real Estate Transaction, Business Case and Procurement Strategies
o Provide insights on commercial, financial, funding, planning and policy related topics associated with infrastructure and real estate development while demonstrating deep understanding of real estate market conditions and performance benchmarks as well as advise clients accordingly
o Provide insights to advise clients on various real estate transaction components (for example: acquisitions, dispositions, master developments, master lease/tenant arrangements, sale-leaseback), business case development, procurement strategies and procurement activities (e.g. market sounding with real estate developers, drafting of commercial elements of RFQ/P, pre-development agreements, development agreements)
4. Affordable Housing Expertise:
o Develop models that accurately calculate low-income housing tax credits and incorporate applicable fee structures.
o Understand and integrate the specific financial nuances and compliance requirements associated with affordable housing projects.
5. Collaboration and Support:
o Work closely with the engagement teams to test model, validate assumptions, and ensure model accuracy.
o Provide ongoing support and model updates as projects progress through various stages.

Qualifications:
Bachelor s or master s degree in finance, Real Estate, Economics, or a related field.
Minimum of 5 years of experience in real estate financial modeling, preferably with a focus on both market-rate and affordable housing projects.
Proficiency in Microsoft Excel, with the ability to create complex formulas, macros, and data visualizations.
Deep understanding of real estate finance concepts, including GP/LP structures, waterfall distributions, and promote mechanisms.
Expertise in low-income housing tax credits (LIHTCs) and associated financial structures.
Strong analytical skills and attention to detail.
Excellent communication and presentation abilities.
Ability to work independently and manage multiple projects simultaneously.

Preferred:
Professional certifications such as CFA, CAIA, or similar.
Knowledge of current market trends and regulatory changes in both market-rate and affordable housing sectors.
No travel required