Analyst II, SQL Reporting And Data Analysis

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 Analyst II, SQL Reporting and Data Analysis develops analytical tools and statistical models to maximize Frontier's revenue generation and profitability. The Analyst will be responsible for building data pipelines & coding automated reporting processes, creating data visualizations and dashboards, identifying and quantifying revenue opportunities, and crafting clear presentations to management. As an integral part of Frontier's success, Revenue Analytics Analysts receive 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

• Identify & quantify revenue opportunities across the organization
• Work with the Pricing and Revenue Management teams to identify new opportunities for generating revenue
• Construct statistical models
• Present findings to relevant stakeholders
• Create visualizations and dashboards to illustrate key trends and KPIs
• Work with a wide variety of teams with diverse technical backgrounds
• Enhance the Revenue Analytics infrastructure by implementing best practice coding & structure
• Create data pipelines to transform raw input into clean datasets for use in analysis
• Write clean, efficient code to automate processes
• Mentor more junior team members, and foster the development of their programming and analytics skills
• Collaborate with diverse teams across the company
• Conduct ad-hoc projects, reports and analyses as determined by management
• Set the standard for the broader team in thought processes and analytical output
• Achieve expert status in business and industry trends
• Clearly communicate the actionable business implications of complex quantitative analyses to senior management
• Lead change across the organization by improving directly owned processes and taking initiative to champion cross-functional opportunities

Other Functions

Interact with commercial team and cross-departmental teams to maximize revenue.

Qualifications

• Bachelor's Degree required; major(s) in Operations Research, Computer Science, Engineering, Mathematics, Finance, Aviation Management or related analytical field strongly preferred; combination of education and work experience considered in lieu of degree
• 3 to 5 years of experience in data analytics, finance, pricing or revenue management required

Knowledge, Skills and Abilities

• Basic programming skills, with some knowledge of Python strongly preferred
• Ability to write SQL code to query against disparate data sources
• Advanced proficiency in Excel
• Experience with Power BI or Tableau preferred
• Knowledge or interest in statistics or machine learning preferred
• Strong organizational skills and the ability to keep track of several projects at once
• Advanced analytical and quantitative skills; demonstrated understanding of airline commercial metrics, economics, network design and revenue management principles
• Exemplary written and verbal communication and presentation skills
• Ability to independently prioritize analyses in a fast-paced, dynamic environment
• Ability to structure logical analytical approaches and to apply a range of quantitative techniques to solve business problems in an efficient, timely manner
• Comfortable working self-sufficiently to creatively solve analytical challenges with limited data and imminent deadlines
• Strong work ethic; delivers results in ambiguous, time-pressured situations
• Sound judgment and ability to maintain composure under pressure

Equipment Operated

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

Work Environment

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: $56,000 - $70,000

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.

Frontier Airlines, Inc. is an equal opportunity employer and, as such, is committed to providing equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, national origin, age, marital status, veteran status, sexual orientation, gender identity or expression, disability status, pregnancy, genetic information, citizenship status or any other basis protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Frontier Airlines is a Zero Tolerance Drug-Free Workplace. All prospective employees are subject to pre-employment testing for the following drugs and their metabolites: Marijuana, Cocaine, Amphetamines, Opioids and Phencyclidine (PCP). Further, any 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.