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