Role Purpose
The Data Analyst Revenue & Collections will analyse property booking revenue payment and operational data to improve revenue performance strengthen revenue collection reduce outstanding balances identify revenue leakage and improve cash flow. The role will be responsible for tracking collections against amounts billed or due identifying payment delays and discrepancies developing collection performance dashboards and providing actionable insights to management to support timely revenue recovery and portfolio profitability.
Key Responsibilities
1. Revenue Collection & Outstanding Payments
- Monitor and analyse revenue collection across properties clients booking channels and other revenue sources.
- Track amounts billed amounts collected outstanding balances overdue payments and collection rates.
- Develop and maintain dashboards showing collection performance ageing of receivables overdue accounts and collection trends.
- Identify delayed payments unpaid invoices underpayments and discrepancies between expected and actual collections.
- Work with Finance Revenue Operations and Property Management teams to investigate collection gaps and support timely follow-up on outstanding payments.
- Analyse collection patterns and identify recurring causes of payment delays arrears and revenue losses.
- Reconcile booking billing payment and bank or payment-platform data to confirm that revenue due has been received and accurately recorded.
- Monitor collection targets and provide regular reports on collection performance outstanding balances and recovery progress.
- Identify revenue leakage unrecorded income and discrepancies between bookings charges invoices and payments recommending corrective action.
- Recommend data-driven measures to improve collection efficiency reduce overdue balances and strengthen cash flow.
2. Revenue & Property Performance Analysis
- Analyse property and portfolio performance using occupancy revenue Average Daily Rate (ADR) Revenue per Available Room (RevPAR) booking pace and collection metrics.
- Compare performance across properties locations booking channels and time periods to identify trends and opportunities for improvement.
- Support pricing forecasting and revenue management decisions using historical performance and demand data.
- Analyse revenue costs profitability and collection performance to assess the financial contribution of individual properties and the overall portfolio.
3. Reporting & Data Visualization
- Develop and maintain dashboards and weekly and monthly reports covering revenue generated collections outstanding balances arrears and property performance.
- Translate complex data into clear findings and practical recommendations for management.
- Monitor key performance indicators including collection rates overdue balances receivables ageing revenue variances and property profitability.
4. Data Quality Reconciliation & Automation
- Clean validate and reconcile data from Property Management Systems (PMS) online travel agencies (OTAs) payment platforms accounting systems and spreadsheets.
- Investigate and resolve discrepancies between bookings invoices expected revenue and actual payments.
- Automate recurring reports and data preparation processes to improve accuracy and reduce manual work.
- Collaborate with Finance Revenue Operations and Property Management teams to maintain accurate and consistent records.
Requirements
Qualifications & Experience
- Bachelors degree in Data Analytics Business Analytics Data Science Finance Accounting or a related field.
- At least 24 years of experience in data analysis revenue analytics business intelligence financial reporting or receivables analysis.
- Demonstrable experience tracking revenue collections reconciling payments analysing outstanding balances and monitoring overdue accounts is essential.
- Proven ability to analyse collection performance identify revenue discrepancies and provide insights that support improved collection rates and cash flow.
- Advanced proficiency in Excel or Google Sheets including PivotTables and XLOOKUP.
- Experience using Power BI Tableau or a similar data visualization tool.
- Working knowledge of SQL for data querying and analysis.
- Strong skills in data cleaning validation reconciliation and reporting.
- Strong analytical and problem-solving abilities with the capacity to turn data into actionable business recommendations.
- High attention to detail and strong communication skills including the ability to present findings to technical and non-technical stakeholders.
Added Advantage
- Experience in short-term rentals serviced apartments hotels property management or real estate.
- Familiarity with Airbnb Property Management Systems (PMS) payment platforms or accounting systems.
- Experience analysing accounts receivable payment ageing collection efficiency and revenue leakage.
- Advanced proficiency in Excel or Google Sheets including PivotTables and XLOOKUP. - Experience using Power BI Tableau or a similar data visualization tool. - Working knowledge of SQL for data querying and analysis. - Strong skills in data cleaning validation reconciliation and reporting. - Strong analytical and problem-solving abilities with the capacity to turn data into actionable business recommendations. - High attention to detail and strong communication skills including the ability to present findings to technical and non-technical stakeholders. - Experience in short-term rentals serviced apartments hotels property management or real estate. - Familiarity with Airbnb Property Management Systems (PMS) payment platforms or accounting systems. - Experience analysing accounts receivable payment ageing collection efficiency and revenue leakage.
Bachelors degree in Data Analytics Business Analytics Data Science Finance Accounting or a related field.- At least 24 years of experience in data analysis revenue analytics business intelligence financial reporting or receivables analysis.- Demonstrable experience tracking revenue collections reconciling payments analysing outstanding balances and monitoring overdue accounts is essential.- Proven ability to analyse collection performance identify revenue discrepancies
Job Location:
Monthly Salary:
Experience Required:
Posted:
Application Deadline:
Vacancies:
