Find Jobs Near You – Available Work in Your Location
Healthcare
Clinical Data Systems Specialist
Teaneck, NJ
Find & Apply For Clinical Data Systems Specialist Jobs in Teaneck, New Jersey
Browse jobs from a variety of sources below, sorted with the most recently published, nearest to the top. Click the title to view more information and apply online.
Integration & Data Extraction Specialist Robert Half - 3.9 Teaneck, NJ Job Details $130,000 - $150,000 a year 5 days ago Benefits Disability insurance Dental insurance 401(k) Vision insurance Qualifications Index optimization Data integrity assurance X12 EDI Accounts receivable Performance tuning Systems integration Data Integration (Data management) Data analysis reporting EDI HL7 interface engines Software troubleshooting RESTful API Data validation techniques Meditech Xpath Business intelligence report generation System design Integration Architecture Design (Architecture design skills) Schema design 3 years Stored procedures
ICD-10 ETL
process automation Health information data integrity Integration Platforms (Enterprise solutions) CPT coding Data backup
JSON XSLT
System tuning Full Job 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. 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).
