Hospitality Revenue Analyst: Pricing & Forecasting

Northgate Resorts; Grand Rapids (MI); On-site; USD 65,000 - 90,000; Full time

Job summary

Northgate Resorts in Grand Rapids, MI is seeking a Business Analyst to support the revenue team with pricing, inventory, forecasting, and data-driven decision making across 35+ locations.

You will own recurring reports, validate data integrity, build models in Excel/Power Query and BI tools, and partner with park teams to translate insights into actionable recommendations.

This in-office role reports to the Revenue Manager and requires 1–2 years of data analytics or hospitality experience.

Qualifications

• 1–2 years of experience in a data analysis, business analysis, or hospitality operations role preferred.
• Bachelor’s Degree in data analysis, statistics, finance, accounting, computer science, business, or a related field, or equivalent professional experience.
• AdvancedExcel skills required (Pivot Tables, Power Query, Data Modeling, Array Formulas, Charting).
• Familiarity with Google Workspace (G-Suite).
• Experience with data modeling and forecasting techniques in Excel or similar tools.
• Experience cleaning and consolidating data from multiple sources using Power Query, SQL, Python, or similar tools; familiarity with SQL or cloud data warehouses (BigQuery) is a plus.

Responsibilities

• Translate analysis into clear recommendations on pricing, inventory, and operational decisions
• Own recurring reports and processes end to end, including checking the numbers for accuracy before they go out
• Support inventory management, pricing strategies, and demand planning efforts
• Assist with forecasting and budgeting across business units
• Summarize key insights and present findings to internal stakeholders
• Partner with park employees to answer questions and support programs
• Support cross-functional projects and departmental initiatives
• Develop and maintain daily and weekly reports on site revenue, retail, F&B, and other revenue centers
• Conduct ad-hoc analysis to support planning and operational decision-making
• Analyze historical performance data to identify trends, anomalies, and opportunities
• Identify and elevate issues with data integrity or operational inconsistencies
• Gather, clean, and consolidate data from multiple sources into reliable, analysis-ready form
• Work with data from our cloud data warehouse to support reporting and analysis
• Build and maintain data models to support performance analysis and scenario planning
• Automate data gathering, transformation, and reporting workflows using Power Query, Python, or other tools as appropriate
• Building out the backend of reservations management systems and point of sale systems
• General administrative duties and data entry
• Participates in other projects and activities as assigned

Skills

Analytical thinking

Communication

Multitasking

Collaboration

Attention to detail

Education

Bachelor's degree in data analysis, statistics, finance, accounting, computer science, business, or related field

Equivalent professional experience

Tools

Excel

Power Query

SQL

Python

Tableau/Power BI

BigQuery

Job description

Northgate Resorts in Grand Rapids, MI is seeking a Business Analyst to support the revenue team with pricing, inventory, forecasting, and data-driven decision making across 35+ locations.

You will own recurring reports, validate data integrity, build models in Excel/Power Query and BI tools, and partner with park teams to translate insights into actionable recommendations.

This in-office role reports to the Revenue Manager and requires 1–2 years of data analytics or hospitality experience.