Engineer, Data - 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 Data Engineer on the Revenue Analytics team will collect, manage, and convert raw data into information that can be interpreted to help optimize Frontier's revenue generation and profitability. The Data Engineer will be responsible for optimizing our database architecture and data processing systems. They will support our team of data analysts, data scientists, and business partners to ensure optimal data delivery architecture is consistent across projects and teams. The ideal candidate should possess strong technical abilities to solve complex problems with data, a willingness to learn new technologies and tools, and be comfortable supporting the data needs of multiple teams, stakeholders, and products.

Essential Functions

Technical

• Leverage big data, capabilities in cloud environments, and multiple sources of data to identify signals and integrate those signals into modeling for explication, prediction, or production.
• Prepare raw data for manipulation by data scientists, data analysts, and business partners.
• Manage ETL processes in new and existing data pipelines to create clean datasets for use in analysis.
• Conceptualize and generate infrastructure that allows big data to be accessed and analyzed.
• Conduct ad-hoc projects, reports and analyses as determined by management.
• Write clean, efficient code to automate processes and improve workflows.
• Work with version control systems to manage source code efficiently.
• Create documentation, code standards, code library, and workflows to enhance the Revenue Analytics infrastructure.
• Develop dynamic and flexible visualizations and dashboards to illustrate key trends and KPIs.
• Construct statistical models and present findings to relevant stakeholders.
• Work with the Pricing and Revenue Management teams to identify new opportunities and deliver actionable analytics solutions to drive precise action and maintain competitive advantage.
• Work with a wide variety of teams with diverse technical backgrounds.

Leadership/Communication

• Clearly communicate the actionable business implications of complex quantitative analyses to management.

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.
• Master's degree in quantitative field preferred.
• Previous professional use of SQL, Python, or R required.
• Previous professional experience using big data required.
• 3 to 5 years of experience in data analytics, data engineering, pricing, or revenue management required.
• Experience in an airline pricing, yield or revenue management, revenue analytics, revenue systems, or similar role strongly preferred.

Knowledge, Skills and Abilities

Technical

• Intermediate SQL skills to write complex, highly optimized queries against large datasets.
• Ability to write SQL code to query against disparate data sources.
• Familiar with object-oriented programming languages, like Python.
• Experience with distributed computing frameworks, such as Hadoop or Spark.
• Familiar with cloud-based solutions, like Azure.
• Familiar with API frameworks such as REST API to query data writing complex JSON/XML queries.
• Familiar with version control systems, like Git.
• Experience with Power BI or Tableau preferred.
• Knowledge or interest in statistics or machine learning preferred.
• Demonstrated understanding of airline commercial metrics, economics, network design, and revenue management principles preferred.

Project Management/Communication

• Strong project management and organizational skills.
• Exemplary written and verbal communication and presentation skills.
• 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 with limited guidance 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.
• Proven ability to work independently and with a team.

Equipment Operated

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

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

$72,000 - $93,525

Please note: this posting has a closing date of 4/12/2024, midnight MT.

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 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.