Business Analyst

Northgate Resorts•Grand Rapids, MI

14h•Onsite

About The Position

Northgate Resorts is hiring a Business Analyst to support its revenue team in managing more than 9,000 cabin, RV, and tent sites across more than 35 locations. The role uses data analysis, performance evaluation, and system optimization to support pricing, inventory management, systems management, forecasting, and strategic revenue growth. This is a full-time, in-office position in Grand Rapids, Michigan, reporting to the Revenue Manager.

Requirements

One to two years of experience in data analysis, business analysis, or hospitality operations is preferred.
A bachelor’s degree in data analysis, statistics, finance, accounting, computer science, business, or a related field, or equivalent professional experience.
Advanced Excel skills, including Pivot Tables, Power Query, Data Modeling, Array Formulas, and 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.
Willingness to learn.
Sound business judgment, including the ability to weigh tradeoffs and recommend a course of action rather than just report numbers.
Excellent communication and interpersonal skills, including explaining findings clearly to people who are not analysts.
Collaborative mindset and ability to build working relationships across departments and at the park level.
Strong analytical thinking and attention to detail.
Ability to manage multiple projects, prioritize tasks, and meet deadlines.
Professional demeanor and strong work ethic.
Results-oriented approach with a strong sense of urgency and initiative.
Ability to work in a fast-paced office environment.
Ability to remain stationary for long periods, walk and occasionally stand during a shift, and continuously reach, bend, lift, carry, stoop, and wipe.
Ability to lift up to 20 pounds.
Ability to manipulate fingers, hands, and arms to reach, carry, serve, and perform related tasks.
Ability to look at a computer monitor for extended periods.

Nice To Haves

Familiarity with SQL or cloud data warehouses such as BigQuery.
Experience with BI tools such as Tableau or Power BI.
Experience with reservation, point-of-sale, or pricing systems.

Responsibilities

Translate analysis into clear recommendations on pricing, inventory, and operational decisions.
Own recurring reports and processes end to end, checking numbers for accuracy before distribution.
Support inventory management, pricing strategies, and demand planning.
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, food and beverage, 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 escalate data integrity issues or operational inconsistencies.
Gather, clean, and consolidate data from reservation systems, point-of-sale systems, and park-level files into reliable, analysis-ready form.
Use data from the cloud data warehouse for reporting and analysis.
Build and maintain data models for performance analysis and scenario planning.
Automate data gathering, transformation, and reporting workflows using Power Query, Python, or other appropriate tools.
Build out the backend of reservations management systems and point-of-sale systems.
Perform general administrative duties and data entry.
Participate in other projects and activities as assigned.