Note: The job is a remote job and is open to candidates in USA. The hiring client is confidential. The Data Engineer supports development, production support, and quality reporting in a healthcare payer environment, including data processing, validation, reconciliation, reporting, and downstream analytics.

Responsibilities

• Handle flat files, physical and logical files, CSV files, and other data exchange formats and loaded into database
• Write complex SQL queries, joins, subqueries, aggregations, and common table expressions where supported
• Collaborate with business, quality, application, and reporting teams to ensure accurate, consistent, and auditable healthcare data outputs
• Work with RPG/RPGLE, CL/CLLE, DB2 for i and SQL
• Develop, enhance and maintain applications on IBM i / AS400
• Analyze existing programs, batch jobs, interfaces and reporting processes
• Develop and modify programs supporting healthcare quality data processing
• Troubleshoot application, data and production issues
• Perform impact analysis for application and reporting changes
• Optimize SQL queries, database access and batch processing
• Support scheduled jobs, file processing and downstream interfaces

Skills

• Strong IBM i / AS400 development experience
• RPGLE / RPG IV
• CL / CLLE
• DB2 for i
• Strong SQL
• Batch processing and job scheduling
• File processing and data interfaces
• Production support and troubleshooting
• Data validation and reconciliation
• Strong analytical and problem-solving skills
• 5+ years of AS400 / IBM i development experience
• Ability to work independently with business, quality, data and application teams
• Prior experience within a US healthcare payer environment
• US healthcare payer experience
• Healthcare claims and member data experience
• HEDIS / Quality Reporting
• Understanding of healthcare quality measures
• Experience working with large healthcare datasets
• Hands-on healthcare quality/HEDIS experience

Benefits

• Remote role

Company Overview

Company H1B Sponsorship