Data Engineering Lead Analyst - HIH - Evernorth

Job description

INTRODUCTION TO EVERNORTH:  Evernorth Health Services India, established in Hyderabad in 2024, is an innovation hub for Evernorth Health Services, the pharmacy, care and benefits division of The Cigna Group. The innovation hub will support innovation-focused areas, such as generative AI, product development, process improvement, analytics, and software engineering across The Cigna Group and its businesses.  Evernorth Health Services India builds on The Cigna Group’s existing presence in India. About Evernorth Health Services: Evernorth Health Services (Evernorth) is the pharmacy, care and benefits solution division of The Cigna Group - a Fortune 16 global health company with 75,000 employees, 186 million customers in more than 30 countries and jurisdictions around the world. Evernorth exists to make the prediction, prevention, and treatment of illness and disease more accessible to millions of people. We do this by creating and connecting premier health services offerings, such as benefits management, pharmacy, care solutions, insights and intelligence. About Cigna: The Cigna Group is a global health company committed to improving the health and vitality of individuals and communities around the world and includes products and services marketed under its Cigna Healthcare and Evernorth Health Services subsidiaries. Cigna Healthcare is the health benefits provider of The Cigna Group, serving customers and clients through its U.S. Employer, U.S. Government, and International Health business. Evernorth Health Services is the pharmacy, care and benefits solution division of The Cigna Group. Position Overview  As a Database Engineering Lead Analyst, you will design and optimize complex database architectures using SQL Server and Oracle. You will manage data lake architectures, implement ETL processes, and work with AWS cloud data services to support Evernorth’s enterprise healthcare data platforms and analytics solutions.  Responsibilities  • Design and optimize complex database architectures using SQL Server and Oracle.  • Develop and maintain stored procedures, functions, packages, and triggers.  • Design data models for enterprise healthcare applications (ER diagrams, dimensional modeling).  • Manage data lake architectures and data pipelines for analytics and reporting.  • Implement ETL processes for data integration across multiple source systems.  • Optimize query performance and perform database tuning for large-scale datasets.  • Implement database security, access controls, and data governance practices.  • Design disaster recovery and high-availability solutions for critical databases.  • Work with AWS cloud database services (RDS, Redshift, Athena, Glue, S3).  • Mentor junior database developers and perform code reviews.  • Create and maintain technical documentation for database designs and processes.  • Support data migration activities across environments and platforms.    Qualifications:  • 5 - 8 years of experience in database development and administration.  • College degree (Bachelor) in Computer Science or related field.  • Advanced SQL skills (T-SQL, PL/SQL) for complex query development.  • Strong experience with Oracle Database (12c/19c) and SQL Server.  • Knowledge of data lake concepts, architecture, and data pipeline design.  • Experience with AWS data services (RDS, Redshift, S3, Athena, Glue).  • ETL tool experience.  • Data modeling expertise (ER diagrams, star schema, dimensional modeling).  • Performance tuning and optimization skills for large databases.  • Understanding of data governance, quality, and security practices.    Preferred Qualifications:  • AWS Certified Database or Data Analytics certification.  </di