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