Operational Analytics and Performance (OAP) Intern

About Us
Endeavor Air, a wholly-owned subsidiary of Delta Air Lines, takes pride in delivering a safe, reliable, and customer-focused travel experience. Flying as Delta Connection, Endeavor operates more than 900 daily flights to 140+ destinations in the United States, Canada, and the Caribbean.
Headquartered in Minneapolis, Minn., Endeavor operates six crew bases and 11 maintenance bases across the country. At the heart of our operation, over 5,000 employees keep us soaring and help ensure Endeavor sets the standard for excellence in the regional airline industry.
Our Culture
We know that our people are our greatest assets, and we are committed to building a culture where employees love coming to work each day. At Endeavor Air, we foster a diverse, culturally-rich and safe workplace where employees are treated with dignity and respect. With a culture built on safety, excellence, and teamwork, Endeavor offers limitless potential for aviation professionals looking to start or continue their careers.
Our team promotes an inclusive environment in all aspects of the airline and our operation. As an EEO employer, we provide opportunities for all qualified candidates without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran, or disabled status.
Overview
The Operational Analytics and Performance (OAP) Intern will integrate knowledge and theory learned in the classroom with practical application and skills development in a professional workplace. The Intern will utilize analytical and critical thinking skills to complete project-based work assignments with an emphasis in Operational Analytics.
The Application Process: We encourage applicants to apply as early as possible to receive next steps in the application process. After an application is submitted, the Talent Acquisition team will review your application. Due to the high volume of applications, the reviewing process may take several weeks.
After the reviewing process of the applications, all applicants will also be notified to complete a required one-way video interview. If you are applying for multiple positions, you will only need to complete one interview video. Please note, due to high volume of applications, videos will take several weeks to review, and you may not receive an email or hear the status of your application for a while, however you will receive an update from the Talent Acquisition team.
Responsibilities

• Perform data analysis and distribution to provide Company employees with essential performance data.
• Assist in tracking and reporting of on-time statistics, customer service metrics, and other performance metrics to help the company meet goals and provide a valuable service to its customers.
• Prepare daily, weekly, monthly, and ad hoc reporting for senior management, Delta Air Lines, and other company departments and employees.
• Develop data mining queries from system databases and statistical data models for comprehensive analysis.
• Create automated processes where applicable for data extraction, report processing, and distribution through Tableau, SAS, Excel, or other available programs.
• Participate in operational meetings when attendance is requested.
• Provide accurate historical performance trends and forecasts to other operating divisions.

Other Duties

• Performs other duties as assigned.

Supervisory Responsibilities

• Not Applicable

Competencies Required

• Embraces diverse people, thinking and styles. Listens and communicates openly, honestly, and respectfully. Acts in an ethical manner.
• Concern for Safety - Consistently makes safety and security, of self the priority.
• A continuous learner who identifies and addresses learning needs to advance own performance.
• Dedicated to meeting the expectations and requirements of internal and external customers.

Qualifications

• Currently enrolled full-time in an undergraduate degree such as Data Analytics, Statistics, Data Science or Mathematics with Junior or Senior class standing.
• Above average written and communication skills.
• Microsoft Office Suite platforms.
• Effective organizational, time management, & multi-tasking skills
• Prior analytical experience (data analysis/reporting) or database management experience preferred.
• Knowledge of SQL, Python, or other programming language preferred but not required.

Work Environment & Physical Demands

• Ability to work full time (32-40 hours/week) during weekdays, with some schedule flexibility, if needed.
• Ability to work and be based in Minneapolis, MN; relocation assistance is not available.
• Ability to work both independently and collaboratively in a business environment.
• Repetitive motion such as typing.
• Minimal physical exertion such as: pulling, pushing, reaching, bending, standing, walking, and light lifting of boxes, bags files, and electronic equipment not in excess of 30 lbs.
• Travel as necessary.
• Computer work, in a typical office environment sitting for the majority of the day.

What We Offer
Providing world-class service to our customers starts with providing world-class benefits to our employees. Endeavor Air employees receive a competitive total compensation package which includes a variety of benefits to choose from and some of the best perks around.

• Free or reduced-rate travel privileges on Delta Air Lines and 80+ air carriers worldwide for employees and eligible family members
• Comprehensive Medical, Dental, and Vision Plans
• 401(k) with Company Match starting on Day 1
• Operational Performance Rewards (OPR) Program
• Life and AD&D Insurance, Short and Long-term Disability, Flexible Spending Accounts (FSA), and voluntary supplementary benefit options

FLSA Status
Hourly
Minimum Position Pay Range
USD $16.00/Hr.
Maximum Position Pay Range
USD $16.00/Hr.