Inventory Analyst

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
• Desire to advance career within the team
5 days ago