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 130 regional jets on 700 daily flights to 126 destinations in the United States, Canada, and the Caribbean.

Endeavor is headquartered in Minneapolis, Minn., with hub operations located in Atlanta, Cincinnati, Detroit, Minneapolis, New York, and Raleigh-Durham, and 11 maintenance bases across our network. 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.

Data has transformed the way Endeavor operates. The Operations Data Strategy and Reporting (ODSR) Data Analyst role is to further harness the power of data by making it accessible, available, and curated for reporting and analysis. The ODSR team within Endeavor’s Operations Analysis and Performance (OAP) division are responsible for: curating data tables to be used by analytics teams, producing and distributing automated reporting in a modular and scalable manner, leading efforts to transition to modern data and reporting tools, and acting as a center of expertise for efficient data processing and analytics.

• Utilize advanced SQL, Python, or other methods to create and manage tables and curate views conducive to business intelligence activities.
• Clean and curate datasets by researching new data sources and collaborating with other business units to determine the best source for the data, aggregating views into meaningful hierarchies.
• Be familiar with data environments and collaborate to improve automated reports and analyses in support of divisional leaders and business units.
• Leverage emerging technologies and proactively identify efficient and meaningful ways to communicate data and analysis that satisfy divisional needs.
• Design and oversee administration of database structures to ensure data integrity controls and establish internal governance processes.
• Support process improvement and project management engagements for both individual business units and cross-divisional initiatives.
• Locate and extract data from internal and external sources for use in reporting, analysis, and statistical modeling.

• Other duties as assigned.

• No direct reports.

• Ethics and Values - Supports positive change and diversity that will support healthy organizational growth. Serves as a champion for projects and programs that are beneficial to the company.
• Knows our Business - Is informed and knowledgeable about trends in the field. Is willing to use own knowledge to constructively challenge institutional practices and systems that might be improved to increase organizational results.
• Building Trust & Decision Making - Treats all team members in a respectful, courteous, and professional manner, and values the input of all.  Recognizes when analysis is sufficient to proceed with making a good decision.
• Drives For Results by Inspiring Others - Develops clear workable plans with timelines, goals, and ways to measure results. Fosters engagement across different teams. 
• Know your Team & Leading People - Works inclusively with others on the team and across the organization to reach common goals. Is approachable and friendly. Is skilled at valuing differences; recognizing others; and listening for understanding.

• Bachelor's degree in Data Science, Computer Science, Engineering, Information Science, or other relevant quantitative field or a combination of education and 1+ years of related experience.
• Proficiency in SQL and ETL/ELT patterns.
• Proficiency with Python, SAS, or other similar tools and programming languages.  Experience with Pandas library.
• Experience building dashboards in Tableau, Power BI, or similar application.
• Ability to troubleshoot a reporting database environment with minimal guidance.
• Strong attention to detail and ability to work autonomously and manage multiple requests with varying timelines.
• Ability to collaborate effectively with cross-functional teams.
• Excellent verbal & written communication, interpersonal, and analytical skills.
• Track record demonstrating ability to function independently and as a team member, and consistently deliver quality outcomes.
• Ability to work in a high-profile environment with fluid priorities, ambiguity, and aggressive deadlines.

• Full-time exempt position.
• Can involve long periods of sitting. Computer work, repetitive motion such as typing.
• Subject to critical deadlines. 
• 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.
• Some travel may be required.

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