Data Analyst-Real Estate&Revenue
Posted Updated 3
views
Summary
A Nairobi-based data analyst role analyzing property, booking, and revenue data (occupancy, ADR, RevPAR) to improve pricing, forecasting, and portfolio performance. Day to day involves building dashboards and reports in Excel, Power BI/Tableau, and SQL, cleaning data from PMS/OTAs, and automating reporting for management.
The Data Analyst will analyze property, booking, revenue and operational data to provide actionable insights that improve occupancy, pricing, revenue and portfolio performance.
Key Responsibilities
● Analyze property and portfolio performance across occupancy, revenue, ADR, RevPAR
and booking pace.
● Build and maintain dashboards and weekly/monthly performance reports.
● Clean, validate and reconcile data from PMS, OTAs and spreadsheets.
● Identify trends, anomalies and data gaps, and explain their causes.
● Compare performance across properties, locations, channels and time periods.
● Support pricing, forecasting and revenue decisions using demand and historical data.
● Analyze revenue, costs and profitability where data is available.
● Automate reporting to reduce manual data preparation.
● Present clear insights and recommendations to management.
● Work with Revenue, Operations, Finance and Property Management teams to maintain
data quality.
Requirements
Qualifications
● Bachelor's degree in Data Analytics, Business Analytics or Data Science.
● At least 2–4 years of experience in data analysis, business intelligence, revenue analytics or real estate analytics.
● Advanced Excel / Google Sheets skills, including PivotTables, XLOOKUP.
● Experience with Power BI, Tableau or a similar visualization tool.
● Working knowledge of SQL.
● Strong data cleaning, validation and visualization skills.
● Strong analytical and problem-solving skills, with the ability to explain what the data means, not just report it.
● High attention to detail in identifying and resolving data inconsistencies.
● Strong communication skills, with the ability to present findings to technical and non-technical audiences.
● Experience in short-term rentals, serviced apartments, hotels or property management is an added advantage.
● Familiarity with booking platforms such as Airbnb, Booking.com or PMS systems is an added advantage.