Sr Analyst, Distribution - Canada - Frontier Airlines, Inc.

Description

At Frontier, we believe the skies should be for everyone. We deliver on this promise through our commitment to Low Fares Done Right. This is more than our tagline - it's our driving philosophy. Every member of Team Frontier has an important role to play in bringing this vision to life. Our successful business model allows travelers to take advantage of our fast-growing route network while our bundled and unbundled pricing options allow our customers to personalize their travel experience and only pay for the services they need – saving them money along the way.

What We Stand For

Low Fares Done Right is our mission and we strive to bring it to life every day. Our 'Done Right' promise means delivering not only affordable prices, but making travel friendly and easy for our customers. To do this, we put a great deal of care into every decision and action we take. We must be efficient with the use of our resources and make smart decisions about how we run our business. We must also innovate and be pioneers - we're not afraid to try new things. While our business requires us to fly high in the air, we also consider ourselves down-to-earth in our approach, creating a warm and friendly experience that truly demonstrates Rocky Mountain Hospitality.

At Frontier, we like to think we're creating something very special for our team members. Work is why we're here, but the perks are nice too:

• Flight benefits for you and your family to fly on Frontier Airlines.
• Buddy passes for your friends so they can experience what makes us so great.
• Discounts throughout the travel industry on hotels, car rentals, cruises and vacation packages.
• Discounts on cell phone plans, movie tickets, restaurants, luggage and over 2,000 other vendors.
• Enjoy a 'Dress for your Day' business casual environment.
• Flexible work schedules that support work/life balance.
• Total Rewards program including a competitive base salary, short term incentives, long-term incentives, paid holidays, 401(k) plan, vacation/sick time and medical/dental/vision insurance that begins the 1 st of the month following your hire date.
• We play our part to make a difference. The HOPE League, Frontier Airlines' non-profit organization, is dedicated to providing employees financial assistance during catastrophic hardship.

Who We Are

Frontier Airlines is committed to offering 'Low Fares Done Right' to more than 100 destinations and growing in the United States, Canada, Dominican Republic and Mexico on more than 350 daily flights. Headquartered in Denver, Frontier's hard-working aviation professionals pride themselves in delivering the company's signature Low Fares Done Right service to customers. Frontier Airlines is the proud recipient of the Federal Aviation Administration's 2018 Diamond Award for maintenance excellence and was recently named the industry's most fuel-efficient airline by The International Council on Clean Transportation (ICCT) as a result of superior technology and operational efficiencies.

What Will You Be Doing?

The Distribution Senior Analyst develops analytical tools to identify and quantify opportunities within the Distribution area and provides insights to optimize Frontier's distribution strategy and profitability. The Distribution Senior Analyst is responsible for building the appropriate reporting processes and visualizations to monitor sales channels performance and cost of sale. The Distribution Senior Analyst is also responsible of budgeting, forecasting and controlling distribution costs. As an integral part of Frontier's success, Distribution team receives high visibility by senior management and enjoy a range of formal training and informal learning opportunities to support ongoing professional development and career growth.

Essential Functions

• Extract, transform and manipulate data to create clean datasets surrounding Frontier's distribution and sales channels.
• Design and produce reports and dashboards to analyze channel performance and illustrate industry trends, combining internal and external data sources, while developing and implementing the required processes to maintain and update such reports and dashboards.
• Monitor distribution KPIs and performance by channel across the entire global market, including analysis by region, by point of sale and by travel agency.
• Develop appropriate analysis to support decision making and assist in evolving the sales policies and the distribution strategy of the company.
• Leverage big data to understand customer behavior and demand by channel.
• Support sales planning on marketing and promotional efforts via third parties.
• Identify, analyze and quantify opportunities for distribution optimization, looking to maximize revenues or reduce cost of sale while increasing or protecting market share.
• Present analysis and recommendations to different levels of audience.
• Develop models to forecast distribution costs and support budgeting process.
• Audit and reconciliate distribution invoices, identifying and explaining deviations versus forecast when required.
• Understand commercial agreements with GDS and assist with economic modelling during negotiations.
• Research on distribution practices and policies from other airlines and sales partners.

