JobCubby JobCubby
Sign up
Mohonk Mountain House

Data Analyst - Full Time, Year Round

Mohonk Mountain House New Paltz, New York, United States

Hospitality · 501-1,000 employees

2 h ago
data-analyst Mid (2-5 yrs) Full-time United States
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The analyst will track and report on hospitality performance metrics while designing automated dashboards for executive leadership. They are also responsible for synthesizing guest feedback and ensuring data quality across legacy platforms.

What they look for

SQL Tableau Power BI Looker Advanced Excel Data Visualization Business Intelligence Data Engineering Hospitality Metrics Property Management Systems Point of Sale Data Analysis Financial Reporting Database Integrity Spreadsheet Modeling

Requirements

Candidates must possess advanced SQL skills, proficiency in BI tools like Tableau or Power BI, and expert-level Excel capabilities. A bachelor's degree in a quantitative field such as Data Analytics, Statistics, or Finance is required.

Full description

Job Title: Resort Data Analyst

Location: Mohonk Mountain House, New Paltz, NY Department: Finance Employment Type: Full-Time on site

Job Summary

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.

Core Responsibilities

  • Performance Metrics: Track, analyze, and report on core hospitality metrics, including Occupancy rates, Average Daily Rate (ADR), RevPAR, and TrevPAR.
  • Operational Reporting: Evaluate labor efficiency, department payroll variances, and operational expenses against seasonal guest volume forecasts.
  • Dashboard Creation: Design, build, and maintain automated dashboards and data visualizations for department heads and executive leadership.
  • Guest Analytics: Synthesize feedback from post-stay satisfaction surveys, ticketing systems, and digital touchpoints to isolate areas for service improvement.
  • Data Quality: Extract, clean, and validate data across disjointed legacy platforms to ensure reporting accuracy and database integrity.

Required Technical Skills

  • SQL Mastery: Advanced ability to write complex queries, joins, and data transformations.
  • Business Intelligence Tools: Direct experience developing interactive reports in platforms like Tableau, Power BI, or Looker.
  • Advanced Excel: Expert-level capability with spreadsheet modeling, nested formulas, power queries, and macro automations.
  • Hospitality Systems: Hands-on familiarity with Property Management Systems (PMS) or Point of Sale (POS) tools is highly preferred.

Qualifications & Education

  • Education: Bachelor’s degree in Data Analytics, Statistics, Finance, Hospitality Management, or a related quantitative field.

Salary

$75,000+

Similar roles