Software Engineering Senior Advisor- Hybrid

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.

• 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.
• Hybrid work schedule.

• 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 10

Mbps download/5

Mbps upload.

For this position, we anticipate…