Other Functions

• Interact with commercial teams (Commercial Analytics, Digital, Ancillaries, Pricing, Revenue Management, Revenue Integrity, Marketing and Network planning) and cross-departmental areas (Finance, Customer Care, IT, etc.) to distill quantitative and qualitative inputs into meaningful insights.
• Review, redesign and automate processes.
• Create documentations, code standards, code library and workflows, where industrialized processes are necessary.
• Other duties as assigned.

Qualifications

• Bachelor's degree required; major(s) in Operations Research, Computer Science, Engineering, Mathematics, Finance, Aviation Management or related analytical field strongly preferred.
• 5+ years of experience in commercial analytics, distribution, pricing, revenue management, customer insights, retail analytics, and/or finance required, preferably in an airline , travel related company or consulting within the industry.
• Previous professional experience using big data required.

Knowledge, Skills and Abilities

• Solid understanding of airline commercial metrics, network design, online selling processes, revenue management principles, e-commerce platforms, Global Distribution Systems, online booking tools and travel technology infrastructures desired.
• Excellent analytical and quantitative skills, including the capacity to assemble information, extract pertinent facts and draw logical conclusions.
• Advanced proficiency in Excel.
• Intermediate to advanced programming skills (Python or R), with ability to write SQL code to query against disparate data sources.
• Previous professional experience with a version control system (such as Git).
• Previous professional experience building data visualizations on PowerBI, Tableau or Zenz.
• Previous professional experience analyzing data from Google Analytics, MIDT, Pharos or DIIO will be a plus.
• Ability to translate detailed complexity into simple clear messages, adapting style to the audience and situation.
• Strong organizational skills; comfortable working independently, prioritizing tasks in a fast-paced, dynamic environment, while keeping track of several projects at the same time.
• Strong work ethic; delivers results in ambiguous and time-pressured situations.

Equipment Operated

Standard office equipment, including PC, copier, printer.

• This role can be based at our headquarters in Denver, CO or anywhere in the United States via a remote work arrangement (periodic travel to Denver from a Frontier-serviced city required).
• If remote, you must be able to follow our remote work policies, including ability and comfort level working from home with access to a high-speed internet connection.
• If headquarters-based, typical office environment, adequately heated and cooled.

Physical Effort

Generally, not required.

Supervision Received

General Supervision: The incumbent performs a variety of routine work within established policies and procedures and receives detailed instructions on new projects and assignments.

Positions Supervised

• None

Salary Range

$65, $93,525.00

Please note: this posting has a closing date of 2/28/2024 midnight MT.

At Frontier Airlines, we wholeheartedly support and have a strong commitment to Equal Employment Opportunity (EEO) and Affirmative Action. Frontier is committed to providing equal employment opportunities for all persons regardless of race, color, religion, gender, gender variance, sexual orientation, age, genetic information, martial status, national origin, citizenship status, disability, military, veteran status, and any other basis protected by federal, state, or local laws.

Diversity is an essential part of our success. Our company flourishes because of the unique backgrounds, skills and ideas that our team members contribute every day. We salute and actively recruit veterans. Military experience is valuable and transferable to many of the positions essential to the operations of our airline.

Frontier Airlines is a Zero Tolerance Drug-Free Workplace. All prospective DOT safety-sensitive employees are subject to pre-employment testing for the following drugs and their metabolites: Marijuana, Cocaine, Amphetamines, Opioids and Phencyclidine (PCP). Further, any DOT safety-sensitive job applicant who is found to have tested positive on any required drug or alcohol test at a former employer will be considered ineligible for employment with Frontier.

Disclaimer: The above statements are intended only to describe the general nature and level of work required of the referenced position; they are not intended to be an exhaustive list of all responsibilities, duties, and skills required of individuals in this position. Please be advised that duties and expectations of this position may be subject to change.