{bc}
indeed

Business Analyst

Northgate Resorts
Grand Rapids, USA
Full-time
Mid-Senior
Onsite
USD 50000-60000 yearly
Discovered 4 days ago
Advanced Excel, including Pivot Tables, Power Query, data modeling, array formulas, and chartingData analysis and performance evaluationReporting and data quality checksData modeling and forecastingData cleaning and consolidationGoogle Workspace

Full Job Posting

Role overview

The Business Analyst supports revenue management for more than 9,000 cabin, RV, and tent sites across 35+ resort locations.

This is a full-time, in-office position in Grand Rapids, Michigan, reporting to the Revenue Manager.

The role supports pricing, inventory management, forecasting, performance analysis, and system optimization.

Responsibilities

  • Translate analysis into recommendations on pricing, inventory, and operational decisions; own recurring reports and verify accuracy.
  • Support inventory management, pricing strategies, demand planning, forecasting, and budgeting.
  • Present findings to internal stakeholders, partner with park employees, and support cross-functional initiatives.
  • Produce daily and weekly reports on site revenue, retail, food and beverage, and other revenue centers.
  • Analyze historical performance, conduct ad hoc analysis, and identify trends, anomalies, opportunities, and data integrity issues.
  • Gather, clean, and consolidate data from reservation, point-of-sale, and park-level sources; use cloud warehouse data for analysis.
  • Build data models and automate data gathering, transformation, and reporting workflows using Power Query, Python, or other appropriate tools.
  • Help build the backend of reservation management and point-of-sale systems.
  • Perform general administrative duties and data entry; take part in other assigned projects.

Education and experience

  • Bachelor’s degree in data analysis, statistics, finance, accounting, computer science, business, or a related field, or equivalent professional experience.
  • 1–2 years in data analysis, business analysis, or hospitality operations is preferred.
  • Experience with data modeling and forecasting in Excel or similar tools.
  • Experience cleaning and consolidating multiple data sources using Power Query, SQL, Python, or similar tools.

Required and preferred skills

  • Advanced Excel is required, including Pivot Tables, Power Query, data modeling, array formulas, and charting.
  • Google Workspace familiarity is requested.
  • SQL or cloud data warehouse familiarity, such as BigQuery, is a plus; willingness to learn is required.
  • Tableau or Power BI experience is a plus, not required.
  • Reservation, POS, or pricing system experience is helpful but not mandatory.
  • The role calls for business judgment, analytical thinking, attention to detail, clear communication, collaboration, prioritization, and deadline management.

Physical demands

  • The posting describes extended periods stationary and looking at a computer monitor, with occasional walking and standing.
  • Physical demands also include reaching, bending, lifting, carrying, stooping, and wiping, including lifting up to 20 pounds.

Compensation

  • The stated salary range is $50,000–$60,000 per year.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Northgate Resorts