Data Engineer - AS400

Metasys Technologies/NVISH•Louisville, KY

3d•Remote

About The Position

The Data Engineer will support healthcare payer quality-reporting applications and data processes, including those used for quality measure calculation, data validation, reporting, reconciliation, and downstream analytics. The role focuses on IBM i/AS400 development, production support, and quality reporting. The resource will work with business, quality, application, and reporting teams to help ensure healthcare data outputs are accurate, consistent, and auditable. The role is remote and has a stated duration of 6+ months.

Requirements

At least 5 years of AS400/IBM i development experience.
Strong IBM i/AS400 development experience.
Experience with RPGLE/RPG IV, CL/CLLE, and DB2 for i.
Strong SQL skills.
Experience with batch processing and job scheduling.
Experience with file processing and data interfaces.
Production support and troubleshooting experience.
Strong analytical and problem-solving skills.
Ability to work independently with business, quality, data, and application teams.

Nice To Haves

Prior experience in a US healthcare payer environment.
Experience with healthcare claims and member data.
Experience with HEDIS or quality reporting.
Understanding of healthcare quality measures.
Experience working with large healthcare datasets.
Hands-on healthcare quality/HEDIS experience.

Responsibilities

Handle flat files, physical and logical files, CSV files, and other data exchange formats, and load data into databases.
Write complex SQL queries, including 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.
Develop, enhance, and maintain applications on IBM i/AS400 using RPG/RPGLE, CL/CLLE, DB2 for i, and SQL.
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.
Perform data validation and reconciliation.