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.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
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
ELLKAY offers a comprehensive and competitive benefit package that starts day one!
Including:
Medical, Dental, and Vision benefits
Employer-paid Life and LTD
401k w/ matching – once eligibility is met
Work/life balance
Paid Volunteer Program
Flexible working hours
Generous FTO
Remote work options
Employee Discounts
Parental Leave
Gym membership / Exercise class stipends
Our awesome culture includes:
Working with talented, collaborative, and friendly people who love what they do
Professional growth within
Innovation environment
On site in HQ Free daily lunches
Awards:
2025 Top Workplaces Employee Appreciation
2025 Top Workplaces Employee Well-Being
2025 Top Workplaces Professional Development
2025 Top Workplaces Leadership
2026 USA Today Top Workplaces
2026 NJ Top Workplaces
Additional information
At ELLKAY, we are committed to operating as a hybrid workplace, offering employees flexibility in how they structure their time between in-office and remote work. We recognize the significance of fostering connections, collaboration, and creativity within our office culture and its positive impact on our business. Our philosophy of operating as a hybrid workplace underscores our dedication to enabling employees to tailor work-life balance to their individual preferences. For those who do not live within 40 miles of one of our offices, we are open to considering remote work for candidates whose skills and experience strongly align with the role. While we prioritize a hybrid work environment for most roles, we understand the importance of flexibility and are open to remote work for specific positions and specialized skill sets.
For more information on our company, visit www.ELLKAY.com.
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.
About ELLKAY
Software & SaaS750 employeesFounded 2002
Private healthcare data management and interoperability company serving hospitals, laboratories, payers, health IT vendors, and practices.
