How You'll Help Us Keep Climbing (Overview & Key Responsibilities)
As Delta continues its Digital Transformation, the Digital Experience team is focused on delivering a portfolio of high-impact initiatives to improve the customer and employee experience. To support Delta’s ambition to become a more customer-centric, experience-driven company, the Specialist, Data Analytics & Insights will work closely with Digital Experience product teams to drive continuous improvement of these experiences.
Key Responsibilities
- Data Pipeline Development and Data Engineering
- Design and implement automated data pipelines using AWS Glue and Lambda to ingest, transform, and load data from S3 into Teradata Data Labs, ensuring daily refresh and historical data append.
- Develop robust ETL workflows and data models to support analytics and reporting needs, including schema design, transformation logic, and governance compliance.
- Design and implement data models and transformation logic to join multiple data sources, define calculated fields, and establish standardized classifications for reporting and analytics.
- Build and monitor scalable data models that reflect customer experience performance and enable strategic decision-making.
- Ensure data quality and integrity through proactive testing, anomaly detection, and automated monitoring processes before data is accessible to users, upstream reports or dashboards.
- Collaborate with Digital Product teams to define and gather business requirements for new KPIs we want to measure as we expand our Digital Pulse Monitor—a centralized dashboard for all Digital metrics—and strategic initiatives in 2026 (e.g. Concierge, Connected Servicing, etc.).
- Develop complex SQL queries that leverage advanced techniques such as dynamic SQL for flexible query generation, complex joins and set operations, dynamic pivoting and unpivoting, query optimization for performance tuning, and sophisticated date/time calculations to enable accurate, scalable insights.
- Collaborate with the Enterprise Solutions Data Strategy team to onboard external data sources and stitch together customer journey data across channels, starting with Quantum Metric and expanding to Adobe Customer Journey Analytics for holistic journey insights.
- Manage and optimize data infrastructure within EDW, including sandbox environments, production tables, and data refresh automation.
Digital Analytics Dashboarding & Customer Journey Insights
- Support the migration of dashboards and reports from Adobe Analytics to Customer Journey Analytics (CJA), including auditing existing assets, mapping metrics, and rebuilding visualizations to leverage CJA’s advanced capabilities.
- Ensure data accuracy and consistency during migration by validating reports, recreating segments, and training stakeholders on new CJA features for cross-channel insights and enhanced customer journey analysis.
- Design, build, and maintain dashboards in Adobe Analytics and Quantum Metric, using Adobe Analytics to measure behavioral trends, funnel performance, and outcomes at scale, and Quantum Metric to surface session-level friction and technical issues that explain the root cause behind performance changes.
What You Need To Succeed (Minimum Qualifications)
- Minimum of 2-4 years in data analytics, preferably within the digital products or airline industry.
- Working knowledge of Adobe Analytics and Quantum Metric for dashboarding and analytics
- Hands-on experience building automated ETL/ELT pipelines on AWS, using S3, Glue, and Lambda
- Advanced SQL expertise, including complex joins, subqueries, dynamic SQL, pivoting/unpivoting, performance optimization, and advanced date/time logic.
- Intellectual curiosity with strong ability to interpret complex data and translate it into actionable insights.
- Excellent verbal and written communication skills, with attention to detail and the ability to present data-driven insights to non-technical stakeholders.
- Proven ability to work collaboratively in a fast-paced, team-oriented environment.
- Understanding of, and passion for, the airline industry and digital experiences is preferred
- Consistently prioritizes safety and security of self, others, and personal data.
- Embraces diverse people, thinking, and styles.
- Possesses a high school diploma, GED, or high school equivalency.
- Is at least 18 years of age and has authorization to work in the United States.
What Will Give You a Competitive Edge (Preferred Qualifications)
- Bachelor's degree in data science, Statistics, Computer Science, or Business Analytics. Advanced degree preferred.
Benefits And Perks To Help You Keep Climbing
Our culture is rooted in a shared dedication to living our values – Care, Integrity, Resilience, Servant Leadership, and Teamwork – every day, in everything we do. At Delta, our people are our success. At the heart of what we offer is our focus on Sharing Success with Delta employees. Exploring a career at Delta gives you a chance to see the world while earning great compensation and benefits to help you keep climbing along the way:
- Competitive salary, industry-leading profit sharing program, and performance incentives
- 401(k) with generous company contributions up to 9%
- Paid time off including vacation, holidays, paid personal time, maternity and parental leave
- Comprehensive health benefits including medical, dental, vision, short/long term disability and life benefits
- Family care assistance through fertility support, surrogacy and adoption assistance, lactation support, subsidized back-up care, and programs that help with loved ones in all stages
- Holistic Wellbeing programs to support physical, emotional, social, and financial health, including access to an employee assistance program offering support for you and anyone in your household, free financial coaching, and extensive resources supporting mental health
- Domestic and International space-available flight privileges for employees and eligible family members
- Career development programs to achieve your long-term career goals
- World-wide partnerships to engage in community service and innovative goals created to focus on sustainability and reducing our carbon footprint
- Business Resource Groups created to connect employees with common interests to promote inclusion, provide perspective and help implement strategies
- Recognition rewards and awards through the platform Unstoppable Together
- Access to over 500 discounts, specialty savings and voluntary benefits through Deltaperks such as car and hotel rentals and auto, home, and pet insurance, legal services, and childcare
