Business Analyst
Posted 2
views
Summary
In-office Business Analyst in Grand Rapids, MI supporting the revenue team of a camp-resort operator: building and owning recurring reports, analyzing pricing/inventory performance, forecasting, and automating data workflows using Excel, Power Query, Python, SQL, and cloud data warehousing.
Northgate Resorts owns and manages the most awarded Camp-Resort portfolio in the nation. Our passion is creating family camping memories for our guests – memories that will last a lifetime! We don’t do this as individuals but as a passionate team that cares about making a difference in our guests’ lives. We endeavor to be a highly effective, lean, and fast-moving organization.
The Business Analyst will utilize their analytical skills to assist the revenue team in managing Northgate Resorts’ 9,000+ cabin, RV, and tent sites across 35+ locations. This role will support pricing, inventory management, systems management, forecasting, and strategic revenue growth through high-quality data analysis, performance evaluation, and system optimization. This is a full-time, in-office position located in Grand Rapids, Michigan, reporting to the Revenue Manager.
DUTIES & RESPONSIBILITIES
The Business Analyst will utilize their analytical skills to assist the revenue team in managing Northgate Resorts’ 9,000+ cabin, RV, and tent sites across 35+ locations. This role will support pricing, inventory management, systems management, forecasting, and strategic revenue growth through high-quality data analysis, performance evaluation, and system optimization. This is a full-time, in-office position located in Grand Rapids, Michigan, reporting to the Revenue Manager.
DUTIES & 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, food & 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 issues with data integrity or operational inconsistencies
- Gather, clean, and consolidate data from multiple sources (reservation system, point of sale, and park-level files) 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
EDUCATION/TRAINING/EXPERIENCE
- 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
- Advanced Excel 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 (such as BigQuery) is a plus; a willingness to learn is a must
- Experience with BI tools such as Tableau or Power BI is a plus, but not required
- Experience with reservation, POS, or pricing systems is helpful but not mandatory
QUALIFICATIONS/REQUIREMENTS
- Sound business judgment: able to weigh tradeoffs and recommend a course of action, not just report the numbers
- Excellent communication and interpersonal skills, including the ability to explain findings clearly to people who aren’t analysts
- Collaborative mindset with the 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 with a strong work ethic
- Results-oriented with a strong sense of urgency and initiative
- Must be able to work in a fast-paced office environment
ESSENTIAL PHYSICAL DEMANDS
- Remain stationary for long periods
- Walk and occasionally stand during shift
- Continuously reach, bend, lift, carry, stoop and wipe
- Able to lift up to 20 lbs
- Able to manipulate fingers, hands, and arms to reach, carry, serve, etc
- Ability to look at a computer monitor for extended periods
Northgate provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. Northgate is also a proud participant of the E-Verify Program.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.