Senior Analyst, Revenue Optimization
Vail Resorts · Broomfield, CO · Today
Hybrid$78k–$111k/yrFull-time
Job Responsibilities
- Analyze reservation and rental transaction trends across resorts to identify seasonality, demand drivers, and revenue performance patterns.
- Build and maintain demand forecasting models (e.g., regression, time series) and pricing bridges (e.g., subseason, geography, resort mix) to guide pricing and revenue decisions.
- Write Snowflake SQL queries and build Excel-based financial models to size new business opportunities, evaluate program performance, and support annual budget planning.
- Use Tableau Prep and Tableau Desktop to clean data and build dashboards that translate analysis into stakeholder-ready insights.
- Partner with Finance, Marketing, and Business Development to align forecasts, pricing recommendations, and new program business cases with broader business objectives.
- Present findings and recommendations to senior leadership in a clear, concise, and actionable format.
- Ensure data accuracy, completeness, and consistency across routine reporting and ad hoc analyses.
Job Requirements
- Bachelor's degree in Business, Economics, Statistics, Finance, or a related field, or equivalent practical experience.
- 3-5 years of experience in an analytical role, preferably in pricing, demand forecasting, or revenue optimization.
- Expertise in statistical forecasting techniques (e.g., regression, time series) applied to pricing and revenue strategy.
- Proficiency in Tableau Prep, Tableau Desktop, Python (pandas), and SQL (Snowflake preferred) for data analysis and automation.
- Advanced Microsoft Excel skills, including formula-driven financial modeling and Power Query, to build business cases and scenario analyses.
- Experience working with large, complex datasets to deliver clear, actionable recommendations.
- Strong organizational and time-management skills, with the ability to manage multiple concurrent projects.