HIH - Evernorth - Software Engineering Lead Analyst

Software Engineer

In this role, you will utilize your experience as a software engineer to help design, develop, monitor, troubleshoot and optimize data pipelines on AWS platform.

Responsibilities

• Design and implement end-to-end data pipelines using Python and Airflow, ensuring efficient scheduling, orchestration, and dependency management for complex workflows.
• Develop high-performance SQL queries for data extraction, transformation, and reporting, with a strong focus on query optimization and scalability across large datasets.
• Automate and modularize ETL processes leveraging Python scripting and reusable Airflow DAG components, adhering to best practices in software engineering and data governance.
• Work with AWS cloud services (S3, Glue, Redshift, Aurora RDS, CloudWatch) to enable scalable, secure, and cloud-native data processing and storage solutions.
• Integrate and transform data from multiple sources such as Alteryx, PostgreSQL, Oracle, and PL/SQL into unified data models to support analytics and reporting needs.

Qualifications

Required Skills

• Very strong skills in the following technologies:
  • Python
  • Apache Airflow - DAGs, Tasks, Scheduled, Operators etc.
  • SQL
  • AWS Services- S3, EC2, Glue, Redshift, PostgreSQL
• Strong written and verbal communication skills with the ability to interact with all levels of the organization.
• Familiarity with agile methodology.

• Good working knowledge of data warehousing concepts, dimensional models and relational databases, and data management.
• Git Based Distributed SW Code Management using GitHub etc.
• SW Code deployment using best CI/CD practices.
• Troubleshoot data issues surfacing in Tableau, ThoughtSpot due to Redshift, PostgreSQL DB

Required Experience & Education

• 5-8 years of experience
• College degree in any STEM based field.

About Evernorth Health Services

Evernorth Health Services, a division of The Cigna Group, creates pharmacy, care and benefit solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention and treatment of illness and disease more accessible to millions of people. Join us in driving growth and improving lives.