Revenue Systems Analyst

Summary

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

Qualifications

Must Haves

• 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

Nice to Haves

• multi-property experience a plus

Benefits

• Remote (U.S. - based)