Data Analyst - Revenue & Collections

About the role

Career Directions Limited (CDL) is hiring a Data Analyst for Revenue & Collections in Nairobi. The role analyses property, booking, revenue, payment and operational data to improve revenue performance, strengthen collections, reduce outstanding balances, identify revenue leakage and improve cash flow. It tracks collections against amounts billed or due, builds collection dashboards and gives management actionable insights.

Key responsibilities

• Monitor revenue collection across properties, clients and booking channels, and track billed amounts, outstanding balances, overdue payments and collection rates.
• Develop and maintain dashboards on collection performance, receivables ageing, overdue accounts and collection trends, and report regularly on collection targets and recovery progress.
• Identify delayed payments, unpaid invoices, underpayments and revenue leakage, and work with Finance, Revenue, Operations and Property Management teams to follow up on outstanding payments.
• Analyse property and portfolio performance using occupancy, ADR, RevPAR, booking pace and collection metrics, supporting pricing, forecasting and revenue management decisions.
• Reconcile booking, billing, payment and bank or payment-platform data, and clean, validate and reconcile data from PMS, OTAs, payment platforms, accounting systems and spreadsheets.
• Automate recurring reports and data preparation, and present clear findings and recommendations to management.

Required profile

• Bachelor's degree in Data Analytics, Business Analytics, Data Science, Finance, Accounting or a related field.
• At least 2-4 years of experience in data analysis, revenue analytics, business intelligence, financial reporting or receivables analysis.
• Demonstrable experience tracking collections, reconciling payments and monitoring overdue accounts.
• Experience in short-term rentals, serviced apartments, hotels, property management or real estate is an added advantage.

Required skills

• Advanced Excel or Google Sheets, including PivotTables and XLOOKUP.
• Power BI, Tableau or a similar data visualization tool.
• Working knowledge of SQL for data querying and analysis.
• Strong data cleaning, validation, reconciliation and reporting skills.