AI Data Integration Engineer

Quantum Technologies LLC; San Jose (CA); On-site; USD 91,000 - 124,000; Full time

Job summary

Quantum Technologies. LLC in San Jose, CA seeks an AI Data Integration Engineer for a 12-month+ extension, focusing on turning legacy schemas into first-pass mappings and reconciling field names to prevent production data quality issues.

You will lead integration architecture, apply AI/LLM-based mapping, build ETL pipelines and APIs, model data, and ensure HIPAA security while collaborating with AI architects, product, and operations.

Qualifications

• Minimum of 5 years in data/integration or ETL engineering for production integrations with complex legacy systems.
• Healthcare/RCM experience preferred; exposure to Practice Management (PM) systems is a plus.
• Hands-on experience using AI/LLM APIs (OpenAI, Azure OpenAI) for schema inference, field-mapping, or data-quality checks.
• Proficient in SQL with production-grade data pipelines and relational databases.
• Experience designing REST and SOAP APIs for data movement.
• Familiarity with JSON, XML, CSV, flat-file, and EDI formats.
• Understanding of HIPAA and PHI security practices.
• Cloud integration platforms; Azure stack experience is a plus.

Responsibilities

• Lead architectural design of integration strategies connecting internal and external systems to our central platform.
• Apply AI-accelerated mapping and data quality techniques using AI/LLM tools.
• Model data and create source-to-target mapping specs from PM systems to the AI platform.
• Design ETL pipelines and REST/SOAP APIs to move data into Resolv Core per architectural guidance.
• Perform data wrangling to fit Resolv Core's target format and improve data quality.
• Address undocumented legacy systems and build playbooks or reference designs.
• Monitor, troubleshoot, and resolve production integration issues.
• Collaborate with the AI Architect, product, engineering, operations, and leadership.
• Document data models, mappings, and pipeline configurations.

Skills

AI/LLM APIs

SQL

REST APIs

Data modeling

HIPAA security

Cloud integration

Tools

Azure Data Factory

Azure Data Lake

SQL Server

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Job Title: AI Data Integration Engineer
Location: San Jose, CA
Duration: 12 Months + Extension
Bill Rate: $78/hour (C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Summary:
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.


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

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.