Software Engineering Advisor- Hybrid

Cigna Health and Life Insurance Company; Bloomfield (CT); Hybrid; USD 154,000 - 186,000; Full time

Benefits offered by this job

Health benefits

401(k) plan

Tuition reimbursement

Paid time off

Job summary

The Cigna Group seeks a Software Engineering Advisor in Bloomfield, CT to design, build, and optimize scalable batch and streaming data pipelines using Python, SQL, and Spark.

You will implement cloud-native data platforms on AWS, build lakehouse storage with Delta Lake/Iceberg/Hudi, and drive governance, CI/CD, and AI-enabled use cases while ensuring security and reliability. Hybrid work schedule included.

Qualifications

• Bachelor’s degree in Computer Science, Computer Engineering or related field and 5 years of software engineering experience in healthcare.
• Experience designing and building large-scale data pipelines with Python and Spark (Databricks); Teradata.
• Experience with AWS data and compute services (S3, Glue, EC2, IAM, VPC, Lake Formation, CloudWatch).
• Develop reusable Python libraries and automation frameworks for ETL and testing with cross-team adoption.
• CI/CD pipelines using Jenkins and CloudBees with automated testing, quality gates, and controlled release workflows.

Responsibilities

• Develop and support Teradata Vantage solutions leveraging QueryGrid/ ClearScape Analytics/ AI Unlimited for analytics and high-performance SQL workloads.
• Implement cloud-native data platforms on AWS (S3, Glue, EC2, VPC, IAM, Lake Formation), including secure networking and governance.
• Build lakehouse storage using Delta Lake plus Iceberg/Hudi for ACID transactions and time travel.
• Provision infrastructure with Terraform, ensuring repeatable environments and cost controls.
• Create and operate CI/CD pipelines and DevOps automation (Git, Jenkins, CloudBees, Ansible) with tests and release orchestration.
• Integrate governance and privacy controls using Immuta and Delphix for policy enforcement and environment refreshes.
• Design observability and incident response workflows with Splunk for proactive monitoring.
• Publish curated datasets and semantic layers for BI tools like Tableau/Looker.

Skills

Python

Apache Spark

Teradata

AWS

CI/CD

Terraform

Data governance

Security

SQL

Delta Lake

Education

Bachelor's degree in Computer Science

Tools

Databricks

Teradata Vantage

Jenkins

CloudBees

Terraform

Splunk

Tableau

Looker

Job description

Cigna-Evernorth Services Inc. seeks a Software Engineering Advisor for the Bloomfield, CT location to design, build, and optimize scalable batch and streaming data pipelines using Python, SQL, and Spark (Databricks/EMR), ensuring reliability, performance, and maintainability.

Responsibilities

• Develop and support Teradata Vantage solutions leveraging QueryGrid/ ClearScape Analytics/ AI Unlimited for advanced analytics, feature engineering, and high-performance SQL workloads.
• Implement cloud-native data platforms on AWS (S3, Glue, EC2, VPC, IAM, Lake Formation), including secure networking, role-based access, and governed data lake patterns.
• Build and manage lakehouse storage using Delta Lake plus open table formats (Apache Iceberg/Hudi), enabling ACID transactions, schema evolution, time travel, and efficient incremental processing.
• Provision and standardize infrastructure using Terraform, delivering repeatable environments and enforcing best practices for configuration, tagging, cost controls, and security.
• Create and operate CI/CD pipelines and DevOps automation (Git, CloudBees/ Jenkins, Ansible), including code quality gates, automated testing, and release orchestration.
• Integrate governance and privacy controls using tools like Immuta and Delphix, including policy enforcement, dynamic masking, tokenization, and compliant environment refresh processes.
• Design observability and incident response workflows with Splunk (logs/ metrics/ alerts), enabling proactive monitoring, root-cause analysis, and improved operational SLAs.
• Enable analytics and self-service reporting by publishing curated datasets and semantic layers for BI tools (Tableau/Looker), ensuring consistent KPI definitions and data quality.
• Apply prompt engineering and AWS Bedrock capabilities to prototype and productionize GenAI-enabled data/automation use cases, following SDLC standards, security controls, and responsible AI practices.
• Hybrid work schedule.

Qualifications

• Bachelor’s degree in Computer Science, Computer Engineering or related field and 5 years of experience in any software engineering role in the healthcare domain.
• Must have experience with:
  • Designing and building large scale data pipelines using Python and Apache Spark (Databricks); Teradata;
  • Supporting both batch and scheduled processing including data validation and quality checks;
  • AWS data and computational services to deploy, secure, and monitor production data workloads including S3, Glue, EC2, IAM, VPC, Lake Formation, and Cloudwatch;
  • Developing reusable Python libraries and frameworks for automation, ETL utilities, DDL validation, and test data validation, with adoption across multiple engineering teams;
  • Implementation and ownership of CI/CD pipelines using Jenkins and CloudBees including automated testing, quality gates, versioning, and controlled release workflows; working with Teradata Vantage (QG/OTF/TD MCP);
  • Oracle including performance aware query design and schema validation;
  • Modern data lake technologies for reliable and scalable data storage including Delta Lake, Apache Iceburg, and Apache Hudi;
  • Design and implementation of REST APIs including contract definition, input validation, backwards compatibility, and secure access patterns;
  • Kafka experience including developing and operating producer/ consumer for data ingestion and integration workflows;
  • Data protection and compliance implementation, including data masking and tokenization using tools such as Delphix, particularly for lower environment refreshes from production;
  • Infrastructure automation using Terraform, enabling repeatable, compliant environment provisioning;
  • End to end SDLC ownership in an Agile/Scrum environment including requirements analysis, solution design, code reviews, unit and integration testing, and production support;
  • Incorporating AI features into data or automation solutions in an enterprise environment including using cursor, Copilot/VSCode, and MCP servers;
  • Development and orchestration of data workflows including scheduling, dependency management, and failure handling;
  • Automation of operational and reporting workflows, including building data pipelines and BI dashboards to reduce manual reporting using Looker and Tableau;
  • Scripting and automation background including using Python, Groovy, and Shell to eliminate repetitive operational tasks; and, working in regulated enterprise environments with awareness of data privacy, security, and audit requirements.

Salary Range: $154,024-$186,100/year

If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.

For this position, we anticipate offering an annual salary of 111,700 - 186,100 USD / yearly, depending on relevant factors, including experience and geographic location. This role is also anticipated to be eligible to participate in an annual bonus plan.

At The Cigna Group, you’ll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. Starting on day one of your employment, you’ll be offered several health-related benefits including medical, vision, dental, and well-being and behavioral health programs. We also offer 401(k), company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year, paid holidays, and leaves of absence.

About The Cigna Group

At The Cigna Group, we’re dedicated to improving the health and vitality of those we serve. Through our divisions Cigna Healthcare and Evernorth Health Services, we are committed to enhancing the lives of our clients, customers and patients. Join us in driving growth and improving lives.

Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.

If you need a reasonable accommodation to complete the online application process, please email [e-mail] for assistance. Please note that this email inbox is dedicated to accommodation requests only and cannot provide application updates or accept resumes.

The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State.

Qualified applicants with criminal histories will be considered in a manner consistent with all federal, state and local ordinances.