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