Software Engineering Advisors- Hybrid

Cigna Healthcare; Plano (TX); Hybrid; USD 120,000 - 170,000; Full time

Job summary

The Cigna Group in Plano, Texas is seeking a Senior Data Engineer to design modular ETL workflows with PySpark, build data warehouses and data lakes, and enable enterprise analytics. You will ensure data quality, compliance with HIPAA, and provide production support for data pipelines in a hybrid work model.

You will work across Customer, Provider, Claims, Client, and Benefits data domains, leveraging tools like Spark, Snowflake, AWS, and BI platforms.

Qualifications

• Master’s degree in Data Science, Computer Science or closely related field with 3 years ETL design experience.
• Bachelor’s degree with 7 years experience acceptable.
• Experience designing ETL pipelines with PySpark, Scala, SQL, and Shell scripting.
• Proficiency in PostgreSQL, MySQL, or SQL Server; Cassandra; Snowflake.

Responsibilities

• Design and implement modular ETL workflows using PySpark for data ingestion, cleansing, transformation and optimization.
• Monitor production jobs and provide operational support to troubleshoot data failures; ensure reliability.
• Deliver enterprise-level data solutions to support analytics and reporting.
• Serve as SME for data management assignments; collaborate with stakeholders across departments.
• Design and develop consolidated data warehouse and data lake for Customer, Provider, Claims, Client, and Benefits data.
• Analyze data to extract actionable insights and align with client reporting needs.
• Optimize data models and transformations for accuracy and relevance.
• Apply NLP techniques and domain knowledge to interpret healthcare data for business use.
• Develop and manage CI/CD pipelines using GitHub Actions to automate code integration, testing, deployment, and release management.
• Ensure HIPAA/PHI data handling compliance during processing.
• Translate business requirements into technical solutions; align outcomes with client goals.
• Hybrid work schedule.

Skills

PySpark

Scala

SQL

Shell scripting

PostgreSQL

MySQL

SQL Server

Cassandra

Snowflake

Parquet

CSV

ORC

Hadoop

Hive

Spark

Kafka

AWS Glue

IAM

EC2

EMR

RDS

S3

Athena

Step Functions

Lambda

Data mapping

Data validation

Data modeling

CI/CD

GitHub

GitLab

Tableau

Power BI

Delta Lake

Databricks

RabbitMQ

NLP

Terraform

Git

Jira

Education

Master’s degree in Data Science, Computer Science or closely related field

3 years of ETL design experience

Bachelor’s degree with 7 years experience

Tools

Databricks

Tableau

Power BI

Job description

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.