> Markdown version of [/jobs/ext/537204-meditech-integration-data-extraction-speciali](https://www.wearedevelopers.com/jobs/ext/537204-meditech-integration-data-extraction-speciali). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Meditech Integration&Data Extraction Speciali - **Company:** ELLKAY, LLC. - **Location:** United States (Remote available) - **Experience:** Experienced - **Salary:** $130,000.0 - $150,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), ASC X12 Standards, Microsoft Biztalk Servers, Client Server Models, Computer Programming, Continuous Integration, Data Hub, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Mining, Data Security, Data Structures, Data Warehousing, Database Applications, Relational Databases, Software Debugging, File Systems, Middleware, JSON, Microsoft SQL Server, M Programming Language, Performance Tuning, Query Optimization, Rhapsody, S Interface, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Transact-SQL, Web Services, Extensible Markup Language (XML), XPath, Extensible Stylesheet Language Transformations (XSLT), Fast Healthcare Interoperability Resources, Electronic Medical Records, Indexer, Health Level Seven International, Tools for Reporting, Restful APIs, Meditech, Data Pipelines, Custom Reports, Crud - **Published:** June 13, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=eceaa0975fa5efb7 ## About the Role Do you have experience in T-SQL?, * 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) Technical Skills * MUMPS / M Language - Reading and writing MUMPS routines for MEDITECH Magic data access; understanding of global variable storage, subscript navigation, and routine execution within the Magic environment * MEDITECH Magic File Structures - In-depth knowledge of Magic's proprietary hierarchical globals and folder architecture (DPT, BAR, LAB, PHA, MIS, DR namespaces); ability to traverse, interpret, and extract data from non-relational global trees * Relational Databases - Microsoft SQL Server (T-SQL, stored procedures, views, indexing, query optimization); understanding of MEDITECH CS/Expanse relational schema design and cross-module table relationships * MEDITECH Magic - NPR programming, BAR extract routines, MAGIC file structures (DPT, MIS, DR) * MEDITECH CS/Expanse - Expanse Data Repository, FHIR R4 APIs, Web Services, EDR schema * Interface Standards - HL7 v2.x, FHIR R4, CDA/C-CDA, X12 EDI * Data Formats - XML, JSON, CSV, pipe-delimited; XPath/XSLT transformation * Healthcare Terminology - ICD-10-CM/PCS, CPT, SNOMED CT, LOINC, RxNorm, NPI ## Description 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. This role requires deep knowledge of MEDITECH's native data structures, integration interfaces, and extraction methodologies to deliver accurate, timely, and compliant healthcare data in support of clinical, operational, and regulatory objectives., * 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) ## Related Videos - [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure) - [Scrape, Train, Predict: The Lifecycle of Data for AI Applications](https://www.wearedevelopers.com/videos/1652-scrape-train-predict-the-lifecycle-of-data-for-ai-applications) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Rest API Antipatterns](https://www.wearedevelopers.com/videos/100208-rest-api-antipatterns) - [Are Classical Automation Frameworks Dead? How AI Agents Are Transforming QA](https://www.wearedevelopers.com/videos/100243-are-classical-automation-frameworks-dead-how-ai-agents-are-transforming-qa) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) ## Related Articles - [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j)