AI Data Integration Engineer, RCM Systems

New Ultimate Billing, LLC; Oklahoma City (OK); On-site; USD 90,000 - 120,000; Full time

Job summary

New Ultimate Billing, LLC is seeking a data/integration engineer to translate legacy schemas into first-pass mapping specs, reconcile field names across systems, and catch data-quality issues before they reach production.

You will design integration strategies, implement ETL pipelines and REST/SOAP APIs to move data into Resolv Core, perform data wrangling, and collaborate with the AI Architect, product, and engineering to deliver reliable, compliant solutions.

Qualifications

• Experience with 5+ years in data/system integration or ETL engineering for complex legacy systems.
• Healthcare/RCM experience preferred; exposure to Practice Management systems.
• Hands-on AI/LLM API use for schema inference, mapping, and data-quality checks.
• Ability to judge the best AI tooling approach.
• Proficiency with SQL and relational databases.
• Familiarity with Python and JavaScript or similar scripting languages.
• Design, build, and maintain ETL processes, data pipelines, and APIs.
• REST and SOAP API development.
• Comfortable with JSON, XML, CSV, flat-files, and EDI formats.
• Data modeling and mapping-spec authorship.
• Understanding of HIPAA and PHI security practices.
• Cloud integration platforms; Azure stack is a plus.
• HL7/FHIR knowledge.

Responsibilities

• Lead the architectural design of integration strategies connecting systems to our central platform.
• AI-accelerated mapping and data quality using AI/LLM tools for schema mapping and anomaly detection.
• Data modeling and mapping from PM systems to our AI platform.
• Design and build ETL processes and REST/SOAP APIs moving data into Resolv Core.
• Data wrangling: cleanse, structure, and enrich source data for the target format.
• Pave the path where no playbook exists for poorly documented legacy systems.
• Reliability: monitor, troubleshoot, and resolve production integration issues.
• Collaborate with AI Architect, product, engineering, operations, and leadership.
• Documentation: maintain data models, mapping specs, and pipeline configurations.

Skills

AI/LLM APIs

AI tooling judgment

SQL

Python

JavaScript

ETL pipelines

REST APIs

SOAP APIs

JSON/XML/CSV/EDI

Data modeling

HIPAA/PHI security

Azure stack

HL7/FHIR

Tools

Azure Data Factory

Azure Data Lake

Azure SQL Database

Job description

You'll use it to turn raw legacy schemas and documentation into first-pass mapping specs, reconcile inconsistent field names and codes across systems, and catch data-quality problems that manual review would miss before they hit production.

Key Responsibilities

• Lead the architectural design of integration strategies and solutions that connect various internal and external systems to our central platform.

• AI-accelerated mapping & data quality: use AI/LLM tools to speed up schema mapping, field reconciliation, and anomaly detection.

• Data modeling & mapping: build data models and source-to-target mapping specs from Practice Management (PM) systems to our AI platform.

• Pipelines: design and build ETL processes and REST/SOAP APIs that move data into Resolv Core, per the architect's design.

• Data wrangling: cleanse, structure, and enrich source data into Resolv Core's target format.

• Pave the path where there's no existing playbook; several of these legacy systems are poorly documented.

• Reliability: monitor, troubleshoot, and resolve integration issues in production.

• Collaboration: work closely with our AI Architect, product, engineering, operations, and leadership.

• Documentation: maintain data models, mapping specs, and pipeline configurations.

Qualifications

Experience: A minimum of 5 years in data/system integration or ETL engineering, building production integrations against complex legacy systems.

Healthcare/RCM experience preferred; direct exposure to one or more Practice Managenent (PM) systems.

Technical (AI first):

• Hands-on experience using AI/LLM APIs (e.g., OpenAI, Azure OpenAI) for schema inference, field-mapping/entity resolution, or automated data-quality checks — with concrete examples.

• Judgment on the best approach to using AI tooling.

• Production-grade proficiency with SQL and experience with relational databases.

• Familiarity with Python and JavaScript (or similar scripting language).

• Design, build, and maintain ETL processes, data pipelines, and APIs to facilitate the seamless flow of data between different applications and data sources.

• REST and SOAP API development.

• Comfortable with JSON, XML, CSV, flat-file, and EDI formats.

• Data modeling and mapping-spec authorship.

• Understanding of HIPAA and PHI security practices.

• Cloud integration platforms; Azure stack (Fabric, Data Lake, SQL, Data Factory) a plus.

• HL7/FHIR knowledge.