Data Engineering Associate Advisor - HIH - Evernorth

Data Engineering Associate 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 Associate 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:  

• 8 - 11 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) 

 

 

 

   

  

 

Location & Hours of Work 

(Specify whether the position is remote, hybrid, in-office and where the role is located as well as the required hours of work) 

 

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.