Data Analyst - Full Time, Year Round

Mohonk Mountain House • New Paltz, NY

5d • Onsite

About The Position

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.

Requirements

• Advanced ability to write complex queries, joins, and data transformations (SQL Mastery).
• Direct experience developing interactive reports in platforms like Tableau, Power BI, or Looker (Business Intelligence Tools).
• Expert-level capability with spreadsheet modeling, nested formulas, power queries, and macro automations (Advanced Excel).
• Bachelor’s degree in Data Analytics, Statistics, Finance, Hospitality Management, or a related quantitative field.

Nice To Haves

• Hands-on familiarity with Property Management Systems (PMS) or Point of Sale (POS) tools is highly preferred.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level