Software Engineering Senior Advisors- Hybrid

The Cigna Group • Bloomfield, CT

17d • Hybrid

About The Position

The job profile for this position is Software Engineering Senior Advisor, which is a Band 4 Contributor Career Track Role with Cigna-Evernorth Services Inc.

Requirements

• Requires a Bachelor’s degree in Computer Science, Information Systems, or a closely related field and 5 years of IT experience. (or Master’s degree in Computer Science, Information Systems, or a closely related field and 3 years of IT experience).
• Must have experience with: Implementing CI/CD pipelines to test and deploy data architectures, codes, and artifacts from development to production in an automated fashion; Create mappings, sessions, workflows to integrate data from multiple source systems into data marts & data warehouses; Teradata; Oracle; Designing and developing ETL solutions using SQL/SSIS; Implementing the audit and exception handling process for ETL jobs; Using Kafka for real-time data extraction and transfer; Customizing highly complex OBIA and OOTB informatica mappings; Delivering data products using Data Warehousing databases; Developing big data processing data pipelines to populate large scale data lakes; PYTHON and UNIX shell scripting to support ETL and data pipeline; Cloud platforms like AWS (Amazon Web Services) to develop and deliver data pipelines; Creating business intelligence reports for KPIs, business metrics, and operation with looker; and Developing SQL scripts based on data conversion business mapping.
• 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.

Responsibilities

• Take ownership of data deidentification tool (e.g. Delphix) customers' requests on different database/lake platforms (e.g. Teradata/databricks/snowflake/AWs s3).
• Collaborate with vendors to resolve issues and implement upgrades.
• Manage BI tool reports specific to the data warehouse/lake platforms, working closely with customers to ensure accurate data representation.
• Support CI/CD pipeline automation, ensuring smooth integration with the data deidentification tool and other warehouse database platform.
• Provide end-user support for the warehouse platform on the cloud, assisting application teams by testing and providing masked data.
• Work with database teams and ensure proper functioning of data operations across systems.
• Lead offshore team efforts to streamline processes, assigning tasks and improve system performance, and implement best practices for data security.
• Hybrid work schedule.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level