Subject Matter Expert (SME), Investment Modeling
Core
Build financial models and templates for operating and development properties to support capital market business lines.
Role type
Senior IC investment modeling specialist
Builds
Financial models and templates for real estate assets
Domain
Commercial real estate investment analysis
Required skills
Financial modeling, Excel (advanced), Data analysis, Valuation (DCF, IRR, NPV), Three-statement analysis, Scenario analysis, VBA macros, Power Query
Preferred skills
CFA certification, Real estate domain expertise, Client communication
Technologies
Microsoft Excel, Internal CRM database
Responsibilities
Construct, maintain, and validate primary and secondary data sources; Create financial models from scratch for various property types; Extract insights from macroeconomic and industry data; Collaborate with global teams and stakeholders; Improve existing processes and present findings.