Specialist, Data Analytics and Insights- Digital Experience
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. Apply tot his job