Senior Software Engineering Advisor - ETL & BI (Hybrid)

Cigna Healthcare; Denver (CO); Hybrid; USD 171,000 - 217,000; Full time

Benefits offered by this job

Health benefits including medical, eye

401(k) plan

Tuition reimbursement

Paid time off (minimum 18 days)

Life insurance

Job summary

The Cigna Group is seeking a Software Engineering Senior Advisor for the Denver, CO area to provide expert consultation across application programming and processes for diverse platforms and environments, including host-based and distributed systems. You will lead complex engineering projects, collaborate with IT leadership, document and test solutions, and deliver ongoing support.

Hybrid work is supported.

Qualifications

• Bachelor’s degree in Computer Science, Computer Engineering or related field.
• 5 years of experience as a Software Engineer, Technical Lead, or related occupation.
• Experience gathering functional requirements and designing & developing ETL solutions.
• Partnering with Architecture and Business to identify target solutions and integration patterns.
• Developing ETL mappings and SQL scripts; overseeing deployment across environments.
• Carrying out Proofs of Concepts for application development.
• Identifying business gaps and suggesting changes.
• Developing BI reports according to business needs.
• Minimum 5 years of healthcare industry experience, Provider Data management.
• Creating techno-functional requirement documents.
• Providing application maintenance support post Go Live.
• Resolving in-production issues.
• Designing dimensional models to support automated reports.
• Using SQL, HTML, Python, Informatica PowerCenter, SSIS, SSRS and Agile methodologies.

Responsibilities

• Provide leadership on complex engineering assignments and act as principal designer for major systems.
• Collaborate with client and IT management to identify application development solutions.
• Research and evaluate alternative solutions and recommend cost-effective options.
• Document, test, implement and provide ongoing support for applications.
• Serve as subject matter expert.
• Code new or modified programs as necessary.
• Work in a Hybrid Work Schedule.

Skills

ETL development

SQL

Python

Agile methodology

Healthcare industry experience

Education

Bachelor's degree in CS/CE or related field

Tools

Informatica PowerCenter

SSIS

SSRS

Job description

The Cigna Group is seeking a Software Engineering Senior Advisor for the Denver, CO area to provide expert consultation across application programming and processes for diverse platforms and environments, including host-based and distributed systems. You will lead complex engineering projects, collaborate with IT leadership, document and test solutions, and deliver ongoing support.

Hybrid work is supported.