Analyst, Business Intelligence
Role details
Job location
Tech stack
Job description
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. 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
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
- 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
Benefits & conditions
The RMR Group offers an extensive total rewards package to ensure that your benefits align with your needs. Employees who work at least 21 hours per week are eligible to participate in The RMR Group's benefits plans, including:
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life & Disability Insurance
- Health Savings Account (HSA) & Flexible Spending Plans (FSA)
- 401(k) Plan with Employer Match
- Holidays, Vacation & Sick Time
- Parental Leave
- Tuition Assistance
- Matching Gift Program
- Wide Array of Voluntary, Employee-Paid Benefits to choose from including Critical Illness & Accident Insurance, Identity Theft Protection & Pet Insurance
The estimated base compensation range for this position is $92,000 to $112,000 per year. RMR considers several components including an individual's skills, qualifications, experience, internal equity, and market data.