Meditech Integration&Data Extraction Speciali

Ellkay, Llc; Massachusetts; Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Smoke-Free Workplace

Equal employment opportunities

Job summary

ELLKAY LLC is seeking a MEDITECH Platform Integration Engineer to design and implement end-to-end data integration between MEDITECH Magic/CS and enterprise systems. The role focuses on HL7 interfaces, data extraction from MR/DR repositories, and real-time synchronization.

The ideal candidate will have extensive MUMPS/M language experience, deep knowledge of MEDITECH NPR/BAR modules, and proficiency with ETL tools and SQL Server.

Qualifications

• 5+ years of hands-on experience with MEDITECH Magic (NPR, BAR, LAB, PHA, ADM)
• 3+ years with MEDITECH Client/Server or Expanse including Data Repository
• Experience reading/writing MUMPS in MEDITECH Magic
• Proficiency extracting data from MEDITECH file systems and relational databases
• Experience developing HL7 v2.x interfaces and SQL Server queries
• Experience with ETL/integration tools (SSIS, Mirth Connect, Informatica)

Responsibilities

• Design and implement end-to-end MEDITECH integration solutions (MEDITECH Magic and CS/Expanse)
• Configure/manage HL7 v2.x interfaces using MEDITECH Interface Engine and middleware
• Extract data from MEDITECH databases and ensure real-time synchronization
• Develop and maintain MEDITECH data extraction routines (NPR, BAR)
• Build integrations leveraging MEDITECH FHIR APIs and REST web services
• Troubleshoot interface failures, data mismatches, and connectivity issues

Skills

MUMPS / M Language

Meditech Magic NPR/BAR

HL7 v2.x interfaces

SQL Server / T-SQL

ETL tools (SSIS, Mirth Connect, Inform

Data extraction & transformation

Tools

Mirth Connect

Rhapsody

Microsoft BizTalk

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full Time IN

ELLKAY started out providing connectivity solutions to laboratories and within a few years, grew to also provide data management solutions to ambulatory organizations. ELLKAY is now a trusted data management partner in five healthcare segments. ELLKAY’s solutions continue to serve laboratories and ambulatory practices and have expanded to empower hospitals and health systems, healthcare IT vendors, ambulatory practices, health plans, and other healthcare organizations with cutting-edge technologies and solutions that drive their growth and interoperability strategies. Today, ELLKAY remains true to our core values, building strong partner relationships and offering unparalleled service and support while providing innovative, scalable solutions to the challenges our customers face in today’s data-rich world. ELLKAY's experience, customer-focused approach, and reputation for innovation, speed, and accuracy differentiate ELLKAY as a premier partner for your interoperability needs and data management strategy.

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)

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)
• Interface Standards- HL7 v2.x, FHIR R4, CDA/C-CDA, X12 EDI
• Healthcare Terminology- ICD-10-CM/PCS, CPT, SNOMED CT, LOINC, RxNorm, NPI

Additional information

ELLKAY LLC is a Smoke-Free Workplace.

ELLKAY, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.