Business Analyst

Business AnalystNorthgate 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 & ResponsibilitiesTranslate analysis into clear recommendations on pricing, inventory, and operational decisionsOwn recurring reports and processes end to end, including checking the numbers for accuracy before they go outSupport inventory management, pricing strategies, and demand planning effortsAssist with forecasting and budgeting across business unitsSummarize key insights and present findings to internal stakeholdersPartner with park employees to answer questions and support programsSupport cross-functional projects and departmental initiativesDevelop and maintain daily and weekly reports on site revenue, retail, food & beverage, and other revenue centersConduct ad-hoc analysis to support planning and operational decision-makingAnalyze historical performance data to identify trends, anomalies, and opportunitiesIdentify and escalate issues with data integrity or operational inconsistenciesGather, clean, and consolidate data from multiple sources (reservation system, point of sale, and park-level files) into reliable, analysis-ready formWork with data from our cloud data warehouse to support reporting and analysisBuild and maintain data models to support performance analysis and scenario planningAutomate data gathering, transformation, and reporting workflows using Power Query, Python, or other tools as appropriateBuilding out the backend of reservations management systems and point of sale systemsGeneral administrative duties and data entryParticipates in other projects and activities as assignedEducation/Training/Experience1–2 years of experience in a data analysis, business analysis, or hospitality operations role preferredBachelor's Degree in data analysis, statistics, finance, accounting, computer science, business, or a related field, or equivalent professional experienceAdvanced 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 toolsExperience 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 mustExperience with BI tools such as Tableau or Power BI is a plus, but not requiredExperience with reservation, POS, or pricing systems is helpful but not mandatoryQualifications/RequirementsSound business judgment: able to weigh tradeoffs and recommend a course of action, not just report the numbersExcellent communication and interpersonal skills, including the ability to explain findings clearly to people who aren't analystsCollaborative mindset with the ability to build working relationships across departments and at the park levelStrong analytical thinking and attention to detailAbility to manage multiple projects, prioritize tasks, and meet deadlinesProfessional demeanor with a strong work ethicResults-oriented with a strong sense of urgency and initiativeMust be able to work in a fast-paced office environmentEssential Physical DemandsRemain stationary for long periodsWalk and occasionally stand during shiftContinuously reach, bend, lift, carry, stoop and wipeAble to lift up to 20 lbsAble to manipulate fingers, hands, and arms to reach, carry, serve, etcAbility to look at a computer monitor for extended periodsNorthgate 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. Northgate Resorts