Description

You will design, build, and maintain ETL workflows for proprietary data formats, ensuring reliable inbound and outbound data feeds for claims, eligibility, and authorizations.

This role is on-site.

Responsibilities

• Design, test, and maintain scalable C# code and Microsoft SQL Server databases, including tables, views, and stored procedures.
• Build and support data import and export processes for claim, eligibility, accumulator, and authorization feeds.
• Analyze data exchanges with stakeholders to troubleshoot, record, and implement corrections for production errors.
• Develop technical design and architecture documents while providing effort estimates for programming tasks.
• Manage multiple FTP protocols and applications, building scheduling and error-handling solutions with a focus on security.

Required Skills

• 5+ years of experience in ETL development and data extraction, transformation, and loading tactics.
• Proficiency in C# for designing and maintaining scalable code.
• Strong experience with Microsoft SQL Server, including stored procedures, views, and table management.
• Hands-on experience with FTP protocols and secure file transfers.
• Ability to gather, analyze, and document business requirements.
• Proven ability to troubleshoot, analyze, and fix production data issues.

Preferred Skills

• Experience re-architecting legacy applications and identifying automation opportunities.

Key Skills

Education

Any Graduate