Data Engineering Lead Analyst - HIH - Evernorth
ExternalPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
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.
Requirements
- 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.
- 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
Benefits
Additional Information
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.
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at Cigna? Share your experience