Data Engineering Advisor - HIH - Evernorth
About Evernorth:
Evernorth Health Services, a division of The Cigna Group (NYSE: CI), creates pharmacy, care, and benefits solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention, and treatment of illness and disease more accessible to millions of people.
Role Title: Software Engineering Advisor
Position Summary:
Data engineer on the Data integration team
Job Description & Responsibilities:
- Work 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.
- 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.
Experience Required:
- Overall 11-13 years of experience
Experience Desired:
- Strong development experience in Spark, Py-Spark, Shell scripting, Teradata.
- Strong experience in writing complex and effective SQLs (using Teradata SQL, Hive SQL and Spark SQL) and Stored Procedures
- Healthcare domain knowledge is a plus
- Education and Training Required:
Primary Skills:
- Excellent work experience on Databricks as Data Lake implementations
- Experience in Agile and working knowledge on DevOps tools (Git, Jenkins, Artifactory)
- AWS (S3, EC2, SNS, SQS, Lambda, ECS, Glue, IAM, and CloudWatch)
- Databricks (Delta lake, Notebooks, Pipelines, cluster management, Azure/AWS integration
- Additional Skills:
- Experience in Jira and Confluence
- Exercises considerable creativity, foresight, and judgment in conceiving, planning, and delivering initiatives.
Location & Hours of Work
Hyderabad /General Shift (11:30 AM - 8:30 PM IST / 1:00 AM - 10:00 AM EST / 2:00 AM - 11:00 AM EDT)
Equal Opportunity Statement
Evernorth is an Equal Opportunity Employer actively encouraging and supporting organization-wide involvement of staff in diversity, equity, and inclusion efforts to educate, inform and advance both internal practices and external work with diverse client populations
About Evernorth Health Services
Evernorth Health Services, a division of The Cigna Group, creates pharmacy, care and benefit solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention and treatment of illness and disease more accessible to millions of people. Join us in driving growth and improving lives.