Real Estate Financial Modeler

Good Carbon Co.; Town of Tonawanda (NY); Hybride; USD 90 000 - 120 000; Plein temps

Avantages offerts par ce poste

Comprehensive benefits including medical and dental insurance

Flexible work-life balance

Professional growth opportunities

Performance-based compensation

Résumé du poste

A sustainable real estate firm is seeking an experienced Multifamily Real Estate Financial Modeler to support diverse financial functions, including underwriting and analysis. The candidate should have over five years of experience in multifamily real estate modeling, strong Excel skills, and the ability to leverage AI tools for efficient workflows. This role involves building complex financial models, conducting market research, and collaborating across teams to make data-driven decisions. A Bachelor's degree in relevant fields is required, along with excellent organizational and communication skills.

Qualifications

• 5+ years of experience in multifamily real estate modeling.
• Experience with transaction closings and due diligence.
• Strong understanding of financial planning and analysis processes.

Responsabilités

• Build and maintain complex financial models for multifamily properties.
• Conduct analysis on rent comps and market trends.
• Assist in project analysis and decision-making processes.

Connaissances

Excel modeling

Analytical skills

Understanding of multifamily metrics

Communication skills

Formation

Bachelor's degree in Finance, Real Estate, Economics, or related field

Outils

Microsoft Excel

AI tools

Real estate software (e.g., Yardi, MRI)

Description du poste

At Good Carbon Co, we believe good work starts with good people. As a rapidly growing leader in sustainable real estate development and construction, we’re not just imagining a better future — we’re building it. From development to construction to property management — we do it all, and you can help us shape what’s next.

Why You’ll Love Working Here:

• Collaborative, values-driven culture where every voice matters
• Clear opportunities for professional growth and advancement
• Flexibility and support for work-life balance
• Regular team events and community initiatives
• Comprehensive benefits: Employer-contributed medical and dental insurance; vision coverage; company 401(k) contributions; paid holidays and PTO-including your birthday!
• Competitive compensation including performance-based incentive eligibility

About the role:

We are seeking an experienced Multifamily Real Estate Financial Modeler to support underwriting, due diligence, transaction execution, financial planning and analysis, and related tax credits & incentives for multifamily acquisitions, value-add projects, new development deals, and portfolio-level decision making. This hybrid role requires strong Excel modeling skills, a solid understanding of multifamily operations, the ability to translate complex data into clear recommendations, and hands‑on experience assisting with closing processes and capital raising. The ideal candidate is also comfortable leveraging AI tools responsibly to accelerate model building, scenario analysis, and reporting workflows.

What you'll do:

• Build, refine, and maintain complex Excel-based financial models specifically for multifamily properties.
• Create detailed rent growth assumptions, leasing absorption, operating expense profiles, renovation budgets, capex schedules, and cash flow projections.
• Conduct sensitivity analyses, stress tests, IRR/NPV calculations, and capital stack modeling for multifamily investments.
• Underwrite value-add strategies by modeling unit turns, rent premiums, renovation timelines, and incremental revenue impacts.
• Build and maintain portfolio-level, business plan, and scenario models to support budgeting, forecasting, re-forecasts, and variance analysis across the finance function.
• Partner with Finance leadership to support FP&A activities including annual budgets, quarterly forecasts, capital planning, and performance tracking against plan.
• Leverage AI tools responsibly to accelerate model creation, automate repetitive analysis, improve data synthesis, and enhance reporting while maintaining sound judgment and model integrity.

Deal Underwriting & Analysis

• Analyze T-12s, rent rolls, leasing reports, OM packages, and market comps to develop accurate underwriting assumptions.
• Support acquisitions by preparing deal summaries, value-add analyses, stabilized pro formas, and return metrics.
• Perform market research on rent comps, absorption trends, operating expenses, and demographic drivers.
• Support transactions related to advances, bridge facilities and sales on tax credits.

Transaction & Closing Support

• Assist in due diligence: review third-party reports, track documentation, and integrate findings into the model.
• Help manage closing timelines, ensuring key deliverables and model updates are completed on schedule.
• Work closely with acquisitions, asset management, tax credit & incentive, capital raising and development teams preparing use case specific modelling
• Present model outputs in clear, professional formats for internal investment committees.
• Provide ongoing updates on deal status, underwriting findings, and projected returns.
• Support finance and operating teams with project analysis, portfolio performance, and phase‑gate or investment committee decision making.
• Prepare clear variance reporting and decision-support materials that connect underwriting, asset management, development, and finance perspectives.

Qualifications:

• 5+ years of experience building models in support of multifamily real estate (underwriting and acquisitions, development, or asset management).
• Experience building and designing interconnected modelling systems and processes that tie use cases together in a cohesive way to drive better decision making, reporting and execution.
• Experience establishing repeatable modeling processes that support governance, internal controls, and consistent decision‑ready reporting across stakeholders.
• Experience quantifying ITC and HTC tax credits, and assessing the impacts and tradeoffs of incentive programs on project sourcing and overall return on investment.
• Experience with affordable housing programs and financing mechanisms, including HUD programs, Low‑Income Housing Tax Credits (LIHTC) and state tax credit experience (e.g., SLICHT) preferred.
• Strong understanding of multifamily metrics, including cap rates, rent rolls, leasing assumptions, DSCR, expense ratios, IRR, cash‑on‑cash, waterfalls, and pro forma development.
• Experience supporting transaction closings, due diligence coordination, and lender deliverables.
• Experience supporting Financial Planning & Analysis processes such as budgeting, forecasting, variance analysis, and management reporting.
• Comfort using AI tools to support financial modeling, analysis, and workflow efficiency, with the ability to validate outputs and apply strong professional judgment.
• Excellent analytical, organization, and communication skills.
• Ability to work effectively independently (including in a remote environment if necessary).
• Expert‑level proficiency in Microsoft Excel and/or Google Sheets.
• Bachelor's degree in Finance, Real Estate, Economics, or related field.

Preferred Skills

• Experience with value‑add multifamily business plans.
• Familiarity with lease‑ups, renovation phasing, debt terms, JV structures, and capital budgeting.
• Experience with real estate and property management platforms such as Yardi, MRI, RealPage, or similar systems is a plus.
• Experience partnering across investment, development, asset management, and finance teams to build decision‑ready models and reporting.
• Curiosity and adaptability in applying emerging AI tools to financial analysis, model development, and presentation materials.

No immigration or work visa sponsorship provided for this position.