Real Estate Portfolio Analyst – Underwriting & Forecasting

Waterstone Properties Group; Needham (MA); On-site; USD 90,000 - 120,000; Full time

Job summary

Waterstone Properties Group, Inc. is seeking a Portfolio Analyst to provide financial analysis and underwriting support for its retail real estate portfolio in Needham, MA.

The role focuses on property-level forecasting, portfolio monitoring, and investment decision-making, collaborating with Asset Management, Capital Markets, Leasing and senior leadership. The analyst will own underwriting models, assess leasing decisions, CAPEX opportunities, and capital events, translating property

Qualifications

• Bachelor's degree in Finance, Economics, data science or a related field.
• 3-5 years of relevant commercial real estate experience, preferably in asset management or portfolio management.
• Strong ARGUS Enterprise and advanced Excel modeling skills.
• Solid understanding of DCF, IRR/NPV, leasing economics, debt/refinancing analysis.

Responsibilities

• Own and maintain property-level underwriting across the portfolio using ARGUS models and Excel.
• Monitor performance, variances, and impact on asset values and returns.
• Perform buy/hold/sell/refinance analyses and scenario modeling.
• Underwrite leasing decisions with leasing team, renewals, backfills, TI/LC, rent spreads, NPV, and incremental returns.
• Evaluate capex, redevelopment opportunities and impact on asset returns.
• Support business-plan execution with reforecasting and performance updates.
• Develop analyses and recommendations for senior management and Investment Committee.
• Improve portfolio-level reporting, models, and processes.

Skills

Analytical thinking

Attention to detail

Communication

Independent work

Education

Bachelor's degree in Finance, Economics, data science or a related field

Tools

ARGUS Enterprise

Excel

Job description

Waterstone Properties Group, Inc. is seeking a Portfolio Analyst to provide financial analysis and underwriting support for its retail real estate portfolio in Needham, MA.

The role focuses on property-level forecasting, portfolio monitoring, and investment decision-making, collaborating with Asset Management, Capital Markets, Leasing and senior leadership. The analyst will own underwriting models, assess leasing decisions, CAPEX opportunities, and capital events, translating property