Job Description

Title EHR Source System Subject Matter Expert (SME)

Location Remote

Summary
We are seeking an experienced and highly knowledgeable EHR Source System Subject Matter Expert (SME) to join our team. The ideal candidate will possess deep, hands-on expertise with multiple Electronic Health Record (EHR) systems, including but not limited to Cerner, Epic, Athenahealth, and Allscripts. This role is critical for projects requiring detailed understanding of EHR data structures, data models, and the intricate relationships between various tables and modules to ensure accurate data extraction, integration, and analysis.

Key Responsibilities

• EHR Data Model Expertise: Act as the primary SME for the data models, schemas, and underlying table relationships of major EHR systems (Cerner, Epic, Athenahealth, Allscripts, etc.).
• Data Analysis & Mapping: Analyze, document, and interpret complex EHR data from source systems to support data warehousing, reporting, and integration projects. Define and validate data mapping specifications.
  Query Development: Develop and optimize complex SQL queries to extract specific clinical, financial, and operational data directly from EHR databases (e.g., Cerner Millennium/MPages, Epic Clarity/Caboodle, Allscripts Sunrise/TouchWorks).
• Technical Consultation: Provide expert consultation to development, analytics, and business intelligence teams regarding the correct interpretation and utilization of EHR source data.
• Relationship Understanding: Clearly articulate and document the relationships between key clinical, administrative, and financial tables within the EHR data model (e.g., patient demographics, encounters, orders, results, billing).

Required Qualifications

• Experience: Minimum of 8+ years of professional experience working directly with major EHR systems in a technical, data, or analytical capacity.
• EHR System Proficiency: Proven, in-depth technical experience with the data structures and modules of at least two of the following: Cerner, Epic, Athenahealth, Allscripts.
• Data Model Knowledge: Expert-level knowledge of how data is organized, stored, and related within the EHR system's core tables (e.g., Epic Clarity/Caboodle tables, Cerner Discern/CCL knowledge).
  Technical Skills: Advanced SQL proficiency for complex data extraction and analysis. Familiarity with database concepts and ETL processes.
• Communication: Excellent written and verbal communication skills, with the ability to translate complex technical data concepts into business-friendly language for non-technical stakeholders.

Education

• Bachelor's or Master's Degree in Information Technology or relevant field.

Job Tags

Similar Jobs