About the Role
We are looking for a skilled Data Analyst to support our property management
operations. The ideal candidate will have advanced proficiency in Microsoft Excel,
expertise in Power Query and Power BI, and experience extracting data from system
APIs to build dashboards that provide actionable insights for property management
decision-making.
- Work Schedule: Monday to Friday – Business Hours
- Hours per Week: 40 hours per week
- Hour Rate: $7-$9/ hr based on experience and skills
Responsibilities
Extract, clean, and transform data from property management systems and other APIs.
Buid and maintain Power BI dashboards to track occupancy, financial performance, maintenance requests, and other key metrics.
Develop advanced Excel models for reporting, forecasting, and analysis.
Analyze trends and patterns to support operational efficiency and strategic planning.
Collaborate with Property Managers, Accounting, and Operations teams to understand reporting needs and deliver actionable insights.
Ensure data accuracy, consistency, and timely updates in all reports and dashboards.
Requirements
Advanced Microsoft Excel skills (formulas, pivot tables, Power Query, data modeling).
Strong experience with Power BI – dashboard creation and data visualization.
Experience extracting and transforming data from APIs.
Analytical mindset with strong problem-solving skills.
Ability to work independently and remotely.
Excellent communication skills to present insights clearly
Preferred Qualifications:
Experience in property management or real estate analytics.
Knowledge of SQL or database management is a plus
About Our Partner Company
Global Hives is proud to partner with Real Property Management of the Rockies to support their hiring needs. RPM Rockies is a well-established property management company that has built a strong reputation across Northern Colorado. With more than 50 years of combined experience and a team that truly understands the local rental market, they manage hundreds of homes for individual owners, investors, and institutions.
Their team lives and works in the same communities they serve, which allows them to bring a personal, local perspective to every property they manage. They are experts in leasing, maintenance coordination, accounting, reporting, and compliance — and they are committed to delivering reliable service and positive experiences for both owners and residents.