Software Engineering Senior Advisor- Hybrid

Software Engineering Senior Advisor

Cigna-Evernorth Services Inc. seeks a Software Engineering Senior Advisor for the Raleigh, NC location to design and build scalable data pipelines and ETL/ELT processes that can handle large amounts of both structured and unstructured data while ensuring security and reliability.

Responsibilities:

• Create and maintain data warehouse and data lake solutions using on-prem and cloud platforms like AWS.
• Design database structures and data models that perform well for analytical queries and reporting needs.
• Write clear technical documentation and specifications that explain how our data systems work.
• Research and recommend new data technologies and tools that can make our data infrastructure better and more efficient.
• Build, test, and deploy data pipelines using industry-standard tools such as Data Bricks, Airflow, Kafka, and similar technologies.
• Write and optimize SQL queries, stored procedures, and database components to extract and transform data efficiently.
• Create solutions that process data both in real-time and in batches.
• Set up automated checks to validate data quality and catch errors early in the pipeline.
• Connect and pull data from various sources including APIs, different databases, files, and streaming data platforms.
• Make data pipelines run faster and more cost-effectively through optimization.
• Build frameworks and monitoring systems to ensure our data is accurate and trustworthy.
• Create and enforce data governance policies that set standards for how we handle and manage data.
• Implement security measures like encryption and access controls to protect sensitive data and ensure compliance with regulations such as GDPR, CCPA, or HIPAA.
• Perform data audits to find and fix any data integrity problems.
• Maintain documentation including data dictionaries, lineage tracking (showing where data comes from and where it goes), and metadata systems.
• Guide and mentor junior data engineers and analysts, helping them grow their skills.
• Review code written by team members to ensure quality and adherence to best practices.
• Lead discussions about technical design decisions and review proposed architectures.
• Work closely with software engineers and business analysts to understand what they need and deliver effective solutions.
• Monitor data systems to ensure they're running smoothly and fix issues when they arise.
• Find and eliminate performance bottlenecks that slow down data processing or storage.
• Set up monitoring and alert systems so we know immediately when something goes wrong with our data pipelines.
• Investigate the root causes of data incidents and put safeguards in place to prevent them from happening again.
• Manage cloud resources efficiently to keep costs under control while maintaining performance.
• Work with business stakeholders to understand their data needs and translate those needs into technical solutions.
• Provide technical advice and consultation to product managers and business leaders.
• Explain complex technical concepts in simple terms that non-technical team members can understand.
• Create clear documentation for technical processes, procedures, and system configurations so others can understand and maintain them.
• Hybrid work schedule.

Qualifications:

• Bachelor's degree in Computer Science, Electrical Engineering or related field and 5 years of experience in any software development role.
• Will accept a Master's degree and 3 years of experience.
• Must have experience with: Hands-on experience in designing, building, and optimizing end-to-end applications using Python, Java, PL/SQL, APIs, and frameworks;
• Software Development Life Cycle; Clean code practices; Debugging; Unit testing;
• Delivering scalable software; Modern data ecosystems including Data Lakes, Lakehouse, ELT/ETL pipelines, streaming, and batch processing;
• Building scalable data ingestion, transformation, orchestration, and optimization using cloud-native services including AWS and Databricks;
• Tableau including building complex reports and hierarchical computations reports; Performance optimization; Report optimization; Writing a data pipeline using PySpark;
• Informatica PowerCenter components including source/target mapping, transformation, workflows, and performance tuning; end-to-end ETL development including debugging, optimization, and data integration best practices;
• Building scalable data pipelines using Spark, Delta Lake, and Notebooks; Optimizing Spark jobs, managing clusters, and developing end-to-end ELT solutions on the Databricks Lakehouse platform;
• End-to-end QA, including test strategy, test cases, automation, functional/regression testing, and defect management;
• Modern automation frameworks; CI/CD Integration; Oracle(SQL) including complex query writing, performance tuning, indexing strategies, and optimizing large-scale relational databases;
• AWS Engineering including API Gateway, Lambda, EC2, S3, IAM, and CloudWatch;
• Cloud architecture fundamentals; Data-focused services, including Glue and Athena; and, building scalable, secure cloud-native solutions.

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.

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 without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.

If you need a reasonable accommodation to complete the online application process, please email View email address on click.appcast.io for assistance. Please note that this email inbox is dedicated to accommodation requests only and cannot provide application updates or accept resumes.

The Cigna Group has a tobacco-free policy and reserves the right not to hire tobacco/nicotine users in states where that is legally permissible. Candidates in such states who use tobacco/nicotine will not be considered for employment unless they enter a qualifying smoking cessation program prior to the start of their employment. These states include: Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Ohio, Pennsylvania, Texas, Utah, Vermont, and Washington State.

Qualified applicants with criminal histories will be considered for employment in a manner consistent with all federal, state and local ordinances.