Software Engineering Lead Analyst

Software Engineering Lead Analyst - HIH - Evernorth

ABOUT EVERNORTH:

Evernorth exists to elevate health for all, because we believe health is the starting point for human potential and progress. As champions for affordable, predictable and simple health care,
we solve the problems others don t, won t or can t.

Our innovation hub in India will allow us to work with the right talent, expand our global footprint, improve our competitive stance, and better deliver on our promises to stakeholders. We are passionate about making healthcare better by delivering world-class solutions that make a real difference.

We are always looking upward. And that starts with finding the right talent to help us get there.

Position Overview

Responsible for overall design and development of data integration code for the engineering team/asset. Responsible for providing technical knowledge on integration and ETL processes to build and establish coding standards.

Create a working agreement withing the team and other stakeholders that are involved. Partner and align with Enterprise Architect, Product Owner, Production Support, Analyst, PVS Testing team, and data engineers to build solutions that conform to defined standards.

Responsibilities

Well versed in design, development, and unit testing of ETL jobs that read and writes data from database tables, flat files, datasets, IBM MQ s, Kafka topics, S3 files, etc.

Carry out Data Profiling of Source data and generate logical data models (as required or applicable).

Define, document, and complete System Requirements Specifications including Functional Requirements, Context Diagrams, Non-Functional Requirements, and Business Rules (as applicable for Sprints to be complete).

Create Source-to-Target mapping documents as required and applicable.

Support definition of business requirements including assisting the Product Owner in writing user stories and acceptance criteria for user stories.

Support other scrum team members during the following activities (as required or applicable).

Design of test scenarios and test cases.

Develop and identify data requirements for Unit, Systems, and Integration tests.

Qualifications

Required Skills:

Adept working experience in design and development of performance efficient ETL flows dealing with millions of rows in volume.

Must have experience working in SAFE Agile Scrum project delivery model.

Good at writing complex SQL queries to pull data out of RDBMS databases like Oracle, SQL Server, DB2, Teradata, etc.

Good working knowledge of Unix scripts.

Batch job scheduling software such as CA ESP.

Experienced in using CI/CD methodologies.

Education

• Bachelor s degree in Computer Science, Software Engineering, or related field. A Masters degree is a plus.
• Certifications: Relevant certifications in AWS a plus

Location & Hours of Work

• Full-time position, working 40 hours per week. Expected overlap with US hours as appropriate
• Primarily based in the Innovation Hub in Hyderabad, India in a hybrid working model (3 days WFO and 2 days WAH)

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