← back to jobs
> job detail
V
📊Analyst

Senior Analyst, Revenue Optimization (Broomfield, CO, US)

Vail Resorts · Broomfield, CO, US
// classified as
Analyst (Dashboards, reporting, ad-hoc analysis.)
posted
1d ago
location
Broomfield, CO, US
languages
python, sql
tools
excel, snowflake, tableau
> stack
pythonsqlexcelsnowflaketableaupandas
> description
<p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Our mission is to create the Experience of a Lifetime for our employees, so they can, in turn, create the Experience of a Lifetime for our guests. We own and operate the most renowned destination resorts in the world as well as regional and local ski areas outside major cities, and connect them all through one unrivaled network. We are looking for ambitious leaders, innovators and creators to join our talented team. If you’re ready to pursue your fullest potential, we want to get to know you!</span></p> <p> </p> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">Candidates for year-round positions are reviewed on a rolling basis. Applications will be accepted up to 90 days after the posting date, or until the position is filled (whichever is first).</span></p> <p> </p><div> <div> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong><span>Job Summary:</span> </strong></span></p> <p style="margin:0.0in;line-height:normal;background-color:white;font-size:11.0pt;font-family:Aptos, sans-serif"><span style="font-size:10.0pt;color:black;font-family:arial, helvetica, sans-serif">The Senior Analyst drives reservation trend analysis, demand forecasting, and pricing strategy within the Revenue Optimization team, supporting the Rental Gear line of business. The role blends statistical forecasting, SQL and Excel-based financial modeling, and dashboard reporting to turn data into pricing and revenue recommendations, working closely with financial, marketing, and operational leaders to translate insights into action.</span></p> <p style="margin:0.0in;line-height:normal;background-color:white;font-size:11.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"> </span></p> <p style="margin:0.0in;line-height:normal;background-color:white;font-size:11.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"> </span></p> <p style="margin:0.0in;line-height:normal;background-color:white;font-size:11.0pt;font-family:Aptos, sans-serif"><span style="font-size:10.0pt;color:black;font-family:arial, helvetica, sans-serif">At Vail Resorts, we are focused on hiring high potential individuals. We are looking for people who are brave, ambitious and passionate. You should be someone who pushes boundaries and challenges the status quo. The ideal candidate is someone who embraces change, is intellectually curious and can work independently to complete a variety of complex, non-standard tasks.</span></p> </div> <div> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span> </span><span> </span></span></p> </div> <div> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong><span>Job Specifications: </span></strong></span></p> </div> <div> <ul> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span>Starting Wage: </span><span>$77,841.00 - $111,201.00 + Annual bonus</span> </span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span>Employment Type: </span><span>Year Round </span> </span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span>Shift Type: </span><span>Full Time </span><span>hours available</span> </span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span>Minimum Age: </span><span>At least 18 years of age </span> </span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span>Housing Availability: </span><span>No </span><span> </span></span></li> </ul> </div> <div> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span> </span><span> </span></span></p> </div> <div> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong><span>Job Responsibilities:  </span></strong></span></p> <ul> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Analyze reservation and rental transaction trends across resorts to identify seasonality, demand drivers, and revenue performance patterns.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">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.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Write Snowflake SQL queries and build Excel-based financial models to size new business opportunities, evaluate program performance, and support annual budget planning.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Use Tableau Prep and Tableau Desktop to clean data and build dashboards that translate analysis into stakeholder-ready insights.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Partner with Finance, Marketing, and Business Development to align forecasts, pricing recommendations, and new program business cases with broader business objectives.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Present findings and recommendations to senior leadership in a clear, concise, and actionable format.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Ensure data accuracy, completeness, and consistency across routine reporting and ad hoc analyses.</span></li> </ul> </div> </div> <div> <div> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span> </span><span> </span></span></p> </div> <div> <p><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong><span>Job Requirements:</span><span>  </span></strong></span></p> <p style="margin:0.0in;line-height:normal;background-color:white;font-size:11.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong><span style="color:black">Required:</span></strong></span></p> <ul> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Bachelor's degree in Business, Economics, Statistics, Finance, or a related field, or equivalent practical experience.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">3-5 years of experience in an analytical role, preferably in pricing, demand forecasting, or revenue optimization.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Expertise in statistical forecasting techniques (e.g., regression, time series) applied to pricing and revenue strategy.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Proficiency in Tableau Prep, Tableau Desktop, Python (pandas), and SQL (Snowflake preferred) for data analysis and automation.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Advanced Microsoft Excel skills, including formula-driven financial modeling and Power Query, to build business cases and scenario analyses.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Experience working with large, complex datasets to deliver clear, actionable recommendations.</span></li> <li style="line-height:normal;background-color:white;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;color:#333333;font-family:arial, helvetica, sans-serif">Strong organizational and time-management skills, with the ability to manage multiple concurrent projects.</span></li> </ul> <p style="margin:0.0in;line-height:normal;background-color:white;font-size:11.0pt;font-family:Aptos, sans-serif"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><strong><span style="color:black">Preferred:</span></strong></span></p> <ul> <li style="line-height:107%;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;line-height:107%;color:#202124;font-family:arial, helvetica, sans-serif">Experience in market research, reservation trend analysis, or revenue optimization within travel, hospitality, or resort industries.</span></li> <li style="line-height:107%;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;line-height:107%;color:#202124;font-family:arial, helvetica, sans-serif">Experience building financial models or business cases to size new product or program opportunities.</span></li> <li style="line-height:107%;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;line-height:107%;color:#202124;font-family:arial, helvetica, sans-serif">Familiarity with business transformations that improve financial or operational performance.</span></li> <li style="line-height:107%;font-size:10.0pt;font-family:arial, helvetica, sans-serif"><span style="font-size:10.0pt;line-height:107%;color:#202124;font-family:arial, helvetica, sans-serif">Strong presentation and storytelling skills, with the ability to communicate complex data insights clearly and persuasively to stakeholders.</span></li> </ul> </div> </div><p style="margin-bottom:11.0px"> </p> <p style="margin-bottom:11.0px"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">The expected Total Compensation for this role is $77,841.00 - $111,201.00 + Annual bonus. Individual compensation decisions are based on a variety of factors.</span><br><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"> </span></p> <p style="margin-bottom:11.0px"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif"><strong>Job Benefits</strong></span></p> <ul style="margin-bottom:11.0px"> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Ski/Mountain Perks! Free passes for employees, employee discounted lift tickets for friends and family AND free ski lessons </span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">MORE employee discounts on lodging, food, gear, and mountain shuttles</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">401(k) Retirement Plan </span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Employee Assistance Program</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Excellent training and professional development</span></li> </ul> <p style="margin-bottom:11.0px"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Full Time roles are eligible for the above, plus:</span></p> <ul style="margin-bottom:11.0px"> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Health Insurance; Medical Insurance, Dental Insurance, and Vision Insurance plans (for eligible seasonal employees after working 500 hours)</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Free ski passes for dependents</span></li> <li style="font-family:arial, helvetica, sans-serif;font-size:10.0pt"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Critical Illness and Accident plans</span></li> </ul> <p style="margin-bottom:11.0px"> </p> <p style="margin-bottom:11.0px"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Vail Resorts offers a ‘Hybrid’ work environment for Broomfield-based roles where employees must live within 50 miles of the Broomfield office and work on-site Tuesday, Wednesday, Thursday and have flexibility to work off-site on Mondays and Fridays. </span></p> <p style="margin-bottom:11.0px"> </p> <p style="margin-bottom:11.0px"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Please note that the ability to work in person or off-site, and the particulars related to such work, are subject to change at any time; and, accordingly, the Company reserves the right to change its policies and/or require in-person/in-office work or off-site work at any time in its sole discretion.  </span></p> <p style="margin-bottom:11.0px"> </p> <p style="margin-bottom:11.0px"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">In completing this application, and when submitting related documentation, applicants may redact information that identifies their age, date of birth, and/or dates of attendance at or graduation from an educational institution. </span></p> <p style="margin-bottom:11.0px"> </p> <p style="margin-bottom:11.0px"><span style="font-family:arial, helvetica, sans-serif;font-size:10.0pt">We follow all federal, state, and local laws including restrictions on child/minor labor. Minors hired into this position will not be asked or permitted to engage in any activities restricted to adult workers.</span></p> <p style="margin-bottom:11.0px"> </p> <p style="margin-bottom:11.0px"><span style="font-size:10.0pt;font-family:arial, helvetica, sans-serif">Vail Resorts is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, protected veteran status or any other status protected by applicable law.</span></p> <p align="right"> </p> <p align="right"><span style="font-size:12.0px"><em>Requisition ID  516231</em><br><em>Reference Date: 07/29/2026 <br><em>Job Code Function: Retail Ops - Corp</em></em></span> <span style="font-size:12.0px"><em><em> </em></em></span></p>