HIH - Software Engineering Associate Advisor

HIH - Software Engineering Associate Advisor
 

Position Overview

The successful candidate will be a member of our US medical Integration Solutions ETL team. They will play a major role in the design and development if the ETL application in support of various portfolio projects.  

Responsibilities

• Analyze business requirements and translate into ETL architecture and data rules 
• Serve as advisor and subject matter expert on project teams 
• Manage both employees and consultants on multiple ETL projects. Oversee and review all design and coding from developers to ensure they follow company standards and best practices, as well as architectural direction 
• Assist in data analysis and metadata management 
• Test planning and execution 
• Effectively operate within a team of technical and business professionals 
• Asses new talent and mentor direct reports on best practices 
• Review all designs and code from developers 

Qualifications

Desired Skills & Experience:

• 8 - 11 Years of Experience in Java and Python, PySpark to support new development as well as support existing 
• 7+ Years of Experience with Cloud technologies, specifically AWS
• Experience in AWS services such as Lambda, Glue, s3, MWAA, API Gateway and Route53, DynamoDB, RDS MySQL, SQS, CloudWatch, Secrete Manager, KMS, IAM, EC2 and Auto Scaling Group, VPC and Security Groups
• Experience with Boto3, Pandas and Terraforms for building Infrastructure as a Code 
• Experience with IBM Datastage ETL tool 
• Experience with CD /CI methodologies and processing and the development of these processes 
• DevOps experience 
• Knowledge in writing SQL 
• Data mapping: source to target : target to multiple formats 
• Experience in the development of data extraction and load processes in a parallel framework 
• Understanding of normalized and de-normalized data repositories 
• Ability to define ETL standards & processes 

SQL Standards / Processes / Tools: 

• Mapping of data sources  
• ETL Development, monitoring, reporting and metrics  
• Focus on data quality  
• Experience with DB2/ZOS, Oracle, SQL Server, Teradata and other database environments  
• Unix experience  
• Excellent problem solving and organizational skills  
• Strong teamwork and interpersonal skills and ability to communicate with all management levels  
• Leads others toward technical accomplishments and collaborative project team efforts 
• Very strong communication skills, both verbal and written, including technical writing  
• Strong analytical and conceptual skills 

Location & Hours of Work

(Specify whether the position is remote, hybrid, in-office and where the role is located as well as the required hours of work)

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.