Note: The job is a remote job and is open to candidates in USA. New Castle Hotels & Resorts is seeking a Revenue Systems Analyst to support its regional revenue team across multiple properties. The role manages recurring reporting and analytics, pricing audits, revenue systems, OTA and channel-management tasks, package programs, and cross-property coordination while flagging findings and risks to revenue leadership.
Responsibilities
- Pull daily pickup reports (rooms, revenue, ADR vs. prior year) and monitor pace against target
- Rate-shop the comp set in Spider, flag rate anomalies, and audit rates for the next 90 days
- Produce group pickup, booking-window, and channel-mix reports; compile weekly pickup/pace summaries by hotel for the RDORM
- Download and maintain STR data (weekly, week-over-week, and monthly) and One Yield Demand Extract / OTB reports
- Condense revenue call notes into a formatted, bullet-point meeting recap; process Bonvoy reimbursement reports
- Audit segment mappings in Lighthouse to keep integrity of reporting and rate structure accurate
- Run Brand Production reports and input STR data into STR.com by segmentation (including F&B where applicable)
- Build and maintain weekly Revenue Workbooks for all hotels and save to the shared folder
- Assist with rate loading for Legacy Marriott hotels in HPP for corporate accounts and other segments
- Audit retail rates and derived rate tiers for accuracy across all properties
- Monitor overbooking and oversold (K-date) exposure daily; flag risks to the RDORM
- Check availability and content daily across Expedia, Booking.com, and brand.com
- Review weekly commission reports (Amadeus CRS / MI Commissions Mgt.) and track brand.com promotion participation (member rates, flash deals)
- Attend quarterly OTA Market Manager calls and send recaps to the RDORM
- Manage rate loading, GDS rate loading and channel activation
- Confirm active packages load and book correctly (e.g., Gas & Go); monitor romance/experiences package pickup and conversion
- Track package expiration dates and flag upcoming sunsets to the RDORM
- Support new package builds: rate-code setup, QA, and deployment
- Track events in each hotel region up to 365 days out; maintain the special-event calendar and flag demand periods and displacement risk
- Review rate alignment across comparable brands in each market
- Communicate pricing and package changes to property revenue contacts and share best practices with property teams
Skills
- At least 1-3 years in hotel revenue management, reservations, or analytics
- Strong Excel Skills (workbook, pivot/summary reporting) and comfortable managing large recurring data pulls
- Familiarity with Marriott Systems (One Yield, HPP, Bonvoy) plus other brands and STR benchmarking; ability to learn new tools quickly
- Highly organized and deadline driven, able to manage a fixed daily/weekly cadence across multiple properties
- Detail oriented with strong data accuracy; clear written communication for recaps and flagging risks to leadership
- Multi-property experience a plus
Benefits
- Remote (U.S. - based)
Company Overview