What are the responsibilities and job description for the Data Engineering Lead Analyst -= HIH - Evernorth position at 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.
Experience with Python scripting for database automation.
Healthcare data domain expertise.
Industry / Domain Experience Needed:
Demonstrated experience in enterprise database engineering and data architecture.
Ability to navigate a geographically diverse team and communicate effectively.
Familiarity with healthcare data standards and regulatory requirements.
Passion for data quality, performance, and operational excellence.
Location & Hours of Work
Full-time position, working 40 hours per week. Primarily based in the Innovation Hub in Hyderabad, India, with flexibility to work remotely as required.
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.