Job Description

The EHR Integration & Data Extraction Specialist serves as the primary technical expert responsible for designing, building, and maintaining data pipelines that connect legacy and modern electronic health record (EHR) platforms—specifically MEDITECH Magic, Client/Server (CS), and Expanse—to downstream analytics, reporting, and enterprise systems. This role requires deep knowledge of EHR native data structures, integration interfaces, and extraction methodologies to deliver accurate, timely, and compliant healthcare data in support of clinical, operational, and regulatory objectives.Key to the Role:They need someone who connect directly to the Meditech MAGIC/CS backend and develop a script to extract entire DPM and all segments under DPM from magic and CS backend (Mumps). This person should be able to extract data without relying on Meditech Data Repository and NPR reports.Key Responsibilities:EHR Platform IntegrationDesign and implement end-to-end integration solutions for MEDITECH Magic, CS, and Expanse platforms.Configure and manage HL7 v2.x interfaces (ADT, ORM, ORU, MDM, DFT) using native interface engines and third-party middleware (e.g., Mirth Connect, Rhapsody, or Microsoft BizTalk).Extract data directly from database applications, outputting as SQL backups while ensuring real-time synchronization to capture CRUD operations.Build integrations leveraging FHIR R4 APIs, REST web services, and modern integration platforms.Troubleshoot and resolve interface failures, data mismatches, and connectivity issues across system environments.Nice to have: Develop and maintain MEDITECH Magic BAR (Billing/Accounts Receivable), NPR (Non-Patient Reporting), and MAGIC-specific data extraction routines.Data Extraction & TransformationExtract discrete data, reports, and documents from both proprietary file systems and relational database layers (MS SQL Server).Develop SQL queries, stored procedures, and ETL pipelines to pull structured data from enterprise healthcare data warehouses, including Data Repository (DR) and Expanse Data Repository (EDR).Transform raw data into MS SQL Server backups capable of handling continuous CRUD operations.Build and maintain data validation scripts and design routines to ensure dataset accuracy, completeness, and referential integrity.Map proprietary healthcare codes to standard terminologies (ICD-10, SNOMED CT, LOINC, CPT, RxNorm).Develop custom reports and extracts using built-in reporting tools (NPR, BAR Report Writer).Nice to have: Transform raw EHR data into standardized formats (HL7 FHIR, CDA, CSV, JSON, XML) for downstream consumption.

Job Tags

Similar Jobs