Software Engineering Advisor - 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.     Section 2: Position Overview Provide a concise summary of the position, its purpose, and its importance within the company. Section 1: Job Title Clearly state the position’s title to convey the role and level of responsibility. Software Engineering Advisor   Position Overview     Evernorth Customer Data Platform Engineering team is looking for a Software Engineering Advisor highly skilled in Data Engineering with hands-on experience working with Snowflake. The ideal candidate will have a strong background in Big Data technologies, including Apache Spark (Python or Scala), and expertise in orchestration and integration tools such as Apache Airflow or NiFi, or DBT. Experience with cloud services, preferably AWS, is essential for designing and implementing scalable data pipelines in the cloud. This role offers the opportunity to work on cutting-edge data engineering projects and collaborate with cross-regional teams to deliver innovative solutions.   In this role, you will provide hands-on software engineering and system architecture leadership for our CDP teams. You will be working on several of the largest Technology initiatives for Evernorth℠ targeted at revolutionizing Health Services and Healthcare Delivery system in the United States. The focus of the work is to continue to enhance our market winning capabilities in the pharmacy and PBM space.   The Evernorth℠Technology strategy is fully aligned with our business strategy, resulting in an opportunity for you to influence in various directions – this includes technology\business direction.                   Section 3: Responsibilities Clearly outline the primary duties and tasks associated with the role. Use action verbs (i.e., lead, drive, analyze, assess, research, etc.) to convey expectations. Responsibilities   • Snowflake Expertise: Design, develop, and optimize data pipelines using Snowflake, including building and maintaining multi-layered data models. Optimize queries, ensure performance, and manage the cost efficiency of Snowflake environments. • Cloud Experience: Extensive experience working with AWS or other cloud platforms (such as Azure or Google Cloud) to design, deploy, and manage scalable data solutions. Proficient in utilizing cloud-native services for data storage, processing, and orchestration (e.g., S3, EMR, EC2, Redshift, Athena, Lambda, Glue). Familiar with setting up and managing cloud environments for optimal performance and cost-efficiency. • Big Data Engineering: Lead the design and development of Big Data solutions using Apache Spark (Python/Scala), enabling the processing of petabytes of data in both real-time and batch modes. Work with both structured and unstructured data to build efficient data architectures. • Data Orchestration & Integration: Develop and manage end-to-end ETL/ELT pipelines using Apache Airflow, Apache NiFi, DBT, or other equivalent orchestration tools. Automate data workflows, schedule tasks, and ensure the reliability of data pipelines. • Data Modeling: Design and implement scalable and efficient data models for data storage and retrieval, ensuring data accessibility