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