Business Intelligence Analyst at Prime Group… · Saratoga…

Summary: Prime Group Holdings, LLC is a private equity real estate firm specializing in self-storage and alternative real estate asset classes. The Business Intelligence Analyst will be responsible for financial planning, reporting, forecasting, and operational analysis to support a portfolio of self-storage assets across the U.S. and Canada. Responsibilities: - Develop, maintain, and automate dashboards and reports for operational and financial performance - Build KPI scorecards for: Store Managers, District Managers, Regional Vice Presidents, Executive Leadership - Maintain Reporting for: Occupancy, Lead generation and conversion, Payroll productivity, Delinquency, Customer acquisition, Marketing ROI - Standardize reporting processes and improve data consistency across the organization - Ensure timely and accurate distribution of recurring operational reports - Analyze performance trends across the self storage portfolio and identify actionable opportunities - Evaluate underperforming assets and recommend operational improvements - Conduct root-cause analysis on KPI variances and operational issues - Support operational initiatives through data analysis and performance tracking - Identify opportunities to improve efficiency, customer experience, and profitability - Integrate and validate data from multiple systems including: CRM Platforms, Call Center Systems, Auction Platforms, Marketing Platforms, ERP/Accounting systems - Assist in maintaining data integrity and reporting governance - Collaborate with IT and third-party vendors on reporting enhancements and system improvements - Support creation of centralized operational 'control tower' reporting - Partner closely with: Field Operations, Revenue Management, Marketing, FP&A, Customer Service Center - Translate complex datasets into clear operational recommendations - Train stakeholders on dashboards and reporting tools Required Qualifications: - Bachelor's degree in Business, Finance, Economics, Data Analytics, Information Systems, Statistics, or related field required - 1–5+ years of experience in business intelligence, operations analysis, FP&A, consulting, analytics, or related roles - Advanced Microsoft Excel skills required - Ability to analyze large datasets and identify trends - Familiarity with operational KPI reporting and dashboard development - Understanding of property-level financial statements and operational KPIs - Strong analytical and problem-solving skills - High attention to detail and accuracy - Ability to communicate financial concepts to non-financial stakeholders - Strong executive presence and presentation skills - Self-starter with ability to manage multiple priorities in a fast-paced environment - Highly organized with strong follow-through Preferred Qualifications: - Experience in self storage, retail, hospitality, real estate, or other multi-site operations preferred - Experience with BI and visualization tools such as Microsoft Power BI and Tableau - Experience with SQL is a plus - Experience with data automation and ETL concepts is a plus Required Skills: Microsoft Excel, Microsoft Power BI, Tableau, SQL, Data Automation, ETL, Operational KPI Reporting, Dashboard Development, Financial Statement Analysis, Data Analysis Benefits: Competitive pay, Health, dental, life, vision, short-term disability and long-term disability insurance, A 401(k) program with a company “matching” policy, Paid time off and paid holidays, Career advancement opportunities