Sr. Director of Financial Analysis (Financial Modeling)

Job Summary We are seeking a highly specialized Sr. Director of Financial Analysis with extensive expertise in Real Estate Development & Investments. In this pivotal leadership role, you will design, architect, and oversee institutional-grade financial and feasibility models for ground-up developments, asset repositioning, joint ventures, and capital deployment across residential, commercial, and mixed-use portfolios. The ideal candidate possesses deep mastery of real estate development cash flows, waterfall equity structures, debt financing mechanics, and land acquisition feasibility. You will translate complex development variables—such as construction phasing, absorption rates, hard/soft costs, and financing terms—into clear, strategic quantitative insights for executive decision-makers, joint venture partners, and lenders. Key Responsibilities Real Estate Feasibility & Financial Modeling Architecture • Development Model Construction: Architect, build, and maintain institutional-grade dynamic financial models for complex real estate development projects (ground-up, master-planned developments, repositioning, and adaptive reuse). • Waterfall & Equity Structuring: Build and audit multi-tier equity waterfall models (LP/GP structures, promote mechanics, hurdle rates, clawbacks, and IRR distributions). • Capital Stack & Debt Optimization: Model project-level debt financing—including construction loans, mezzanine debt, bridge loans, and permanent financing—factoring in interest drawdowns, debt service coverage ratios (DSCR), and loan-to-cost (LTC) metrics. • Sensitivity & Scenario Planning: Perform robust sensitivity analyses on key development drivers (construction cost variances, delay impacts, cap rate movements, rent roll growth, absorption speed, and interest rate fluctuations). Project Lifecycle & Deal Support • Underwriting & Land Acquisition: Lead the financial underwriting for prospective land acquisitions, site assemblies, and development rights. Determine maximum land purchase prices based on target IRR and equity yield hurdles. • Cost Tracking & Variance Analysis: Partner with Development and Construction Management teams to integrate master budgets (hard costs, soft costs, contingency, and financing fees) into financial models and track variances against underwriting. • Investment Memos & Presentations: Translate complex modeling outputs into executive-level investment committee memos, lender pitch books, and investor reporting decks. Strategic Leadership & Governance • Modeling Standards & Quality Control: Establish standardized modeling guidelines, templates, and audit controls across the organization to eliminate logic errors and enhance forecasting accuracy. • Team Leadership: Build, manage, and mentor a team of real estate financial analysts and associates. • Cross-Functional Collaboration: Serve as the financial bridge between Development, Investment/Acquisitions, Design & Construction, Legal, and Accounting teams. Requirements & Qualifications Education & Professional Certifications • Bachelor’s Degree in Real Estate, Finance, Economics, Accounting, or Civil Engineering / Construction Management. • Master’s Degree (MS in Real Estate, MS in Real Estate Development - MSRED, or MBA in Finance) strongly preferred. • Certifications: CFA, AFM (Advanced Financial Modeler), or specialized Real Estate Financial Modeling accreditations (e.g., REFM, ACRE) are a strong plus. Experience • finance experience within Real Estate Development, Real Estate Private Equity (REPE), Investment Banking (Real Estate group), or Real Estate Consulting. • Direct experience modeling ground-up real estate developments across multiple asset classes (e.g., residential/multifamily, commercial, retail, industrial, or mixed-use). • 5+ years in a supervisory role managing analysts or modeling teams. Technical & Core Competencies • Advanced Financial Modeling: Expert in building 3-statement development models, discounted cash flow (DCF), net present value (NPV), yield-on-cost, internal rate of return (IRR), equity multiples (EM), and waterfall promotes. • Software Mastery: • Expert-level MS Excel (complex formulas, VBA, macros, scenario managers). • • Familiarity with BI tools (Power BI, Tableau) or SQL/Python for dataset analysis is a plus.

Bachelor’s Degree in Real Estate, Finance, Economics, Accounting, or Civil Engineering / Construction Management. Master’s Degree (MS in Real Estate, MS in Real Estate Development - MSRED, or MBA in Finance) strongly preferred. Certifications: CFA, AFM (Advanced Financial Modeler), or specialized Real Estate Financial Modeling accreditations (e.g., REFM, ACRE) are a strong plus. 5+ years in a supervisory role managing analysts or modeling teams.

Real Estate Feasibility & Financial Modeling Architecture: Develop institutional-grade financial models for complex real estate development projects (ground-up, master-planned developments, repositioning, adaptive reuse); Build and audit multi-tier equity waterfall models (LP/GP structures, promote mechanics, hurdle rates, clawbacks, IRR distributions); Model project-level debt financing including construction loans, mezzanine debt, bridge loans, and permanent financing with DSCR and LTC considerations; Conduct sensitivity and scenario planning on construction costs, delays, cap rates, rent growth, absorption, and interest rates. Project Lifecycle & Deal Support: Lead financial underwriting for land acquisitions and development rights; determine maximum land purchase prices based on target IRR and equity yield hurdles; Track variances against underwriting by integrating master budgets (hard costs, soft costs, contingency, financing fees); Prepare investment memos, lender pitch books, and investor decks. Strategic Leadership & Governance: Establish modeling standards, templates, and audit controls; Manage and mentor a team of real estate financial analysts and associates; Collaborate cross-functionally with Development, Investment/Acquisitions, Design & Construction, Legal, and Accounting.