About the Role :

The MEDITECH Integration & Data Extraction Specialist serves as the primary technical expert responsible for designing, building, and maintaining data pipelines that connect MEDITECH Magic and MEDITECH Client/Server (CS) electronic health record platforms to downstream analytics, reporting, and enterprise systems.

Essential Duties & Responsibilities :

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.

- Extract data directly from the Database Application and provide data as SQL backup.

- Ensure real-time synchronization to capture CRUD operations.

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

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).

- 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).

- Build and maintain validation scripts and mappings between MEDITECH proprietary codes and standard terminologies (ICD-10, SNOMED CT, LOINC, CPT, RxNorm).

Technical Skills :

- MUMPS / M Language - Reading and writing MUMPS routines for MEDITECH Magic data access.

- MEDITECH Magic File Structures - In-depth knowledge of Magic's proprietary hierarchical globals and folder architecture.

- Relational Databases - Microsoft SQL Server (T-SQL, stored procedures, views, indexing, query optimization).

- Interface Standards - HL7 v2.x, FHIR R4, CDA/C-CDA, X12 EDI.

- Data Formats - XML, JSON, CSV, pipe-delimited; XPath/XSLT transformation.

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 / M language.

- Proficiency in SQL Server T-SQL for complex querying and performance tuning.

- Working experience with at least one ETL/integration tool (SSIS, Informatica, Mirth Connect, or equivalent).