Revenue Systems Analyst

Cherry Valley Hotel; Connecticut; Remote; USD 65,000 - 80,000; Full time

Job summary

Cherry Valley Hotel is seeking a Revenue Systems Analyst to support the regional revenue team with daily/weekly reporting, pricing, and channel management. You will own analytics cadence, rate-shop parities, and ensure inventory accuracy across properties for RDORM decisions.

The role requires 1–3 years in hotel revenue management or analytics, strong Excel and familiarity with Marriott systems (One Yield, HPP, Bonvoy). Remote work within the U.S. is supported.

Qualifications

• 1–3 years in hotel revenue management, reservations, or analytics.
• Strong Excel skills with pivot tables and summaries.
• Familiarity with Marriott systems (One Yield, HPP, Bonvoy) and STR benchmarking.
• Highly organized with deadlines and ability to manage cadence across properties.
• Clear written communication for recaps and flagging risks to leadership.

Responsibilities

• Pull daily pickup, revenue, and ADR reports; monitor pace vs. targets.
• Rate-shop comp sets and audit rates for the next 90 days.
• Produce group pickup, window, and channel-mix reports; weekly summaries.
• Audit rate loading, content accuracy, and distribution across OTAs.
• Coordinate rate loading and package promotions across properties.

Skills

Excel

Data analysis

Hotel revenue management

Multi-property coordination

Communication

Tools

One Yield

HPP

Bonvoy

STR benchmarking

Job description

MMC
641 Danbury Rd
Ridgefield, CT 06877, USA

Description

Revenue Systems Analyst

Position Summary: The Revenue Systems Analyst supports the regional revenue team by executing the daily and weekly reporting, pricing, systems, and channel-management tasks that keep each property's revenue strategy running. The role owns the recurring analytics cadence (pickup, pace, STR, comp-set rate shopping), shops rate pricing and inventory accuracy across systems and OTAs, manages packages and promotions, and coordinates rate and demand information across properties. Findings and risks are flagged to the RDORM to inform strategic decisions.

Accountabilities:

Reporting & Analytics

• 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.

Systems

• 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.

Package & Program Management

• 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.

Cross-Property Coordination

• 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.

Qualification Standards

Education & Experience:

• At least 1-3 years in hotel revenue management, reservations, or analytics; multi-property experience a plus.
• 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.

Location: Remote (U.S. - based)

Salary Requirements

This position offers an annual base salary range of$65,000–$80,000 USD, based on experience and qualifications.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights https://www.eeoc.gov/poster

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.