Job Description

The Software Engineering Advisor will w ork with business and technical leadership to understand requirements

Design to the requirements and document the designs

Ability to write product-grade performant code for data extraction, transformations and loading using Spark, Py-Spark

Do data modeling as needed for the requirements

Write performant queries using Teradata SQL, Hive SQL and Spark SQL against Teradata and Hive

Implementing dev-ops pipelines to deploy code artifacts on to the designated platform/servers like AWS or Hadoop Edge Nodes

Implement Hadoop job orchestration using Shell scripting, Apache Oozie, CA7 Enterprise Scheduler and Airflow

Troubleshooting the issues, providing effective solutions and jobs monitoring in the production environment

Participate in sprint planning sessions, refinement/story-grooming sessions, daily scrums, demos and retrospectives

Qualifications:

Must be a current contractor with Cigna Healthcare, Evernorth Health Services, or one of their subsidiaries.

Must have High School Diploma or equivalent plus 5 years experience

Strong development experience in Spark, Py-Spark, Shell scripting, Teradata, Hive and Hadoop

Experience of Ab Initio is a bonus

Strong experience in writing complex and effective SQLs (using Teradata SQL, Hive SQL and Spark SQL) and Stored Procedures

Excellent work experience on Hadoop as data warehouse/Data Lake implementations

Experience in Agile and working knowledge on DevOps tools (Git, Jenkins, Artifactory)

Unix/Linux Shell scripting (KSH) and basic administration of Unix servers

CA7 Enterprise Scheduler

AWS (S3, EC2, SNS, SQS, Lambda, ECS, Glue, IAM, and CloudWatch)

Databricks (Delta lake, Notebooks, Pipelines, cluster management, Azure/AWS integration)

Experience in Jira and Confluence

Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives.

Health care domain knowledge is a plus

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 require reasonable accommodation in completing the online application process, please email: SeeYourself@cigna.com for support. Do not email SeeYourself@cigna.com for an update on your application or to provide your resume as you will not receive a response.

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.

eQuest