Full Job Description
Senior EHR Data Integration Consultant with deep experience working in a healthcare institution and strong expertise in SQL level report writing to extract EHR data—with a preference for Epic. This role supports multiple external clients in designing, validating, and optimizing EHR data extracts. You will operate with a high degree of independence, lead complex client engagements, and provide strategic guidance while still remaining hands on with data and technical development.
KEY RESPONSIBILITIES
Client Leadership & Strategic Guidance
• Serve as the primary consultant for multiple clients, providing expert‑level guidance on EHR data structures, reporting capabilities, and best practices.
• Lead requirements‑gathering sessions and translate complex clinical and departmental workflows into actionable technical specifications.
• Build and maintain strong client relationships, ensuring satisfaction, transparency, and long‑term partnership.
Advanced Data Extraction & Technical Development
• Design, build, and optimize sophisticated EHR data extracts, with emphasis on Epic Clarity/Caboodle or Cerner CCL/HealtheIntent.
• Develop and refine SQL queries, data models, and extract logic to support analytics, reporting, and operational use cases.
• Troubleshoot complex data issues and collaborate with internal engineering teams to enhance data pipelines and performance.
Data Validation & Quality Assurance
• Lead validation efforts to ensure accuracy, completeness, and consistency of extracted EHR data.
• Conduct advanced root‑cause analysis on data discrepancies and guide clients through remediation strategies.
• Establish and maintain validation frameworks, documentation, and repeatable processes for long‑term data quality.
Cross‑Functional Collaboration & Mentorship
• Collaborate with clinical, operational, and technical stakeholders across client organizations.
• Mentor junior consultants, contribute to internal best practices, and support continuous improvement across the consulting team.
Qualifications
• 5 years experience working in an informatics related role within a healthcare institution (hospital, health system, etc).
• Deep understanding of radiology and procedural workflows
• Epic experience strongly preferred — Clarity, Caboodle, Chronicles, Reporting Workbench, or Cogito tools. Cerner experience (CCL, Discern, HealtheIntent) also considered.
• Advanced SQL skills and strong understanding of relational database architecture and data modeling.
• Experience with EHR software, data management systems, and clinical information databases.
• Familiarity with healthcare data standards (HL7, FHIR, ICD‑10, CPT, LOINC) is a plus.
• Proven ability to manage multiple client engagements simultaneously with minimal oversight.
• Excellent communication skills, with the ability to engage both technical and non‑technical audiences.
• Strong analytical mindset, attention to detail, and commitment to data accuracy.
• Prior consulting experience or experience leading cross‑functional projects is highly valued.
• Bachelor’s degree in data Analytics, Business Intelligence, Health Informatics, or related field.
• Remote with travel between 20% and 40% on average
The base pay range for this position is:
$123,460 - $169,752
Factors which may affect starting pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate.
If this is a commission eligible position the commission eligibility will be in accordance with the terms of the Company's plan. Commissions are based on individual performance and/or company performance.
The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan. life insurance, long-term and short-term disability insurance, paid parking/public transportation, paid time off, paid sick and safe time.
