About the role
Data Engineering Lead Analyst
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.
Skills & Tags
Aplyr's read
Cigna is a global health services leader, attracting professionals dedicated to advancing healthcare solutions and improving patient outcomes worldwide.
What's promising
- •Cigna's diverse roles offer opportunities across healthcare, technology, and customer service sectors.
- •The company's global presence allows for international career growth and mobility.
- •Cigna invests in innovative health solutions, fostering a forward-thinking work environment.
What to watch
- •The healthcare industry faces regulatory challenges that may impact Cigna's operations.
- •Cigna's large size can lead to bureaucratic processes that slow decision-making.
- •Limited public information about Cigna's internal culture and employee satisfaction.
Why Cigna
- •Cigna's integration of Evernorth enhances its healthcare service offerings.
- •The company emphasizes innovation in health technology and AI enablement.
- •Cigna's focus on military and veteran partnerships sets it apart in healthcare services.
Aplyr’s read is generated by AI from public sources. Was it useful?
About Cigna
Cigna Healthcare is a global health services company dedicated to improving the health, well-being, and peace of mind of those they serve. They offer a wide range of health insurance products and services, including medical, dental, behavioral health, pharmacy, and disability insurance.
