Meditech Integration&Data Extraction Speciali

workforcenow

Remote 5 Years Exp Posted 58m ago

Job Description

MEDITECH Platform Integration

  • Design and implement end-to-end integration solutions for both MEDITECH Magic and MEDITECH CS/Expanse platforms
  • Configure and manage HL7 v2.x interfaces (ADT, ORM, ORU, MDM, DFT) using MEDITECH's Interface Engine and third-party middleware such as Mirth Connect, Rhapsody, or Microsoft BizTalk
  • Capable to extract data directly from the Database Application, provide the data as SQL backup. Ensure real-time synchronization to capture CRUD operation. 
  • Nice to have – knowledge of an be able to Develop and maintain MEDITECH Magic BAR (Billing/Accounts Receivable), NPR (Non-Patient Reporting), and MAGIC-specific data extraction routines
  • Build integration leveraging MEDITECH CS FHIR R4 APIs, REST web services, and the Expanse Integration Platform
  • Troubleshoot and resolve interface failures, data mismatches, and connectivity issues across system environments

Data Extraction & Transformation

  • Extract clinical and administrative data from MEDITECH Magic's proprietary file system and MEDITECH CS's relational database layer (MS SQL Server)
  • Be able to extract data directly from the database Application, with ability to capture real-time synchronizations.
  • Be able to extract the Discrete data as well as the Report/documents. 
  • Develop SQL queries, stored procedures, and ETL pipelines to pull structured data from MEDITECH data warehouses including Data Repository (DR) and MEDITECH's Expanse Data Repository (EDR)
  • Transform raw Data into MS SQL Server backup, capable of handling the CRUD operations.
  • Nice to have – Be able to transform raw MEDITECH data into standardized formats (HL7 FHIR, CDA, CSV, JSON, XML) for consumption by downstream systems
  • Build and maintain validation script.
  • Build and maintain mappings between MEDITECH proprietary codes and standard terminologies (ICD-10, SNOMED CT, LOINC, CPT, RxNorm)
  • Design data quality validation routines to ensure accuracy, completeness, and referential integrity of extracted datasets
  • Develop custom reports and extracts using MEDITECH's built-in reporting tools (NPR, BAR Report Writer)

Qualifications:

  • 5+ years of hands-on experience with MEDITECH Magic (specifically NPR, BAR, LAB, PHA, and ADM modules)
  • 3+ years of experience with MEDITECH Client/Server (CS) or MEDITECH Expanse, including its SQL-accessible Data Repository
  • Demonstrated experience reading, writing, and debugging MUMPS (Massachusetts General Hospital Utility Multi-Programming System) / M language as used within the MEDITECH Magic environment
  • Proficiency navigating and extracting data from MEDITECH Magic’s proprietary hierarchical folder and global file structures, including DPT (patient), MIS, DR, and module-specific global namespaces
  • Strong working knowledge of relational database concepts including normalization, indexing, joins, foreign keys, and schema design, with hands-on experience in Microsoft SQL Server for MEDITECH CS data repository queries
  • Demonstrated experience developing and supporting HL7 v2.x interfaces in a healthcare environment
  • Proficiency in SQL Server T-SQL for complex querying, stored procedures, and performance tuning against MEDITECH CS/Expanse Data Repository schemas
    • Working experience with at least one ETL/integration tool (SSIS, Informatica, Mirth Connect, or equivalent)

Similar Openings for You