Sr. Portfolio Analyst

The Senior Portfolio Analyst supports Office Properties Asset Management team by building and maintaining portfolio financial models, analytical tools, and automated workflows to drive portfolio performance and strategic decision-making. The role ensures data integrity across reporting systems, prepares investment materials, and leads process improvements. The Senior Portfolio Analyst also assists with underwriting for leases and capital projects, quarterly portfolio reviews, business plans, and market analysis.

Key Responsibilities: Develops and maintains financial, operating, and analytical models (Excel, Argus, Google Sheets) to support asset performance review, scenario analysis, and strategic decision-making Builds, maintains, and enhances automation tools, including Excel VBA macros and Google Sheets scripts, and leads process improvement initiatives involving workflow optimization, data governance, and business intelligence tool development Ensures data integrity and consistency across internal tools, templates, dashboards, and reporting systems for leasing, financial, capital, and operational information Provides analytical and underwriting support when evaluating leases, tenant credit worthiness, capital investments, new development projects, and acquisition opportunities Participates in quarterly property reviews and forecasts; creates summary reports including budget variances, occupancy and leasing updates, operating expenses, capital expenditures, and potential loan refinance implications Additional Skills: Superior Excel skills, including strong modeling capability; VBA and ARGUS experience preferred, but not required Experience with financial statement analysis and a strong understanding of corporate finance concepts Demonstrates ability to distill complex data, analyses, and trends into clear, concise written summaries and visual tools that enable stakeholders to understand key insights and takeaways quickly Strong written communication skills with the ability to translate quantitative findings into business-ready messaging Preferred Education: Bachelor’s Degree (or equivalent experience) Preferred Years of Relevant Work Experience: 2 - 5 years Compensation: Base Pay Range: $100,800.00 - $133,800.00 Actual placement within this range may vary based upon, but not limited to, relevant experience, time in role, base salary of internal peers, prior performance, business sector, and geographic location. The Company also offers competitive benefits for full time employees including paid time off, matching 401(k), and health benefits.