AI-Driven Data Integration Engineer (ETL & API Pipelines)

Robotic Technologies Automation; San Jose (CA); On-site; USD 89,000 - 126,000; Full time

Job summary

Robotic Technologies Automation in San Jose, CA, seeks an AI Data Integration Engineer to turn legacy schemas into mapping specs, reconcile field names, and catch data-quality issues before production. You will lead integration architecture across internal and external systems and build ETL pipelines and APIs with an AI-first approach.

The role requires 5+ years in data integration, SQL proficiency, and experience with AI/LLM tools for mapping and quality checks.

Qualifications

• At least 5 years in data/system integration or ETL engineering for production systems.
• Healthcare/RCM experience preferred; exposure to PM systems is a plus.
• Hands-on use of AI/LLM APIs for schema inference, field-mapping, or data-quality checks.
• Proficient in SQL and relational databases; able to design and optimize queries.
• Design, build, and maintain ETL processes, data pipelines, and APIs.

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 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 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.

Skills

Data integration architecture

AI-assisted mapping

ETL design

Data wrangling

HIPAA security awareness

Tools

OpenAI API

Azure OpenAI

SQL

REST APIs

SOAP APIs

JSON/XML/CSV/EDI

Azure Data Factory

Data Lake

Job description

Robotic Technologies Automation in San Jose, CA, seeks an AI Data Integration Engineer to turn legacy schemas into mapping specs, reconcile field names, and catch data-quality issues before production. You will lead integration architecture across internal and external systems and build ETL pipelines and APIs with an AI-first approach.

The role requires 5+ years in data integration, SQL proficiency, and experience with AI/LLM tools for mapping and quality checks.