Analyst, Business Intelligence

The RMR Group•Newton, MA

6d•Onsite

About The Position

The Business Intelligence Analyst blends real estate strategy with advanced data analytics to optimize a national portfolio of hotel and senior living properties. This role leverages insights, automation tools, and dashboards to support performance and capital decisions. Ideal candidates excel at converting complex data into strategic action and thrive in collaborative, results-driven environments. As a member of the Business Intelligence team, the analyst works closely with asset management, operations, finance, and IT to deliver insights that drive performance, guide capital deployment, and maximize portfolio value.

Requirements

Bachelor’s degree in Business, Finance, Economics, Real Estate, Information Systems, data analytics or a related field
2+ years’ experience in asset management, real estate analytics, or BI/data roles
Ability to analyze and interpret monthly financials, including income, expenses, cash flow, and capital expenditures, to assess property and portfolio performance
Strong accounting, financial modeling, and analytical skills; high proficiency in Excel, Word, PowerPoint, and business intelligence tools (e.g., Tableau, Power BI)
Proven ability to analyze operations, identify opportunities, and drive profitability
Excellent written, oral, and presentation skills; strong stakeholder management and negotiation abilities
Self-motivated, able to manage multiple projects with minimal supervision, and deliver timely, accurate work

Nice To Haves

Experience in the real estate or hospitality/senior living industry is highly desirable
Proficiency in Power BI, SQL, Excel, and other scripting tools
Strong analytical thinking, curiosity with data, and ability to present insights visually
Exceptional organizational skills

Responsibilities

Design, build, and maintain interactive Power BI dashboards to visualize asset-level performance, financials, and project milestones
Utilize technologies such as SQL and Power Pivot to create operational databases and generate custom reports for asset managers and senior leadership
Automate routine financial, operating, and KPI reports to streamline weekly, monthly, and quarterly deliverables
Conduct variance analysis using advanced Excel models and BI tools to detect operational gaps
Integrate external market data into BI platforms to benchmark portfolio performance
Work closely with the Capital Team to manage capital tracking, renovation forecasts, and portfolio metrics
Support Ad-hoc analysis using large datasets across disparate systems, delivering digestible insights and executive summaries
Support ad hoc data modeling and visualization using Power BI and scripting tools (e.g., Python, Excel VBA)
Analyze monthly financials, forecasts, and budgets using automated reporting tools
Benchmark asset performance using industry datasets and competitor comparisons
Track property-level and portfolio-wide goals, performance indicators, and long-term project status
Participate in property site visits to evaluate progress against operational targets
Prepare meeting materials and collaborate with operators to follow up on strategic initiatives
Assist internal teams with tech-enabled solutions to track performance and goals
Contribute to hold/sell analysis, board presentations, and investment memos with embedded visualizations
Apply data models to support acquisition/disposition decisions and redevelopment projects
Manage inputs and Excel modeling for valuation, underwriting, and sensitivity testing