Data Engineer

ProArch; Kentucky; On-site; USD 85,000 - 110,000; Full time

Job summary

ProArch is seeking a data integration specialist to support the September ramp-up and October implementation of inbound and outbound data processes. The role involves ingesting, transforming, validating, and reconciling Medicaid claims and eligibility data in ProArch's standard environment.

You will work with Gainwell, Arcadia, DHCS data feeds and Atrezzo interfaces, establishing data quality and reconciliation controls, and supporting production stabilization.

Qualifications

• Experience with SQL, ETL and data integration processes.
• Knowledge of Medicaid claims and eligibility data.
• Experience with data quality and reconciliation controls.

Responsibilities

• Implement and stabilize data feeds for inbound/outbound processing.
• Ingest, transform, validate, and reconcile Medicaid data feeds.
• Support Gainwell, Arcadia, DHCS interfaces and Atrezzo extracts.
• Establish data-quality and reconciliation controls for PRISM, case creation, and reporting.
• Participate in data-exchange workstreams and daily implementation huddles.
• Plan for extension into production analytics if specs are not finalized.

Skills

SQL

ETL/Data Integration

Healthcare data

Data reconciliation

Data quality controls

Production support

Root-cause analysis

Stakeholder communication

Gainwell data

Arcadia data

DHCS data

Tools

Gainwell data

Arcadia data

DHCS data

Job description

• implementation and initial stabilization
• Support the September ramp-up and October implementation of inbound and outbound data processes.
• Ingest, transform, validate, and reconcile Gainwell, Arcadia, DHCS, and other approved data feeds within Acentra's standard claims and eligibility environment.
• Support Atrezzo-related interfaces or reportable extracts, as defined during implementation.
• Establish data-quality, refresh, completeness, and reconciliation controls for PRISM, case creation, and reporting.
• Participate in data-exchange workstreams and daily implementation huddles as needed.
• Plan for an extension through initial production analytics and data stabilization if file specifications, interface requirements, or source-of-truth decisions are not finalized by the end of implementation.

• SQL & ETL/Data Integration
• Healthcare/Medicaid claims & eligibility data
• Data ingestion, transformation & validation
• Data reconciliation & quality controls
• Experience with Gainwell, Arcadia & DHCS data
• PRISM & Atrezzo interfaces/extracts
• Data exchange/interface implementation
• Production support & stabilization
• Data quality, refresh & completeness monitoring
• Troubleshooting and root-cause analysis
• Strong stakeholder communication & implementation support