Summer Intern, Flight Schedules

Why Work for Frontier Airlines?

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.

Work Perks

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 1st 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 Crew Staffing Intern will work with experienced Crew Staffing Analysts to Collect, compile and analyze data relevant to crew staffing and budgeting to include crew utilization and crew efficiency. Assist manager of crew staffing with development of staffing and budget plans. Coordinate with external hotel business partner on cost analysis and cost control as it relates to crew hotel accommodations, including interaction with union hotel committees. Drive continuous productivity, efficiency and operational performance improvements through analyses related to the staffing and scheduling of Pilots and Flight Attendants.

Essential Functions

• Generate schedule reports to accurately display Frontier schedules for internal systems and departments using Excel formulas to complete task.
• Manipulate scheduling software to create new reports and processes that improve scheduling efficiency and communication.
• Act as a resource when schedule questions arise.
• Efficient prioritization of daily responsibilities
• Participate and assist with Schedules Analyst's responsibilities.

Other Functions

• Coordinate schedule changes with Marketing, Pricing and Revenue Management.
• Utilize SQL query to produce historical flight times.
• Audit documentation regarding minimum connect times, ground times, airport and route-specific constraints and maintenance parameters.

Qualifications

• Enrolled in degree program in business administration, mathematics, statistics, economics, aviation management or similar discipline
• SQL experience creating and manipulating queries - preferred
• Interest in analysis, planning and/or airline operations (Operations Control, Airport Operations, Crew Planning/Scheduling, Maintenance Planning/Operations ...) - preferred

Knowledge, Skills and Abilities

• Proficiency in MSOffice products (Excel/Word/PowerPoint)
• Understanding of creating and running SQL queries
• Interest in airline planning and scheduling
• Excellent organizational skills
• Excellent written and oral communication skills
• Knowledge of aircraft and aircraft performance
• Knowledge of basic statistical concepts
• Knowledge of North American geography

Equipment Operated

Standard office equipment, including PC, copier, fax machine, printer

Work Environment

Typical office environment, adequately heated and cooled

Occasional travel may be required

Physical Effort

Generally, not required.

Supervision Received

Close Supervision: The incumbent is assigned duties according to specified procedures and receives detailed instructions. Work is checked frequently.

Positions Supervised

• None

Class Year

Interns
($ per hour)

Freshman

18

Sophomore

19

Junior

20

Senior

21

Graduate Program

23

Workplace Policies

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.