Software Engineering Associate Advisor - HIH - Evernorth

This role offers the opportunity to work on cutting-edge data engineering projects and collaborate with cross-regional teams to deliver innovative solutions. In this role, you will provide hands-on software engineering and system architecture leadership for our CDP teams.

About Cigna Group

• 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.
• The focus of the work is to continue to enhance our market winning capabilities in the pharmacy and PBM space.
• 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.

Responsibilities

• Section 1: Job Title Clearly state the position’s title to convey the role and level of responsibility.
• Associate Advisor Position Overview Evernorth Customer Data Platform Engineering team is looking for a Software Engineering Advisor highly skilled in Data Engineering with hands-on experience working with Snowflake.
• You will be working on several of the largest Technology initiatives for Evernorth℠ targeted at revolutionizing Health Services and Healthcare Delivery system in the United States.
• The Evernorth℠Technology strategy is fully aligned with our business strategy, resulting in an opportunity for you to influence in various directions – this includes technology\business direction.
• Section 3: Responsibilities Clearly outline the primary duties and tasks associated with the role.
• Use action verbs (i.e., lead, drive, analyze, assess, research, etc.) to convey expectations.
• Work with both structured and unstructured data to build efficient data architectures.
• Develop and manage end-to-end ETL/ELT pipelines using Apache Airflow, Apache NiFi, DBT, or other equivalent orchestration tools.
• Automate data workflows, schedule tasks, and ensure the reliability of data pipelines.
• Design and implement scalable and efficient data models for data storage and retrieval, ensuring data accessibility and optimization.
• Work on building and managing multi-layered data models that facilitate easy analysis and reporting.
• Build and optimize stream processing solutions to integrate event-driven data sources into the pipeline.
• Work with cross-functional teams, including product, engineering, to develop and implement data solutions.
• Manage and coordinate with offshore development teams to deliver high-quality data engineering solutions on time and within budget.
• Write complex SQL queries to transform and process data across relational and columnar databases.
• Design and maintain scalable database architectures for both operational and analytical workloads.
• Continuously seek ways to improve the performance, scalability, and reliability of the data platform.
• Drive innovation by researching and applying the latest tools and technologies in the data engineering space.

Requirements

• The ideal candidate will have a strong background in Big Data technologies, including Apache Spark (Python or Scala), and expertise in orchestration and integration tools such as Apache Airflow or NiFi, or DBT.
• Experience with cloud services, preferably AWS, is essential for designing and implementing scalable data pipelines in the cloud.
• Design, develop, and optimize data pipelines using Snowflake, including building and maintaining multi-layered data models.
• Optimize queries, ensure performance, and manage the cost efficiency of Snowflake environments.
• Extensive experience working with AWS or other cloud platforms (such as Azure or Google Cloud) to design, deploy, and manage scalable data solutions.
• Proficient in utilizing cloud-native services for data storage, processing, and orchestration (e.g., S3, EMR, EC2, Redshift, Athena, Lambda, Glue).
• Familiar with setting up and managing cloud environments for optimal performance and cost-efficiency.
• Lead the design and development of Big Data solutions using Apache Spark (Python/Scala), enabling the processing of petabytes of data in both real-time and batch modes.
• Work with Kafka or other streaming technologies to enable real-time data ingestion and processing.
• 10+ years of experience in Data Engineering, with a proven track record of designing and building data pipelines and architectures at scale. • At least 4 years of hands-on experience with Snowflake, including data modeling and query optimization, designing and implementing multi-layered data architectures • Experience with cloud services, preferably AWS (e.g., S3, EMR, EC2, Redshift, Athena, Lambda, Glue), for designing, deploying, and managing scalable data solutions. • Strong experience in Big Data technologies like
• Spark (Python/Scala) for large-scale data processing. • Proficiency in Data Orchestration and Integration tools, such as Apache Airflow, Apache NiFi, DBT, or equivalent. • Expertise in working with relational (e.g., SQL Server, PostgreSQL) and columnar databases (e.g., AWS Redshift, Snowflake), with advanced SQL query writing skills. • Hands-on experience with Kafka or equivalent streaming data systems to process real-time data. • Strong problem-solving skills and the ability to troubleshoot complex issues in distributed systems. • Proven ability to collaborate with offshore teams and coordinate across time zones to deliver successful projects. • Experience with version control systems like
• Bitbucket or GitHub, and project management tools such as Jira, with familiarity in working within an Agile/Sprint model. • Good to have experience with Jenkins for continuous integration and deployment (CI/CD) pipelines and Terraform for infrastructure as code (IaC) automation.
• 10+ Years of Experience • College degree (Bachelor) in related technical/business areas or equivalent work experience.

Preferred

• Exposure to AWS • Healthcare experience • Coaching of team members These two sections will be “standardized” in the JD template and made not editable.

Section 2: Position Overview Provide a concise summary of the position, its purpose, and its importance within the company.

Location

& Hours of Work (Specify whether the position is remote, hybrid, in-office and where the role is located as well as the required hours of work) 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.