Sr. Business Analyst - Portfolio Analytics

Senior Business Analyst – Portfolio Analytics Realty Income is hiring a Senior Business Analyst to support data‑driven decision making across the organization by translating complex portfolio and transaction data into clear, actionable insights. Responsibilities Manage and maintain the portfolio transaction pipeline, ensuring accurate, timely, consistent tracking of leasing, disposition, and vacancy activity to support forecasting and executive reporting. Own and support recurring reporting deliverables & ad‑hoc analysis derived from the transaction pipeline, including scenario analysis, variance explanations, and management‑level summaries. Coordinate data collection from multiple stakeholders, ensuring consistency across deliverables. Execute the cash flow projection process that reports the financial performance of transaction activity and the aggregate portfolio. Aggregate, transform, and interpret data from disparate sources to create reporting packages, business intelligence dashboards, and summary write‑ups. Review and maintain the accuracy, completeness, and consistency of portfolio data utilized in internal and public reporting materials. Support the development and deployment of business intelligence, data visualization, and financial analytics tools. Identify, extract, and summarize noteworthy data for use in management commentary regarding past and future expected portfolio performance. Stay current on data, analytics, AI tools, and process improvement practices, applying new ideas where they add value. Perform additional duties and ad‑hoc projects as needed to support the Portfolio Analytics function. Qualifications Bachelor’s degree in a business, analytical, or technical field. At least three years of prior work experience in a professional environment, ideally within finance or real estate industries. Advanced Microsoft Excel proficiency, including complex formula development (INDEX/MATCH, XLOOKUP, SUMIFS, IF/IFS/IFERROR), building dynamic PivotTables, and Power Query. Proven ability to apply emerging AI tools to enhance data analysis, reporting workflows, and process automation. Experience building, maintaining, and troubleshooting large, complex data models supporting portfolio‑level analysis, forecasting, and reporting. Ability to understand and apply financial concepts such as net present value, internal rate of return, and discounted cash flow analysis. Excellent attention to detail and curiosity toward data validation and trend recognition. General proficiency with M365 applications (PowerPoint, Outlook, etc.). Experience with Power BI or other BI software a plus. Proficiency with SQL and broad understanding of relational database principles a plus. Experience designing and deploying data reporting, data visualization, and business intelligence solutions with direct end‑user collaboration a plus. Location & Remote Based in San Diego (Del Mar Heights) headquarters. Monday through Thursday are in‑office; Friday remote is an option. Compensation Salary range: $76,286 – $86,661 – $102,125. Includes annual discretionary bonus and stock award opportunities. Benefits Best‑in‑class benefits package including healthcare, dental, vision; 401(k) plan with company match 50% up to 6% of eligible compensation; generous PTO, 12 paid holidays, paid volunteer time. Equal Opportunity Employer Realty Income is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. #J-18808-Ljbffr Realty Income Corporation