Business Analyst

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 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 Big. Query) 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.