Software Engineering Senior Advisor- Hybrid

Cigna; Bloomfield (CT); Hybrid; USD 164,000 - 217,000; Full time

Benefits offered by this job

Health benefits

401(k)

Tuition reimbursement

Paid time off

Holidays

Leaves of absence

Job summary

The Cigna Group seeks a Software Engineering Senior Advisor for the Bloomfield, CT area. Responsible for delivering software from requirements to production deployment, with a strong emphasis on data engineering, ETL pipelines, and analytics in a healthcare context.

Hybrid work arrangement available. The role requires collaboration across engineering, product, and business teams, implementing scalable and secure data solutions on AWS, with emphasis on performance and reliability.

Qualifications

• Bachelor's degree in CS/Engineering or related field with 5 years in healthcare software
• Experience with data engineering and data warehousing including scalable solutions
• Proficient in SQL, Python and Spark for data transformation and analytics
• Experience with cloud data platforms (AWS) and data architectures
• Familiar with CI/CD practices (GitHub, Jenkins) and automation tools
• Healthcare domain knowledge including membership claims and clinical data concepts
• Collaborates across engineering, product, and business teams to meet deadlines and quality expectations

Responsibilities

• Drive adoption of CI/CD tools and improve toolsets and processes
• Create strategies and architectures to resolve issues
• Develop data pipelines and ETL, optimize for security, fault tolerance and scalability
• Build data warehousing solutions and enable ad-hoc analytics
• Design end-to-end deployment automation using CI/CD and Terraform modules
• Maintain and optimize SQL databases and run efficient queries

Skills

Data engineering

Data warehousing

SQL

Python

Spark

CI/CD practices

Data security

Education

Bachelor's degree in CS/Engineering or related field

Tools

AWS

S3

Glue

Lambda

SNS

CloudWatch

Databricks

Teradata Vantage

Informatica

Terraform

Airflow

GitHub

Jenkins

Job description

Cigna-Evernorth Services Inc. seeks a Software Engineering Senior Advisor for the Bloomfield, CT location responsible for the delivery of software beginning from understanding the requirements to deploying the software into production.

Responsibilities

• Drive the adoption of CI/CD tools and support the improvement of the tools sets and processes.
• Create and deliver efficient and effective strategies and solution architectures to resolve issues.
• Work on all aspects of the system, including data digestion and utilizing big data methodologies to solve business problems through application development while focusing on security, fault tolerance, and scalability.
• Articulate clear business objectives aligned to technical specifications and work in an iterative, Agile pattern.
• Write referenceable and modular code. Design and architect solutions and understand automation best practices.
• Simplify processes whenever possible and ensure code quality by regularly monitoring data to identify and resolve problems before they impact business.
• Implement data pipelines, configure data, define table and column mapping, and create buckets in AWS environment to store files.
• Configure buckets with various life cycle policies to archive the infrequently accessed data to storage classes based on requirements.
• Build data warehousing solutions that facilitate ad-hoc querying and analytics on large volumes of structured and semi-structured data.
• Design and optimize queries for complex data transformations and aggregations to support business intelligence and reporting requirements.
• Implement deployment automation using CICD tools. Design and implement robust, scalable, and high-performing end-to-end ETL pipelines.
• Implement performance tuning techniques, partitioning strategies, and caching mechanisms to enhance performance and efficiency of data processing workflows.
• Build event-driven architecture to handle asynchronous data processing tasks, resulting in more resilient and scalable data workflows.
• Maintain SQL databases, creating tables, views, and stored procedures, and optimizing SQL queries to improve performance.
• Manage scalable and reusable Terraform modules for consistent and efficient resource provisioning across multiple environments.

Qualifications

• Bachelor's degree in Computer Science, Computer Engineering or related field and 5 years of experience in any software development role in the healthcare domain.
• Must have experience with: Data engineering and data warehousing including designing, building, and supporting scalable data solutions;
• Relational and analytical databases; Teradata Vantage; Databricks for scalable data engineering and for analytic workloads;
• Cloud-based data platforms; AWS including S3, Glue, Lambda, SNS, and Cloudwatch; Cloud-native data architectures;
• SQL, Python, and Spark to support data transformation, automation, and analytics;
• Apache airflow for workflow orchestration dependency management, and scheduling;
• Informatica for enterprise-grade data integration; Informatica for ETL processes; IaaS(Terraform) for data and application deployments, using industry standard automation tools;
• CI/CD practices for data and application deployments, using industry standard automation tools; Github; Jenkins;
• Healthcare domain including membership claims, and clinical data concepts; and,
• Collaborating across engineering, product, and business teams to meet deadlines and quality expectations.

Salary Range: $163,821-$173,600/year

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.

For this position, we anticipate offering an annual salary of 130,200 - 217,000 USD / yearly, depending on relevant factors, including experience and geographic location.

This role is also anticipated to be eligible to participate in an annual bonus plan.

Benefits

• Starting on day one of your employment, you'll be offered several health-related benefits including medical, vision, dental, and well-being and behavioral health programs.
• We also offer 401(k), company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year, paid holidays, and leaves of absence.
• For more details on our employee benefits programs, .

Hybrid work schedule.

About The Cigna Group

Doing something meaningful starts with a simple decision, a commitment to changing lives. At The Cigna Group, we're dedicated to improving the health and vitality of those we serve. Through our divisions Cigna Healthcare and Evernorth Health Services, we are committed to enhancing the lives of our clients, customers and patients. Join us in driving growth and improving lives.

Qualified applicants will be considered