Data Engineer, Global Health and Wellbeing

United States, Georgia, Atlanta

Global Health and Wellbeing

29-Aug-2024

Ref #: 25940

How you'll help us Keep Climbing (overview & key responsibilities)

The Data Engineer position plays a critical role in designing, developing, and maintaining complex data pipelines and analytics solutions. They will work closely with business unit leaders, data scientists, and other stakeholders to deliver timely and accurate business insights to other departments. This position will become the subject matter expert in Delta Wellness and Sedgwick data, AWS, and Tableau, leading requirements meetings and providing solutions to stakeholders, solving highly ambiguous data issues, and providing mentorship to other data engineers and analysts.

• Design, create and maintain complex data process using AWS Glue, Python, and SQL.

• Gather requirements, develop, test and maintain dashboards in Tableau and AWS QuickSight

• Validate data to ensure accuracy and consistency in the GHW datawarehouse and create documentation for data pipelines, processes, and systems.

• Lead and coach other less senior team members.

• Interface with business unit leaders to understand requirements and maintain strong internal and external customer relationships.

• Utilize statistical and data science approaches to deliver insights and reporting for physical health, mental wellbeing, and other wellness operations across Delta Air Lines footprint.

• Provide recommended enhancements to existing processes and systems.

• Utilize statistical and data science approaches to deliver insights and reporting for physical health, mental wellbeing, disability, and other wellness operations across Delta Air Lines footprint.

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

What you need to succeed (minimum qualifications)

• Bachelor’s degree in Computer Science, Data Science, or a related field.

• Minimum of 5 years of relevant work experience in data engineering, ETL, or related roles

• Type of Experience:

• Hands-on experience designing, building, and maintaining data pipelines.

• Proficiency in ETL processes, data transformation, and data integration.

• Familiarity with relational databases (SQL)

• Data Visualization: Exposure to creating dashboards using tools like Tableau or QuickSight.

• Leadership and Mentoring: Prior experience leading a team or mentoring junior engineers.

• 2+ years working with disability and workers’ compensation data

• Proficiency in designing, developing, and maintaining data pipelines.

• Strong understanding of ETL (Extract, Transform, Load) processes.

• Experience with tools like AWS Glue, Apache Spark, or similar.

• Knowledge of relational databases (e.g., PostgreSQL, Redshift, Teradata)

• Ability to design efficient data models (e.g., star schema, snowflake schema).

• Strong programming skills in Python for data manipulation, scripting, and automation.

• Expert with SQL for querying and data transformation.

• Proficiency in creating dashboards using tools like Tableau and Amazon QuickSight.

• Understanding of data visualization best practices.

• Experience with AWS cloud platform

• Ability to validate data for accuracy, consistency, and completeness.

• Implementing data quality checks and monitoring.

• Collaborating effectively in an agile environment.

• Solving complex data engineering challenges.

• Analyzing data-related issues and proposing solutions.

• Experience with mentoring junior engineers, and providing technical guidance.

• Ability to drive projects and initiatives.

• Creating clear and concise documentation for data pipelines, processes, and architectural decisions.

• Identifying areas for process improvement and suggesting enhancements

• Strong written, oral communication and interpersonal skills

• Strong organizational and prioritization skills

• Must be able to interact and collaborate at all levels within Delta and across groups

• 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)

• Advanced degree

Delta Air Lines, Inc. is an Equal Employment Opportunity / Affirmative Action employer and provides reasonable accommodation in its application process for qualified individuals with disabilities and disabled veterans. If you are a qualified individual, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings through this site, apply for jobs through Delta’s online system, or at any point in the selection process. To request a reasonable accommodation, please click here