Software Engineering Lead Analyst

Evernorth℠ exists to elevate health for all, because we believe health is the starting point for human potential and progress. As champions for affordable, predictable and simple health care, we solve the problems others don’t, won’t or can’t.

Our innovation hub in India will allow us to work with the right talent, expand our global footprint, improve our competitive stance, and better deliver on our promises to stakeholders. We are passionate about making healthcare better by delivering world-class solutions that make a real difference. We are always looking upward. And that starts with finding the right talent to help us get there.

Position Overview

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.

Equal Opportunity Statement

Evernorth is an Equal Opportunity Employer actively encouraging and supporting organization-wide involvement of staff in diversity, equity, and inclusion efforts to educate, inform and advance both internal practices and external work with diverse client populations.

About Evernorth Health Services