Software Engineering Senior Advisor- Hybrid

About The Cigna Group

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.
• At The Cigna Group, you’ll enjoy a comprehensive range of benefits, with a focus on supporting your whole health. 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, click here.

Preferred Qualifications

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

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.