Software Engineering Advisor- Hybrid

cigna; Bloomfield (CT); Hybrid; USD 154,000 - 186,000; Full time

Benefits offered by this job

Medical

Vision

Dental

401(k)

Life insurance

Tuition reimbursement

18 days PTO

Paid holidays

Leaves of absence

Job summary

The Cigna Group in Bloomfield, CT is seeking a Software Engineering Advisor to design, build, and optimize scalable data pipelines using Python, SQL, and Spark (Databricks/EMR). You will ensure reliability, performance, and maintainability for batch and streaming workloads.

Responsibilities include Teradata Vantage workloads, AWS data platforms, Delta Lake storage, Terraform provisioning, CI/CD with Jenkins, governance with Immuta/Delphix, observability with Splunk, and BI publishing with

Qualifications

• Bachelor’s degree in CS/Engineering or related field.
• 5+ years in software/data engineering in healthcare domain.
• Experience building large data pipelines with Python and Spark (Databricks).
• AWS data services: S3, Glue, EC2, IAM, VPC, Lake Formation.
• CI/CD and DevOps with Jenkins/CloudBees; Terraform proponent.
• Experience with data governance, masking, and enterprise security.

Responsibilities

• Design and build scalable batch and streaming data pipelines.
• Develop and support Teradata Vantage SQL workloads and data platforms on AWS.
• Operate lakehouse storage with Delta Lake, Iceberg, or Hudi.
• Provision infrastructure with Terraform; enforce cost controls and security.
• Create CI/CD pipelines and governance with tools like Jenkins, Ansible, Immuta, Delphix.
• Implement observability with Splunk; publish datasets to Tableau/Looker BI tools.
• Prototype GenAI use cases with AWS Bedrock; ensure SDLC and security compliance.

Skills

Python

Apache Spark

Databricks

Teradata

AWS

CI/CD

Jenkins

Terraform

Kafka

Tableau

Looker

Delta Lake

Iceberg

Hudi

REST APIs

GenAI

Education

Bachelor’s degree in Computer Science, Computer Engineering or related field

Tools

Databricks

EMR

Terraform

Jenkins/CloudBees

Ansible

Splunk

Delphix

Immuta

Delta Lake

Iceberg

Hudi

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

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.

Benefits

• medical
• vision
• dental
• well-being and behavioral health programs
• 401(k)
• company paid life insurance
• tuition reimbursement
• minimum of 18 days of paid time off per year
• paid holidays
• leaves of absence

About The Cigna Group

Doing something meaningful starts with a simple decision, a commitment to changing lives. 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 for employment in a manner consistent with all federal, state and local ordinances.