Retail CRE Underwriting Analyst - ARGUS Expert

ProPivotal; Needham (MA); Hybrid; USD 110,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401K with match

Comprehensive benefits

Job summary

ProPivotal in Needham, MA is seeking a hands-on financial modeling professional to support underwriting and forecasting for an existing retail portfolio. This role reports to senior leaders across Asset Management, Capital Markets, and Leasing.

You will build and maintain ARGUS models, refresh assumptions, and run scenarios to inform leasing, capital planning, and value creation. The position is hybrid with four days in Needham and one day remote.

Qualifications

• 3–5 years CRE experience in asset/portfolio management or underwriting.
• ARGUS Enterprise proficiency, able to build and maintain property models.
• Advanced Excel with real estate underwriting models.
• Familiar with DCF, IRR, NPV, lease economics, and debt analysis.
• Strong written and verbal communication; able to present to stakeholders.
• commuting to Needham four days per week.

Responsibilities

• Build and maintain ARGUS models for retail assets and underwriting.
• Refresh assumptions and roll updates into forecasts.
• Track results vs underwriting; explain variance drivers.
• Run risk and scenario analyses for portfolio decisions.
• Support lease reviews, deal economics, and TI/commissions/NPV/NER.
• Analyze capex and redevelopment for return on cost.
• Assist reforecast cycles with updated leasing and financing.
• Prepare concise materials for senior leadership and Investment Committee.
• Identify opportunities to streamline models and reporting cadence.

Skills

Financial modeling

Underwriting experience

Communication

Portfolio management

Analytical thinking

Tools

ARGUS Enterprise

Excel

Job description

ProPivotal in Needham, MA is seeking a hands-on financial modeling professional to support underwriting and forecasting for an existing retail portfolio. This role reports to senior leaders across Asset Management, Capital Markets, and Leasing.

You will build and maintain ARGUS models, refresh assumptions, and run scenarios to inform leasing, capital planning, and value creation. The position is hybrid with four days in Needham and one day remote.