About the Role
We are seeking an analytical and detail-oriented Resort Data Analyst to join our Business Intelligence team. In this role, you will transform raw data from guest bookings, point-of-sale systems, and operational metrics into actionable business strategies. Your analysis will directly influence our pricing models, labor efficiency, operations, and overall guest satisfaction. The ideal candidate bridges the gap between technical data engineering and executive decision-making.
Responsibilities
- Track, analyze, and report on core hospitality metrics, including Occupancy rates, Average Daily Rate (ADR), RevPAR, and TrevPAR.
- Evaluate labor efficiency, department payroll variances, and operational expenses against seasonal guest volume forecasts.
- Design, build, and maintain automated dashboards and data visualizations for department heads and executive leadership.
- Synthesize feedback from post-stay satisfaction surveys, ticketing systems, and digital touchpoints to isolate areas for service improvement.
- Extract, clean, and validate data across disjointed legacy platforms to ensure reporting accuracy and database integrity.
Requirements
- Advanced ability to write complex SQL queries, joins, and data transformations.
- Direct experience developing interactive reports in platforms like Tableau, Power BI, or Looker.
- Expert-level capability with Excel spreadsheet modeling, nested formulas, power queries, and macro automations.
- Hands-on familiarity with Property Management Systems (PMS) or Point of Sale (POS) tools is highly preferred.
Skills
- SQL
- Business Intelligence Tools
- Tableau
- Power BI
- Looker
- Advanced Excel
- Excel Spreadsheet Modeling
- Nested Formulas
- Power Queries
- Macro Automations
- Property Management Systems (PMS)
- Point of Sale (POS)
Location
- Mohonk Mountain House, New Paltz, NY
Work Type
- Full-Time
- On-site
Education Level
- Bachelor’s degree in Data Analytics, Statistics, Finance, Hospitality Management, or a related quantitative field.
Salary/Compensations
- $75,000+
About the Company
- Mohonk Mountain House is a luxury resort located in New Paltz, NY.
