Data Analyst

Turning data into actionable insights

Experienced Data Analyst with expertise in Python, SQL, Tableau, and operational analytics at Delta Airlines.

View Experience See Projects
Greater Seattle Area
BA Business Administration, 2024
Jeffrey Gemmell - Data Analyst
5+ Years Analytics

About Me

I am a passionate Data Analyst with over 15 years of operational experience at Delta Airlines, where I've combined my business and technical background to drive data-informed decisions.

Specializing in building scalable analytics solutions, I excel at translating complex operational challenges into clear, actionable insights using Python, SQL, and visualization tools.

Key Highlights

📊
System-wide Impact
Tableau dashboards used across Delta for operational performance
⚡
Efficiency Gains
Automated reports saving 40+ hours monthly
🧠
Mentorship
Led transition from SAS to Python & Tableau
🔧
Tool Development
Built internal tools for staffing forecasts and employee access

Skills & Technologies

🐍

Python

ETL pipelines, automation, forecasting, report building

📊

Tableau / Power BI

Interactive dashboards and scorecards

🗄️

SQL & Databases

Teradata, data querying and analysis

📈

Analytics

Operational forecasting, performance metrics, visualization

Professional Experience

2021 – Present
Data Analyst
Delta Airlines
  • • Built Python-based analytical tool for forecasting staffing and equipment needs during irregular operations
  • • Developed system-wide Tableau scorecards and dashboards improving operational performance
  • • Automated monthly reports saving 40+ hours of manual work
  • • Mentored team on migration from SAS to Python and Tableau
  • • Created internal analytics documentation website and employee roster tool
2008 – 2021
Customer Service Agent
Delta Airlines

Ground flight operations, baggage and cargo logistics. Gained deep operational knowledge that now informs data-driven decision making.

Education

2022 — 2024
Bachelor of Business Administration
Management Information Systems
William Woods University • Fulton, Missouri
2020 — 2022
Associate's Degree
Business and Software Development
Eastern Gateway Community College • Steubenville, Ohio

Featured Projects

Selected analytics work and tools built for Delta Airlines

✈️

Airline Price Trends & MBR Dashboard

Comprehensive analysis of domestic flight pricing trends (1996-2021) and carrier mishandled baggage rates.

Tableau Data Visualization DOT Data
📋

Airline Employee Scorecard

Performance tracking dashboard using industry metrics linked to on-time performance. Integrates Python-generated employee, bag, and cargo data.

Python Tableau BTS Data

Let's Connect

Interested in discussing data opportunities or collaboration?

jeffrey.gemmell@outlook.com
Greater Seattle Area • Open to opportunities