AI Data Integration Engineer, RCM Systems

MediSolution; Oklahoma; Hybrid; USD 90,000 - 130,000; Full time

Job summary

Harris is seeking a data integration engineer to design architectures connecting legacy systems to our central platform. The role emphasizes AI-driven mapping, ETL pipelines, and collaboration with AI Architects and product teams.

You will build source-to-target mappings, ensure data quality, and develop REST/SOAP APIs while handling healthcare data formats (HL7/FHIR). The role requires 5+ years in integration and strong SQL/Python/JavaScript skills.

Qualifications

• Minimum 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 Management (PM) systems.
• 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.

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.

Skills

SQL

Python

JavaScript

ETL

REST API

SOAP API

HL7/FHIR

HIPAA

AI/LLM

Tools

Azure Data Factory

Azure Data Lake

Data Factory

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.

At Harris, we believe great people build great software. We offer an environment where employees are empowered to make a real impact, grow their skills, and shape their careers. Our teams enjoy a supportive, award‑winning culture, a casual and collaborative workplace, and opportunities to learn from a diverse group of businesses and industries. We are financially strong and proudly part of Constellation Software Inc. (CSI), the largest software company in Canada, providing long‑term stability alongside entrepreneurial autonomy. In addition to a competitive compensation and benefits package, we offer meaningful perks, flexibility, and—most importantly—a culture that values people, curiosity, and having fun while doing great work.

Harris is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Applicants who require a reasonable accommodation due to a disability may contact us by email at [e-mail]. Accommodation requests may be made at any time. This email address is dedicated solely to accommodation requests and cannot be used to inquire about application status.

Know Your Rights Poster EO 13496: Notification of Employee Rights under Federal Labor Laws Our commitment to fair and equitable hiring.

As part of our recruitment process, we use artificial intelligence (AI) tools during the initial screening phase to help identify candidates whose qualifications most closely align with the requirements of the role. This technology supports efficiency and consistency in the early stages, but it never replaces human judgement. All subsequent evaluations and final hiring decisions are made by our recruitment professionals. AI does not make final hiring decisions.