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 a back-end C# Software Engineer to join their EDI and ETL team. The work will focus on building custom healthcare claim data extracts in C# 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.

• Design, build, test, implement, and maintain efficient and reliable C# code that is clean and scalable. (Stand-alone C#, not scripting in SSIS).

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

• 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.

• 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# and SQL. Ability to modify existing and create new C# code for data feed extracts

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

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

• Prior experience in the healthcare industry, ideally working for a TPA. 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.

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

• Experience with the automation of legacy systems

Job Tags

Similar Jobs