Our client is seeking a sharp, highly quantitative Commercial Real Estate Business Analyst to support both their investment/development underwriting pipelines and their commercial mortgage asset management portfolio. This dual-focus role requires an individual who can flawlessly model ground-up developments and value-add acquisitions using complex pro formas, audit and analyze multi-tenant commercial rent rolls, and spearhead the annual review process for their existing commercial mortgage portfolio. The ideal candidate is an advanced Excel modeler who understands how operational property data impacts credit risk and investment returns.

Key Responsibilities

1. Development & Acquisition Pro Forma Modeling

Financial Modeling: Build, maintain, and stress-test comprehensive, dynamic pro forma models in MS Excel for ground-up commercial developments (e.g., retail, industrial, office, multi-family) and value-add acqu...