Data Analyst College Intern– Air Service Development – 10 weeks - Denver International Airport

About Our Job

Who We Are

The Denver International Airport (DEN) Airline and Commercial Affairs division is actively seeking a Data Analyst ("DENtern") to contribute to their division. As part of DEN's Strategic Plan, Vision 100, which envisions reaching 100 million annual passengers, Airline and Commercial Affairs plays a pivotal role in transforming the aviation industry. The Airline and Commercial Affairs division at Denver International Airport (DEN) manages the relationship with all current and future air carriers. With record-breaking passenger traffic, we thrive to not only maintain the current level of national and international connectivity, but also to continue increasing the number of destinations.

The Air Service Development team maintains the airport’s existing levels of air service while recruiting new service with the additions of new airlines and new nonstop destinations. The team is also responsible for building strategic partnerships with local stakeholders, maintaining consistent outreach with carriers and marketing Denver and Colorado to the global community.

What We Offer

The City and County of Denver offers a competitive pay rate to commensurate with education. The salary range for this position is $19.75 to $22.32 an hour, based on education. Denver International Airport emerging talent positions are required to attend all sessions of professional development within the cohort model. You will be onboarded with a cohort of peers to begin to help you develop your network across the aviation industry.

As an intern you will get to experience working on projects such as:

Weekly Schedule Changes

• Gain experience with aviation data sets involving airline schedules

• Present findings to the air service development team

• Opportunity to improve workflows

Monthly Reporting

• Gain experience with data sets for passenger travel demand

• Assist with data analysis for monthly reports to internal and external stakeholders

• Work on improvements and additions to current reports or new ones

Airline Business Cases

• Create presentations for conferences, headquarter meetings, and other business cases for future and existing air service, using data analysis

• Macroeconomic Data and Trend Analysis

• Gain experience with data sets from U.S. Census Bureau, Bureau of Economic Analysis, U.S. Department of Labor, Colorado Demography Office, etc.

Data Visualizations

• Assist with building and maintaining PowerBI dashboards with data from DEN Finance, TSA, and CBP

• Job Shadowing in the Airline and Commercial Affairs division

What You’ll Bring

Our ideal candidate has some or all the following skills, characteristics, and interest:

• Strong research and analytics skills

• This is an ideal position for a student of data analysis with an interest in the aviation industry

• Proficiency in Microsoft Office Platforms

• Especially Excel and PowerBI

• Creativity and innovation

• Coming up with new and unique concepts for presenting information

• Detail-oriented, organized, and able to manage tasks simultaneously

• General interest in the aviation industry with a willingness to learn

Minimum Qualifications

• Education Requirement:  Current enrollment in an accredited college program leading to a certificate, licensure, associates, bachelor’s, or higher degree in, or a recent graduate (completed specified program within 1 year of completion). 

• Experience: None 

• Education and Experience Equivalency: No substitution of experience for education is permitted. 

Mandatory documentation required to be considered for this position:

• Resume (with most current information)

• Transcripts – either official or unofficial; dated within your current academic term. This is only used to verify amounts of credits; grades will not influence decision.

Optional Documents:

• Cover letter detailing why you are interested in this position.

Location Flexibility

The City and County of Denver supports a hybrid workplace model with a required 3 days in office. Employees work where needed to support business, at the Denver International Airport. We do not offer housing or relocation assistance for this position.

Internship Duration and Hours

This is a 10-week internship, with typical hours not to exceed 39 hours a week.

FBI Background Check 

FBI criminal background check is required for all positions at Denver International Airport (DEN). Employees are also required to report any felony convictions and/or moving violations to maintain this clearance and be eligible for continued employment. By position, a pre-employment physical/drug test may be required.  

About DEN  

Denver International Airport (DEN) is the third-busiest airport in the United States and one of the top ten busiest airports in the world, connecting our community globally through flight and business. DEN is the primary economic engine for the state of Colorado, generating more than $36.4 billion for the region annually and employing nearly 37,000 people. At DEN, we are committed to fostering a diverse, inclusive and equitable workplace. We celebrate individuality and uplift all races, ethnicities, gender identities, national origins, ages, abilities, religion, and LGBTQIA+ communities. We know that our diversity makes us stronger, and we strive to keep diversity, equity and inclusion at the center of all that we do.

Application Deadline  

This position is expected to stay open until 2/22. Please submit your application as soon as possible and no later than 11:59 pm on 2/21 to ensure consideration.  

About Everything Else

Job Profile

TA3181 Professional Administration Intern

To view the full job profile including position specifications, physical demands, and probationary period, click here.

Position Type

Oncall

Position Salary Range

$19.75 - $22.32

Starting Pay

Agency

Denver International Airport

The City and County of Denver provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, national origin, disability, genetic information, age, or any other status protected under federal, state, and/or local law. 

It is your right to access oral or written language assistance, sign language interpretation, real-time captioning via CART, or disability-related accommodations. To request any of these services at no cost to you, please contact Jobs@Denvergov.org with three business days’ notice.

Applicants for employment with the City and County of Denver must have valid work authorization that does not require sponsorship of a visa for employment authorization in the U.S.

For information about right to work, click here for English or here for Spanish.