Operational Analytics Intern - Summer 2019 Job Locations US-MN-Minneapolis Post Date 1 day ago (12/31/2018 6:00 PM) Requisition ID 2018-1939 Job Code CRS0047 # of Openings 1 Category Crew Resources Post End Date 1/31/2019 About Us Endeavor Air, a wholly-owned subsidiary of Delta Air Lines, strives to operate the safest, most reliable jet air service in the regional airline industry. With its more than 4,400 employees working as one, Endeavor takes pride in delivering over 800 flights a day to more than 130 destinations across North America. Endeavor operates the worlds largest fleet of Bombardier CRJ-900 NextGen aircraft, as well as the CRJ-700 and CRJ-200 regional jets. With a growing fleet, five crew and 10 maintenance bases, and the goal of hiring hundreds of new employees to support its expanding network, Endeavor offers limitless potential for aviation professionals looking to start or continue their careers. Overview The Operational Analytics 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. Responsibilities Assist in tracking and reporting of on-time statistics, as well as metrics for man-power planning, crew, maintenance, customer satisfaction and other performance metrics to help the company meet goals and provide a valuable service to its customers. Develop data mining queries from system databases and statistical data models for comprehensive analysis. Prepare daily, weekly, and monthly, or ad hoc, status reports for the Director, operations analytics and performance, senior management, and other company departments and employees. Create automated processes where applicable for data extraction, report processing, and distribution. Provide advanced reporting and analysis on multiple operational metrics to assist management in critical business decisions. Perform data analysis and distribution to provide company employees with easy access to essential performance data. Computer work, in a typical office environment sitting for the majority of the day. Other duties as assigned. Qualifications Currently enrolled full-time in an undergraduate degree such as Data Analytics, Statistics or Mathematics with junior or senior class standing as of fall 2018. Ability to work a full-time schedule, 40 hours per week, during normal business hours, 8:00am to 5:00pm, during the assigned schedule Ability to work and be based in Minneapolis, MN Ability to work both independently and collaboratively in a business environment Above average written and communication skills Microsoft Office Suite and Adobe Creative Suite platforms Effective organizational, time management, & multi-tasking skills Prior analytical experience (data analysis/reporting) or database management experience preferred Knowledge of SAS/SQL preferred but not required 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