Description The EHR Integration & Data Extraction Specialist serves as the primary technical expert responsible for designing, building, and maintaining data pipelines that connect legacy and modern electronic health record (EHR) platforms-specifically MEDITECH Magic, Client/Server (CS), and Expanse-to downstream analytics, reporting, and enterprise systems. This role requires deep knowledge of EHR native data structures, integration interfaces, and extraction methodologies to deliver accurate, timely, and compliant healthcare data in support of clinical, operational, and regulatory objectives.
Key Responsibilities:EHR Platform Integration
- Design and implement end-to-end integration solutions for MEDITECH Magic, CS, and Expanse platforms.
- Configure and manage HL7 v2.x interfaces (ADT, ORM, ORU, MDM, DFT) using native interface engines and third-party middleware (e.g., Mirth Connect, Rhapsody, or Microsoft BizTalk).
- Extract data directly from database applications, outputting as SQL backups while ensuring real-time synchronization to capture CRUD operations.
- Build integrations leveraging FHIR R4 APIs, REST web services, and modern integration platforms.
- Troubleshoot and resolve interface failures, data mismatches, and connectivity issues across system environments.
- Nice to have: Develop and maintain MEDITECH Magic BAR (Billing/Accounts Receivable), NPR (Non-Patient Reporting), and MAGIC-specific data extraction routines.
Data Extraction & Transformation
- Extract discrete data, reports, and documents from both proprietary file systems and relational database layers (MS SQL Server).
- Develop SQL queries, stored procedures, and ETL pipelines to pull structured data from enterprise healthcare data warehouses, including Data Repository (DR) and Expanse Data Repository (EDR).
- Transform raw data into MS SQL Server backups capable of handling continuous CRUD operations.
- Build and maintain data validation scripts and design routines to ensure dataset accuracy, completeness, and referential integrity.
- Map proprietary healthcare codes to standard terminologies (ICD-10, SNOMED CT, LOINC, CPT, RxNorm).
- Develop custom reports and extracts using built-in reporting tools (NPR, BAR Report Writer).
- Nice to have: Transform raw EHR data into standardized formats (HL7 FHIR, CDA, CSV, JSON, XML) for downstream consumption.
Requirements Experience
- 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 Expanse, including SQL-accessible Data Repositories.
- Demonstrated experience reading, writing, and debugging MUMPS (M language) within a legacy EHR environment.
- Proficiency navigating and extracting data from hierarchical folder and global file structures (including DPT, MIS, DR, and module-specific namespaces).
- Strong working knowledge of relational database concepts (normalization, indexing, joins, foreign keys, schema design) with hands-on MS SQL Server experience.
- Demonstrated experience developing and supporting HL7 v2.x interfaces in a healthcare setting.
- Proficiency in SQL Server T-SQL for complex querying, stored procedures, and performance tuning against healthcare 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 routines; understanding global variable storage, subscript navigation, and routine execution.
- Legacy File Structures: In-depth knowledge of proprietary hierarchical globals and folder architecture (DPT, BAR, LAB, PHA, MIS, DR namespaces); traversing non-relational global trees.
- Relational Databases: Microsoft SQL Server (T-SQL, stored procedures, views, indexing, query optimization); understanding relational schema design and cross-module relationships.
- EHR Platforms: MEDITECH Magic (NPR, BAR extracts, MAGIC file structures), MEDITECH CS/Expanse (EDR schemas, FHIR R4 APIs, Web Services).
- Interface Standards & Data Formats: HL7 v2.x, FHIR R4, CDA/C-CDA, X12 EDI; XML, JSON, CSV, pipe-delimited text, XPath/XSLT.
- Healthcare Terminologies: ICD-10-CM/PCS, CPT, SNOMED CT, LOINC, RxNorm, NPI.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.
Never miss an opportunity! Create an alert based on the job you applied for.