Data Engineering Advisor - HIH - Evernorth

Data Engineering Advisor - HIH - Evernorth

Evernorth℠ exists to elevate health for all, because we believe health is the starting point for human potential and progress. As champions for affordable, predictable and simple health care, we solve the problems others don’t, won’t or can’t. 

Our innovation hub in India will allow us to work with the right talent, expand our global footprint, improve our competitive stance, and better deliver on our promises to stakeholders. We are passionate about making healthcare better by delivering world-class solutions that make a real difference. We are always looking upward. And that starts with finding the right talent to help us get there.

Data Engineering Advisor
 

Position Overview

The Enterprise Operations Analytics (EOA) organization supports the data and analytical needs of Cigna’s Enterprise Operations. As a center of excellence for best practices in Data Engineering, Web Application Development, Data Science, Advanced Analytics, and Business Intelligence, the team brings together data from customer contact centers, client benefit design/install, provider solutions/network operations, print/digital communications, and beyond in novel ways to provide actionable insights to business partners ranging from front-line Prior Authorization Representatives and Patient Care Advocates to Senior Leadership. By turning data into information, and information into insight, we passionately strive to make the operational services provided by Cigna/Evernorth to customers, clients, and providers the safest, most efficient, most convenient, and most trusted in the world.

The Data Engineering Advisor will play a crucial role in transforming raw data into actionable insights that drive business decisions. To be successful in this role, you must have an advanced understanding of ETL processes along with excellent communication skills and be able to build and maintain relationships with both internal and external stakeholders.

They will be responsible for partnering with key players in Customer Service, Client Service, Provider Service, and Workforce Planning, while drawing on support from Technology, Finance, Strategy, Operational Readiness, and Solutions Delivery.

Roles & Responsibilities

• Design and implement ETL processes to extract, transform, and load data from various sources.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions.
• Optimize and maintain existing ETL workflows for improved efficiency and performance.
• Ensure data integrity and quality through rigorous testing and validation.
• Create and implement best practices to ensure successful delivery and support of large data transformation layer.
• Collaborate with other team members to ensure timely and successful delivery of production ready applications.
• Prepare detailed technical documentation.

Qualifications

Required Experience & Education: 

• 11 - 13 years of relevant ETL development using Informatica and/or SSIS.
• Hands-on experience with building data integration solutions using Dell Boomi.
• Experience with Relational Database Development – Oracle, Teradata, SQL Server required.
• Strong understanding of database concepts and experience with query optimization and performance tuning.
• Hands-on experience with scripting languages like Python.
• Hands on experience with Databricks and Airflow monitoring.
• Excellent problem-solving skills and the ability to analyze complex issues and implement effective solutions.

Required Skills:

• Informatica, SSIS, SQL (SQL Server, Oracle, Teradata)
• Any experience with Dell Boomi.
• Performance Tuning, Issue Resolution
• Python, Databricks, DevOps, Basic Cloud Experience (AWS/Azure)

Preferred Skills, Experience & Education:

• Cloud Certification (AWS Cloud Practitioner or similar)

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