Portfolio Accounting Associate - ARGUS experience required

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

Benefits offered by this job

Health/Dental/Vision coverage

401K with match

Job summary

ProPivotal in Needham, MA is seeking a Portfolio Analyst with strong ARGUS proficiency to model and forecast across an owned retail real estate portfolio. You will own property-level underwriting, run scenarios, and translate performance into actionable recommendations for senior leadership.

The role offers hybrid work (4 days in Needham, 1 day remote) and a base pay of $110,000–$120,000 with a target bonus around 10 percent, plus comprehensive benefits including health/dental/vision and 401(k)

Qualifications

• 3 to 5 years of commercial real estate experience in asset management, portfolio management, acquisitions, valuation, or similar underwriting focused role.
• Strong ARGUS Enterprise skills with the ability to build, maintain, and modify property level models independently.
• Advanced Excel modeling skills with the ability to build real estate models from scratch.

Responsibilities

• Own and maintain property level underwriting across the portfolio, including ARGUS models and supporting Excel models
• Update leasing, operating, capital, and market assumptions and reforecast projected asset level returns
• Monitor performance versus underwriting and business plans, identify variances, and assess impact on value and returns
• Build scenario models, valuations, and buy hold sell refinance analyses to support decision making
• Partner with Asset Management and Leasing to evaluate renewals, new leases, tenant backfills, downtime, TI and LC, rent spreads, NPV, NER, and incremental returns
• Evaluate capital expenditures and redevelopment opportunities, including return on cost, incremental NOI, and value creation
• Support periodic reforecasting using actual performance and changes in leasing, capital plans, financing, and exit assumptions
• Prepare analyses and recommendations for senior leadership and Investment Committee discussions
• Improve portfolio reporting, models, and processes to increase visibility into performance, risks, and opportunities

Skills

ARGUS Enterprise

Excel modeling

Financial analysis

Tools

Excel

Job description

This opening is with our long-time partners, a national leading real estate portfolio management/owner/operation company with a focus on large-scalecommercial real estate. This is a great opportunity to support portfolio level forecasting, valuation, and investment decision making across an existing retail real estate portfolio. This is a hands on modeling role with strong visibility to senior leadership and cross functional partners in Asset Management, Capital Markets, and Leasing.

Please read - being up front here, this role is not for everyone. The team is looking for candidate who have strong ARGUS proficiency within their experience as a commercial real estate portfolio analyst/associate. Candidates applying without ARGUS will not be considered.

Key Details

• Work Arrangement: Hybrid with 4 days in the Needham office / 1 day work-from-home per week
• Pay Range: $110,000 to $120,000 base plus bonus target around 10 percent
• Strong company benefits: Health/Dental/Vision coverage. 401K with match, and more.

Why This Job is Awesome / Your Impact

• Newly created role due to growth with meaningful ownership of models and forecasts
• Exposure to leasing decisions, capital projects, refinancing, dispositions, and broader business plan initiatives
• You will translate property level performance into clear recommendations that influence investment and capital allocation decisions

Responsibilities

• Own and maintain property level underwriting across the portfolio, including ARGUS models and supporting Excel models
• Update leasing, operating, capital, and market assumptions and reforecast projected asset level returns
• Monitor performance versus underwriting and business plans, identify variances, and assess impact on value and returns
• Build scenario models, valuations, and buy hold sell refinance analyses to support decision making
• Partner with Asset Management and Leasing to evaluate renewals, new leases, tenant backfills, downtime, TI and LC, rent spreads, NPV, NER, and incremental returns
• Evaluate capital expenditures and redevelopment opportunities, including return on cost, incremental NOI, and value creation
• Support periodic reforecasting using actual performance and changes in leasing, capital plans, financing, and exit assumptions
• Prepare analyses and recommendations for senior leadership and Investment Committee discussions
• Improve portfolio reporting, models, and processes to increase visibility into performance, risks, and opportunities

Required Qualifications

• 3 to 5 years of commercial real estate experience in asset management, portfolio management, acquisitions, valuation, or similar underwriting focused role
• Strong ARGUS Enterprise skills with the ability to build, maintain, and modify property level models independently
• Advanced Excel modeling skills with the ability to build real estate models from scratch
• Solid understanding of underwriting and investment analysis including DCF, IRR, NPV, leasing economics, and debt and refinancing analysis
• Strong communication skills and the ability to present clear conclusions to stakeholders
• Able to commute to Needham four days per week