Software Engineering Advisor – eviCore

Cigna Health and Life Insurance Company; Franklin (TN); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Cigna Health and Life Insurance Company in Franklin, TN seeks a Software Engineering Advisor to design and optimize scalable data solutions. You will build ETL pipelines, develop dimensional data models, and apply complex business rules to ensure data accuracy for analytics and reporting.

You will collaborate in Agile teams, provide production support, and train operations on new data processes while documenting data architecture and governance practices.

Qualifications

• 5+ years of experience building data engineering solutions in Big Data and/or cloud environments.
• Strong proficiency in Spark, Python, and SQL, with hands-on experience in Databricks or similar platforms.
• Experience working with relational databases such as SQL Server, DB2, or Oracle.
• Solid understanding of data modeling, data architecture, and data governance principles.
• Experience developing and maintaining ETL pipelines in enterprise environments.
• Ability to troubleshoot complex data issues and optimize performance across systems.
• Strong communication skills with the ability to translate technical concepts for diverse audiences.
• Proven ability to collaborate within cross-functional and Agile teams.

Responsibilities

• Design and build scalable ETL pipelines that enable reliable data flow from source to target environments using tools such as Databricks, Azure Data Factory, and SSIS
• Develop and enhance dimensional data models to support analytics, reporting, and business insights
• Apply business rules through code (SQL, Python, Scala, Spark) to ensure data accuracy, consistency, and usability across stakeholders
• Optimize and fine-tune existing data pipelines to improve performance, efficiency, and scalability
• Troubleshoot data and ETL issues, ensuring timely resolution and minimal impact to downstream processes
• Collaborate in Agile development practices, including sprint ceremonies, peer code reviews, and quality assurance activities
• Provide production support, including on-call rotation and partnership with offshore operations teams
• Train and enable operations teams on newly developed data processes and enhancements
• Create and maintain clear documentation of data architecture, ETL processes, and data management practices
• Partner with business users to support reporting and analytics needs using tools such as Tableau, MicroStrategy, and SSRS
• Leverage AI-assisted development tools (e.g., GitHub Copilot, Cursor) to improve development efficiency and code quality

Skills

Spark

Python

SQL

Databricks

ETL pipelines

Data modeling

Data governance

Communication

Agile

Education

Bachelor’s degree in CS/IS

Tools

SQL Server

DB2

Oracle

Azure Data Factory

Azure Databricks

Job description

## Software Engineering Advisor – eviCoreApplyremote type: Hybridlocations: Franklin, TNtime type: Full timeposted on: Posted 8 Days Agojob requisition id: 26006638**Drive data innovation that powers smarter healthcare decisions.** As a Software Engineering Advisor, you will play a critical role in building and optimizing scalable data solutions that enable accurate, timely insights across eviCore. This role combines hands-on engineering with collaboration across teams to ensure high-quality, trusted data fuels business and clinical outcomes.**Responsibilities*** Design and build scalable ETL pipelines that enable reliable data flow from source to target environments using tools such as Databricks, Azure Data Factory, and SSIS* Develop and enhance dimensional data models to support analytics, reporting, and business insights* Apply business rules through code (SQL, Python, Scala, Spark) to ensure data accuracy, consistency, and usability across stakeholders* Optimize and fine-tune existing data pipelines to improve performance, efficiency, and scalability* Troubleshoot data and ETL issues, ensuring timely resolution and minimal impact to downstream processes* Collaborate in Agile development practices, including sprint ceremonies, peer code reviews, and quality assurance activities* Provide production support, including on-call rotation and partnership with offshore operations teams* Train and enable operations teams on newly developed data processes and enhancements* Create and maintain clear documentation of data architecture, ETL processes, and data management practices* Partner with business users to support reporting and analytics needs using tools such as Tableau, MicroStrategy, and SSRS* Leverage AI-assisted development tools (e.g., GitHub Copilot, Cursor) to improve development efficiency and code quality**Required Qualifications*** 5+ years of experience building data engineering solutions in Big Data and/or cloud environments* Strong proficiency in Spark, Python, and SQL, with hands-on experience in Databricks or similar platforms* Experience working with relational databases such as SQL Server, DB2, or Oracle* Solid understanding of data modeling, data architecture, and data governance principles* Experience developing and maintaining ETL pipelines in enterprise environments* Ability to troubleshoot complex data issues and optimize performance across systems* Strong communication skills with the ability to translate technical concepts for diverse audiences* Proven ability to collaborate within cross-functional and Agile teams**Preferred Qualifications*** Experience implementing Azure-based data solutions (ADLS, Azure Databricks, Synapse, Azure Data Factory)* Experience working with healthcare or clinical data domains* Familiarity with reporting and visualization tools such as Tableau, MicroStrategy, or SSRS* Experience leveraging AI-assisted development tools to accelerate engineering workflows* Bachelor’s degree in Computer Science, Information Systems, or related field If you will be working at home occasionally or permanently, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 10Mbps download/5Mbps upload.**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.*Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.**If you need a reasonable accommodation to complete the online application process, please email* ***[e-mail]*** *for assistance. Please note that this email inbox is dedicated to accommodation requests only and cannot provide application updates or accept resumes.**The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State.**Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state and local ordinances.*