Application Development Senior Advisor- Hybrid

Cigna Healthcare; Morris Plains (NJ); Hybrid; USD 193,000 - 204,000; Full time

Benefits offered by this job

Health benefits

401(k)

Life insurance

Paid time off

Paid holidays

Job summary

The Cigna Group is seeking a data engineering professional to design and implement scalable data pipelines using AWS, Databricks, and Spark. You will implement governance, data models, and secure data access across healthcare datasets while leveraging Gen AI enhancements.

Hybrid work arrangement available with competitive salary and a comprehensive benefits package including medical, retirement, and PTO. Candidates should have strong SQL, PySpark, and data warehouse experience.

Qualifications

• Master’s degree in Computer Science, Business Analytics or related field and 3 years of experience.
• Will accept a Bachelor’s degree and 5 years of experience.
• Experience with scalable ETL pipelines, collaborative analytics workflows, and production‑grade data solutions using PySpark.
• AWS S3 for storage and integration.
• Writing advanced SQL queries for data extraction, transformation, and analysis within large‑scale data environments.
• Designing and implementing logical and physical data models.
• Applying best practices for schema design.
• Maintaining enterprise‑level data warehouses with reliable ETL processes.
• Orchestrating, monitoring, and optimizing big data pipelines for ingestion, transformation, and quality assurance of high‑volume data.

Responsibilities

• Develop solutions using tools in AWS, Databricks, Airflow, Redshift, DynamoDB, Elasticsearch, RDS, Snowflake, and Machine Learning tools.
• Develop production data pipelines using Spark with Scala, Python, SQL, and implementing machine learning algorithms on Databricks and AWS.
• Participate in architectural decision‑making processes for data pipelines and implement advanced analytics solutions, ensuring alignment with organizational goals.
• Assemble large and complex data sets, ensuring that all functional and analytics business requirements are met with high quality and performance standards.
• Utilize Generative AI tools to automatically generate comprehensive descriptions for data tables and columns and ingest the generated metadata into the Collibra Data Catalog via APIs.
• Demonstrate experience in implementing data governance and access control within the Healthcare domain.
• Configure Immuta to enable column‑level masking for PII and PHI, as well a row‑level security.
• Lead the adoption of Gen AI‑enhanced development pipelines with Cursor AI, focusing on advanced debugging, code generation, and context‑aware engineering across multi‑file projects.
• Apply expert prompt engineering techniques to improve the reliability and performance of AI‑driven data workflows.
• Continuously test and refine prompts to achieve optimal outcomes.
• Manage GitHub repositories and GitHub Actions CI/CD pipelines to automate deployment of Databricks jobs and notebooks.
• Collaborate with stakeholders, including executive leadership, product, and engineering teams, to resolve data‑related technical issues and support their data infrastructure needs.
• Mentor, collaborate and upskill junior engineers with translating complex business requirements into scalable data solutions to ensure team‑wide technical excellence.
• Hybrid work schedule.

Skills

PySpark

ETL pipelines

AWS S3

SQL queries

Data modeling

Big data pipelines

Education

Master’s degree in Computer Science/Business Analytics or related field

Bachelor’s degree with 5 years of experience

Tools

Databricks

Airflow

Snowflake

Redshift

DynamoDB

Elasticsearch

RDS

Job description

Responsibilities

• Develop solutions using tools in AWS, Databricks, Airflow, Redshift, DynamoDB, Elasticsearch, RDS, Snowflake, and Machine Learning tools.
• Develop production data pipelines using Spark with Scala, Python, SQL, and implementing machine learning algorithms on Databricks and AWS.
• Participate in architectural decision‑making processes for data pipelines and implement advanced analytics solutions, ensuring alignment with organizational goals.
• Assemble large and complex data sets, ensuring that all functional and analytics business requirements are met with high quality and performance standards.
• Utilize Generative AI tools to automatically generate comprehensive descriptions for data tables and columns and ingest the generated metadata into the Collibra Data Catalog via APIs.
• Demonstrate experience in implementing data governance and access control within the Healthcare domain.
• Configure Immuta to enable column‑level masking for PII and PHI, as well a row‑level security.
• Lead the adoption of Gen AI‑enhanced development pipelines with Cursor AI, focusing on advanced debugging, code generation, and context‑aware engineering across multi‑file projects.
• Apply expert prompt engineering techniques to improve the reliability and performance of AI‑driven data workflows.
• Continuously test and refine prompts to achieve optimal outcomes.
• Manage GitHub repositories and GitHub Actions CI/CD pipelines to automate deployment of Databricks jobs and notebooks.
• Collaborate with stakeholders, including executive leadership, product, and engineering teams, to resolve data‑related technical issues and support their data infrastructure needs.
• Mentor, collaborate and upskill junior engineers with translating complex business requirements into scalable data solutions to ensure team‑wide technical excellence.
• Hybrid work schedule.

Qualifications

• Master’s degree Computer Science, Business Analytics or related field and 3 years of experience. Will accept a Bachelor’s degree and 5 years of experience.
• Must have experience with: developing and managing scalable ETL pipelines, collaborative analytics workflows, and production‑grade data solutions using PySpark;
• Leveraging AWS S3 for storage and integration;
• Writing advanced SQL queries for data extraction, transformation, and analysis within large‑scale data environments;
• Designing and implementing logical an physical data models;
• Applying best practices for schema design;
• Maintaining enterprise‑level data warehouses with reliable ETL processes;
• Orchestrating, monitoring, and optimizing big data pipelines for the ingestion, transformation, and quality assurance of high‑volume data across distributed computing frameworks; and
• Troubleshooting, optimizing query performance and execution plans, and resource allocation for large‑scale datasets.

Salary Range: $193,461-$203,600

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 122,200 - 203,600 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. For more details on our employee benefits programs.

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.