Collette is seeking an Inventory Analyst to join our Revenue Management Team. This is a hybrid role based at our Headquarters in Pawtucket, RI.
About Collette: Let Us Show You the World
There has never been a better time to be in the travel industry. See the world, connect with others, and experience the immersive benefits of one of the trendiest industries when you join the Collette team! As the longest-running tour operator in North America, our family-owned business leads the industry in innovation and expertise. Collette's passionate team works hard to fulfill travel dreams and is always looking for talent that will help to shape the company's future. Being part of the Collette team means having a willingness to grow, a desire to learn and ask questions, and a zest for seeing the world. From giving back to local communities to creating incredible experiences for a world of travelers and being part of a value-oriented team that cares for one another - Collette is all about the people. So, what are you waiting for? Your journey starts here.
Position Summary:
The Inventory Analyst will be required to conduct analysis for all areas within the Revenue Management & Pricing Organization. Critical analysis required of historic tour series sales, current tour series trending, sales analysis by channel of distribution, date analysis, forecasting plans and the competitive environment. Key areas of focus are on the implementation, maintenance, and analysis of the inventory date strategy for each tour series to meet forecasted demand and hit profitable load factors.
Primary Functions:
Makes recommendations and decisions on the composition of the analysis.
Reviews data and makes decisions on which data sources to use to build the analysis
Applies findings from analysis to make date strategy decisions for the organization
Analyzes pricing models, forecasting plans, yield management reports, sales data, previous materialization, and the competitive environment to aid in the administration of date strategy plan
Executes analysis needed for date strategy including on historical tour sales, upgrade sales, pre and post night and extension sales and works in partnership with Senior Inventory Specialist, Director of Inventory, Product Buyer and Air Pricing Manager to select dates that will lead to best costing for contracting while meeting forecasted demand needs
Audits tour series on a continuous basis to determine adjustments needed to number of departures
Reviews bookings made on a daily basis to determine need for inventory adjustments
Collaborates with Yield Management to conduct analysis by tour series and review forecasts
Supports Yield Management in reporting and analyzing the forecasted load for each departure date and makes adjustments to support Revenue Management load goals
Evaluates and actions reports and recommendations from Align Alytic Yield Management System
Assesses discount strategies and implements changes to improve load factors on all departure dates
Liaises with Marketing Team to ensure accuracy in marketing pieces as needed
Creates and maintains spreadsheets, pivot tables and data analytics that are utilized to aid in decision making on inventory
Reports monthly on Inventory strategic goals
Presents findings as needed to Revenue Management leaders along with recommendations
Identifies and reports on forecasted low load departures to pricing team to review for cost savings
Updates and maintains tracking grids to include but not limited to date process tracking and tour release
Support releasing product for sale to the company by conducting analysis of historical sales and margins to recommend guaranteed departures, available inventory by channel and group placement
Supports Inventory Specialists as demand warrants
Participates in special projects as assigned
Knowledge and Skills:
Bachelor's Degree in business, finance, or related field
Minimum Experience - two years
Strong analytical and problem solving skills
Utilizes independent judgement and decision making
Strong attention to detail
Proficiency in Excel
Strong interpersonal skills, self-starter and self-motivated
Willingness to benefit from coaching and guidance
Desire to continually learn and improve their analytical and technical skills