Job description

Job Profile Summary:
This role is responsible for overall enterprise client data exchange management.

This is a critical role as all of the data received by clients are loaded to the core business applications and are vital to the patient authorization and case build process

Required to be working on-call in the evening as and when needed

Job Description:
Manage SQL Server jobs and daily production loads to the data warehouse using the full scope of the ETL (Extract Transform Load) process, including client files, the ingestion engine, SSIS packages, process management, and SLA tracking.

Troubleshoot and resolve ETL process production issues, including bad data, file mapping, performance issues for SSIS packages and ETL processes, and review stored procedures and functions for issues.

Apply experience with production automation, process improvement, documentation, development, software development lifecycle (SDLC), source control, and versioning for data warehouse development.

Address and remedy production ETL failures, create root cause analysis, and adhere to data availability service level agreements (SLA).

Reduce frequently occurring SQL Server production issues. Automate manual work through automation process improvement and minimize manual intervention in production environment.

Monitor ETL finish time and address surges in data volume, poor source data quality, server outages to maintain SLA.

Create and modify SQL Server Integration Services (SSIS) packages that manage data loads from source systems to destinations for production environment.

Determine and remedy SQL Server blocking transactions within multiple parallel job runs to maintain business SLA and prevent job errors.

Manage permissions, audits, and user settings within data warehouse for maintaining Private Health Information (PHI) security.

Communicate effectively with internal and external customers related to data analysis of bad data and resolutions required.

Perform mappings for external data received to internal field requirements and determine transformation logic

Migrate legacy platform system processes to Azure environment in the cloud, design, performance, and process transfer.

Technical

5+ years of experience with Data Exchange/Load, Data Warehouse and TSQL development (scripting, stored procedures, triggers, query development)

Strong understanding of SQL Server Database technology

Experience with ETL, SSIS, SSRS, SSAS, OLAP, BCP

Knowledge and Experience with Best Practices and Standards for TSQL and SDLC

Development Tools/Applications (GitHub, TFS, Azure DevOps, RedGate Tools, Visual Studio, etc

FTP File Management (Zip/Unzip, Encrypt/Decrypt) – MoveIT, Data Tran, SI

Data Load Processing, Workflow Management and Process Automation

Non-Technical

Reporting Data Analysis/Reporting Skills (On Demand, Error, Trending, Summary, etc)

Agile Methodologies/SCRUM

Familiar with ANSI/EDI standards

Documentation Development

Excellent Interpersonal and Communications Skills

Critical Thinking/Problem Solving

Innovative/Out of Box Thinking

Ownership and Responsibility

Proactive

Ticket Management

Additional Skills

Microsoft Azure skills a plus

Healthcare/Medical/insurance data experience a plus

AS400 Knowledge a plus

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 77,300 - 128,800 USD / yearly, depending on relevant factors, including experience and geographic location.

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

We want you to be healthy, balanced, and feel secure. That’s why 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) with company match, company paid life insurance, tuition reimbursement, a minimum of 18 days of paid time off per year and paid holidays. For more details on our employee benefits programs, visit Life at Cigna Group .

About Evernorth Health Services
Evernorth Health Services, a division of The Cigna Group, creates pharmacy, care and benefit solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention and treatment of illness and disease more accessible to millions of people. 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 require reasonable accommodation in completing the online application process, please email: SeeYourself@cigna.com for support. Do not email SeeYourself@cigna.com for an update on your application or to provide your resume as you will not receive a response.

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.

colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.