Data Extraction Specialist - HL7/MUMPS
First seen by Alion on Nov 4, 2026.
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).
Skills
Data Engineering, MUMPS, SQL Server, HL7, ETL, T-SQL, FHIR, SSIS, Informatica, XML