Operations Data Analyst

Essential Functions:

• Maintain company’s operational statistics databases to ensure accuracy and compliance with contractual requirements.
• Generate Daily Report of various Operational Statistics to track company’s performance and determine eligibility for operational incentives or penalties.
• Conduct reconciliation for flight delays and cancelations by comparing data with partner databases.
• Run monthly operational statistics reports used by Finance Department to determine statistic driven expenses and revenue.
• Work directly with mainline flying partner to reconcile statistics used for billing purposes.
• Work closely with members of SOC and IT Departments on daily and ad hoc basis.
• Compile and submit various monthly, quarterly and annual reports to the Department of Transportation (DOT). Work with DOT to resolve any data submission issues.
• Ad Hoc statistical analysis.
• Bachelor’s or Master’s Degree in Statistics, Mathematics, or other quantitative discipline
• Advanced MS Excel knowledge including VBA for macros
• Expert in one or more relational database technologies such as Oracle/MySQL/ MS SQL Server/MS Access.
• Familiar with data visualization tool like Tableau, MS Power BI.
• Experience with Office 365 apps like Sharepoint, Forms, Planner, etc. preferred.
• Knowledge of API is a plus.

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled