EDI ETL Developer

Spinnaker Search; Wayne (PA); Remote; USD 90,000 - 130,000; Full time

Job summary

A leading healthcare benefits platform is seeking an ETL Developer to join their EDI and ETL team, focusing on healthcare claim data extracts with innovative data solutions. This contract role emphasizes back-end software engineering skills, particularly in C#, SQL, and ETL processes, requiring 5-10+ years of relevant experience and a knowledge of healthcare data.

Qualifications

• 5 - 10+ years of experience in back-end software engineering, working with databases and ETL processes.
• Proficient in C#, SQL, and SSIS. Ability to modify existing C# code.
• Strong understanding of file mapping, data architecture, and ETL design principles.

Responsibilities

• Support day-to-day ETL operations and deliver best-in-class services.
• Build and support proprietary import/export data feeds for claims, eligibility, authorizations.
• Design, build, test, implement and maintain efficient and reliable C# code.

Skills

C#

SQL

SSIS

analytical skills

attention to detail

Job description

Our firm has been engaged by a nationally recognized healthcare benefits platform that specializes in delivering data-driven services and custom benefit solutions. They partner with a wide network of payers, employers, and healthcare providers to ensure quality outcomes and improved operational efficiency. The company has built a reputation for innovation, data integration, and client satisfaction, earning accolades in various industry publications and regional tech awards for operational excellence and digital transformation in healthcare services.

Currently, they are looking to bring on an ETL Developer to join their EDI and ETL team. The work will focus on supporting and facilitating healthcare claim data extracts between Third Party Administrators (TPAs) and all data-trading partners. This involves adding new groups to existing feeds or building new file feeds to new vendors, using technologies like C#, SSIS, and SQL Server. The ETL Developers work with proprietary EDI formats, not standard X12 formats, and will primarily deal with CSV, tab-delimited, or flat files. This position is open because the company is implementing a new Claims Adjudication platform, which will require consolidation (and sunsetting) of the legacy platforms currently in use today.

This will initially be a long-term (12 months+) contract position (strong possibility of extensions) that is able to be based remotely anywhere in the US, but will be supporting the US Central time zone.

The Role You’ll Play

As an ETL Developer, you’ll play a pivotal role in architecting and maintaining the systems responsible for processing proprietary healthcare data formats. You will partner with internal teams and external stakeholders to design, develop, and support import/export processes critical to operations.

• Support day-to-day ETL operations with a hands-on approach and passion for delivering best-in-class services to internal and external stakeholders.

• Work with internal and external clients to gather, analyze and document EDI requirements.

• Build and support proprietary import/export data feeds for claims, eligibility, authorizations, and accumulators.

• Analyze the data exchanged with stakeholders in order to troubleshoot, record and address errors and implement corrections.

• Design, build, test, implement and maintain efficient and reliable C# code that is clean and scalable.

• Create and maintain Microsoft SQL databases, tables, views, stored procedures, etc.

• Work with multiple FTP protocols and applications, maintaining security

• Work on creating feature-rich scheduling, tracking, and error-handling solutions

• Support production including analysis, troubleshooting, and bug-fixing of problems

• Develop creative solutions and write technical design & architecture documents and provide estimates of effort fo programming and implementation

• Identify risk and failure points with a constant focus on process improvement and automation.

• Re-architect legacy applications as needed.

Background Profile

• 5 - 10+ years of experience in back-end software engineering, working with databases and ETL processes.

• Proficient in C#, SQL, and SSIS. The ability to modify existing C# code and potentially copy and adapt code for new extracts is important

• Strong understanding of file mapping, data architecture, and ETL design principles.

• Understanding of electronic data interchange (EDI) and experience with SFTP servers is beneficial

• Knowledge of healthcare data is crucial, as there's limited time to teach both healthcare concepts and company systems

• Ability to work independently and collaboratively with cross-functional teams.

• Excellent verbal and written communication skills.

• Strong analytical skills and attention to detail.

Preferred Skills

• Prior experience in the healthcare industry.

• Familiarity with eligibility, claims, and accumulator data exchanges.

• Experience with the automation of legacy systems.