ETL Developer Claims Mgmt

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

Job summary

A leading healthcare benefits platform is seeking an ETL Developer for a remote, long-term contract role. In this position, you will be crucial in architecting systems that handle healthcare data feeds, requiring strong skills in C# and SQL Server. You will collaborate across teams to optimize data processing and develop integration projects, making a significant impact on operational efficiency.

Qualifications

• 5–10+ years of experience in backend development and ETL processes.
• Strong command of C#, SQL Server, and SSIS.
• Experience developing ETL pipelines focused on Rx claims or PBM data sets.

Responsibilities

• Support daily ETL and EDI operations involving PBM and Rx claims feeds.
• Build and maintain proprietary import/export feeds for claims and eligibility.
• Analyze healthcare and pharmacy data exchanges to improve performance.

Skills

C#

SQL Server

SSIS

Troubleshooting

Documentation

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, the company is seeking an ETL Developer with hands-on experience working with PBM data and pharmacy claims feeds. This role is part of the EDI and ETL team that manages claim and eligibility data exchanges between TPAs, PBM vendors, and other healthcare data trading partners. The team is actively building and consolidating integrations as they transition to a modernized claims adjudication platform.

This is a remote, long-term contract role (12+ months) supporting the Central U.S. 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’ll work across technical and business teams to deliver clean, scalable code that supports proprietary feed formats (not X12), such as CSV or flat files.

• Support daily ETL and EDI operations involving PBM and Rx claims feeds.

• Partner with external PBM vendors and internal teams to gather, document, and validate feed requirements.

• Build and maintain proprietary import/export feeds for claims, eligibility, accumulators, and authorizations using C#, SQL Server, and SSIS.

• Analyze healthcare and pharmacy data exchanges to troubleshoot, correct, and optimize feed performance.

• Create robust tracking, scheduling, and error-handling mechanisms across FTP/SFTP-based pipelines.

• Collaborate in modernizing legacy systems as the organization migrates to a new claims adjudication platform.

• Develop technical documentation and provide scoping and effort estimates for integration projects

Background Profile

• 5–10+ years of experience in backend development and ETL processes.

• Strong command of C#, SQL Server, and SSIS.

• Experience developing, modifying, and deploying ETL pipelines with a focus on Rx claims or PBM data sets. (ex: 834 eligibility feeds and NCPDP D.0, etc.)

• Strong understanding of file formats and mapping (flat files, tab-delimited, CSV).

• Ability to work in cross-functional environments and communicate clearly with technical and business teams.

• Experience working with FTP/SFTP and secure data transfers.

• Strong troubleshooting, documentation, and version control practices.

Preferred Skills

• Previous experience with PBM vendors or adjudication systems.

• Familiarity with accumulator data, eligibility feeds, or Rx prior authorization records.