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.
The potential salary range for this role is $150,000.00 USD to $ 160,000.00 per year. Final compensation will be based on experience, skills, market conditions, and internal equity. We offer a competitive Total Rewards program including health benefits, RRSP matching, stock options, and career development opportunities.
Summary
Build and maintain data integrations and ETL pipelines connecting legacy Practice Management systems to an AI platform, using AI/LLM tools for schema mapping and data quality. Requires 5+ years of data/system integration or ETL experience, production-grade SQL, and familiarity with Python and JavaScript. Healthcare/RCM exposure preferred.
Responsibilities
Lead architectural design of integration strategies connecting internal and external systems to central platform; AI-accelerated schema mapping, field reconciliation, anomaly detection; build data models and source-to-target mapping specs from PM systems; design and build ETL processes and REST/SOAP APIs into Resolv Core; cleanse, structure, and enrich source data; monitor, troubleshoot, and resolve production integration issues; maintain data models, mapping specs, and pipeline configurations
Qualifications
Minimum 5 years in data/system integration or ETL engineering; healthcare/RCM experience preferred; direct exposure to Practice Management (PM) systems
Experience requirements
A minimum of 5 years in data/system integration or ETL engineering, building production integrations against complex legacy systems
Benefits
Health benefits, RRSP matching, stock options, career development opportunities