Software Engineering Advisor - HIH - Evernorth

Overview

Data Engineer role supporting a data-heavy application, responsible for solutioning and productionizing data storage and retrieval, and expanding and optimizing data pipeline architecture and downstream data flows.

What you'll do

• Create, maintain and continuously improve optimal data pipeline architecture.
• Solution performance and scalable data storage and retrieval methods for large datasets for heavy data reliant applications.
• Gain knowledge about large, complex data sets that meet functional and non-functional business requirements.
• Help the application team with performance tuning of queries and help establish best practices.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS big data technologies.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Work with stakeholders including the Product, Business Analysts, Data Science and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Keep data separated and secure across national boundaries through multiple data centers and AWS regions.
• Be attentive to alerts or issues related to the database and take actions to resolve anomalies.

What you'll need

• 11 - 13 years of experience in a Data Engineer role.
• College degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
• Experience with big data technologies: Databricks and/or Snowflake.
• Experience with relational SQL and NoSQL databases.
• Experience with AWS cloud services: EC2, Glue Jobs, RDS, Lambda, EKS.
• Experience with stream-processing systems.
• Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience building and optimizing big data data pipelines, architectures and data sets.
• Expertise with performance tuning and query optimization.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• A successful history of manipulating, processing and extracting value from large disconnected datasets.
• Strong project management and organizational skills.
• Experience supporting and working with cross-functional teams in a dynamic environment.

Nice to have

• Experience with AWS.
• Experience using GenAI tools such as Cursor and Copilot.

Details

• Location: Hyderabad, India.