Software Engineering Advisors- Hybrid

Cigna Health and Life Insurance Company; Plano (TX); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Hybrid work schedule

Job summary

The Cigna Group in Plano, TX seeks Software Engineering Advisors to design and maintain scalable data pipelines in Databricks, delivering high-quality data for client deliverables. You will collaborate with cross-functional teams to ensure HIPAA-compliant, reliable analytics infrastructure.

Responsibilities focus on ETL workflow design using PySpark, SQL, and Scala, building a robust data lake and warehouse, and enabling CI/CD with GitHub Actions for automated deployment.

Qualifications

• Master’s degree in Data Science, Computer Science or related field with 3 years’ ETL design experience or Bachelor’s with 7 years’ experience.
• Proficient in PySpark, Scala, SQL, and Shell scripting for robust ETL pipelines.
• Experience with multiple database systems (PostgreSQL, MySQL, SQL Server) and big data platforms like Hadoop, Spark, Kafka.

Responsibilities

• Design and implement modular ETL workflows for data ingestion, cleansing, transformation and optimization.
• Monitor production jobs and provide operational support for reliability and business continuity.
• Deliver enterprise data solutions that support analytics and reporting.
• Develop consolidated enterprise data warehouse and data lake across critical domains.
• Collaborate with stakeholders to translate business requirements into technical solutions.

Skills

ETL pipelines

Data analysis

Problem solving

Education

Master's degree in Data Science or Computer Science

7+ years experience with Bachelor's

Tools

Databricks

PostgreSQL

MySQL

SQL Server

Cassandra

Snowflake

Hadoop

Hive

Spark

Kafka

AWS Glue

IAM

EC2

EMR

RDS

S3

Athena

Step Functions

Lambda

GitHub

GitLab

Tableau

Power BI

Delta tables

Job description

Cigna-Evernorth Services Inc. seeks Software Engineering Advisors for the Plano, TX location to build and maintain scalable data pipelines in Databricks to deliver high-quality, timely data for client deliverables.

Responsibilities

• Design and implement modular ETL workflows using PySpark for data ingestion, cleansing, transformation and optimizing large volumes of structured medical data.
• Monitor production jobs and provide operational support to troubleshoot data failures, ensuring system reliability and business continuity.
• Participate in the delivery of enterprise-level data solutions that support strategic decision-making via analytics and reporting.
• Serve as subject matter expert for critical information Management assignments, collaborating with stakeholders across departments.
• Design and develop consolidated conformed enterprise data warehouse and data lake to store critical data across Customer, Provider, Claims, Client, and Benefits data.
• Analyze data to extract actionable insights, improve data usability, and ensure alignment with client-specific reporting and business requirements.
• Optimize data models and transformation logic to enhance data accuracy and relevance for downstream analytics.
• Apply statistical techniques and domain knowledge to interpret healthcare accurately, ensuring its relevance and usability for business teams and leadership.
• Develop and manage CI/CD pipelines using tools like GitHub Actions to automate code integration, testing, deployment and release management for data workflows.
• Ensure data compliance with healthcare regulations, including HIPAA and PHI handling guidelines, during all stages of data processing.
• Translate business requirements into technical solutions by understanding and visualizing complex data flows.
• Aligning outcomes with client goals.

Hybrid work schedule.

Qualifications

• Master’s degree in Data Science, Computer Science or closely related field and 3 years of experience designing ETL pipelines. Will accept a Bachelor’s degree and 7 years of experience.
• Must have experience with:
  • Designing and developing robust ETL pipelines using PySpark, Scala, SQL, and Shell scripting
  • PostgreSQL, MySQL, or SQL Server
  • Cassandra
  • Snowflake
  • Using multiple file formats in data pipelines, including Parquet, CSV, and ORC
  • Big Data technologies such as Hadoop, Hive, Spark, or Kafka
  • AWS tools such as Glue, IAM, EC2, EMR, RDS, S3, Athena, Step Functions, or Lambda
  • Data mapping, validation, and modeling
  • Building and maintaining CI/CD pipelines using GitHub or GitLab
  • Reporting and BI tools such as Tableau or Power BI
  • Working with Delta tables in Databricks
  • RabbitMQ for queuing high-speed sensor data
  • Natural Language Processing (NLP) techniques
  • DevOps tools such as Terraform, Git, and Jira
• 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.

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.

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.