Hybrid Data Engineering Advisor - ETL & Analytics

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

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.