Data Analyst - Full Time, Year Round at Mohonk Mountain House | NY, US | Rezi

Data Analyst - Full Time, Year Round at Mohonk Mountain House

Data Analyst - Full Time, Year Round

Mohonk Mountain House · NY, US

1 weeks ago

Data Analyst - Full Time, Year Round

Mohonk Mountain House · NY, US

8 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

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.