Listing and Revenue Analyst Short Term Rental (STR)

Virtual Assistant – Listing & Data Analyst (Excel Expert + STR Platforms)
Company: Prestige Retreats Vacation Home Rentals LLC
Location: Remote (Philippines)
Work Hours: Flexible, with some overlap with Dubai time
Salary: Competitive + performance bonuses
Long-term role

About the Company
Prestige Retreats is a luxury holiday home operator in Dubai, managing premium properties in Emaar Beachfront, Dubai Marina, and Dubai Harbour. We are known for 5-star hospitality, high occupancy rates, and top-tier property management standards. As we grow, we need a highly skilled VA who is strong in data analysis, Excel, pivot tables, and reporting.

Position Overview
We are hiring a Listing & Data Analyst VA who is an Excel expert and comfortable analyzing large datasets, building reports, and optimizing property performance. You will manage ---------- listings, track KPIs, build professional Owner Reports, and support operations with accurate data and insights.
This is a long-term role with growth opportunities (Revenue Manager, Data Lead, Operations Analyst).

Key Responsibilities
1. Data Analysis & Excel Reporting (Primary)


Build and manage detailed reports in Excel/Google Sheets


Create and update pivot tables, pivot charts, VLOOKUP/XLOOKUP, INDEX-MATCH


Perform data cleaning, reconciliation, and performance analysis


Track KPIs: ADR, RevPAR, occupancy, conversion rates, channel performance


Build dashboards for revenue, expenses, and trends


2. Owner Reporting


Prepare monthly Owner Reports for each managed property


Reconcile all booking sources: Airbnb, ---------- , Hostaway, direct bookings


Generate payout summaries, net owner revenue, and expense logs


Present data in clean, professional, easy-to-read formats


3. Listing Management


Create, update, and optimize listings on Airbnb, ---------- , Vrbo, and Hostaway


Maintain consistent property data, amenities, titles, and descriptions


Improve listing SEO, ranking, and conversion rate


4. Competitor & Market Analysis


Monitor similar listings daily/weekly


Identify pricing opportunities and amenity gaps


Track seasonal trends, special events, occupancy shifts


Provide insights for pricing decisions


5. Pricing & Yield Support


Assist in managing PriceLabs (or similar dynamic pricing tools)


Flag rate changes and seasonal adjustments


Support revenue strategy across all platforms


6. Operational Support


Monitor tasks in Hostaway


Assist in vendor cost entry, invoice logging, and expense tracking


Maintain internal dashboards and databases



Required Qualifications


EXPERT–LEVEL Excel/Google Sheets skills


Pivot tables


Pivot charts


VLOOKUP / XLOOKUP


INDEX-MATCH


SUMIFS / COUNTIFS


Data cleaning & transformation




Strong analytical and problem-solving skills


Experience in short-term rentals ( ---------- ) preferred


Excellent written English


Ability to handle numbers, accuracy, reconciliation, and reporting


Fast learner with strong attention to detail


Organized, proactive, and reliable



Preferred (Not Required)


Experience with:


Hostaway PMS


PriceLabs


Airbnb, ---------- , Vrbo


Canva (basic listing graphics)




STR or e-commerce analytics background



What We Offer


Long-term, stable position with consistent workload


Competitive salary (based on skills + Excel test)


Performance bonuses for accuracy and speed


Training for STR tools (Hostaway, PriceLabs)


Opportunity to work with a luxury brand in Dubai


Career growth into revenue management or operations



How to Apply
Send the following:


Resume


1–2 minute video introduction


Excel sample work (pivot table or dashboard preferred)


Your experience with Airbnb/STR (if any)


Expected monthly salary (PHP)



Email Subject:
VA – Excel Expert & Data Analyst | Prestige Retreats

If you want, I can also create:
? An Excel skills test (with downloadable file)
? An applicant scoring rubric
? A filtering questionnaire for OnlineJobs.ph
Just let me know!