Senior Consultant - Epic Report Developer

Huron helps its clients drive growth, enhance performance and sustain leadership in the markets they serve. We help healthcare organizations build innovation capabilities and accelerate key growth initiatives, enabling organizations to own the future, instead of being disrupted by it. Together, we empower clients to create sustainable growth, optimize internal processes and deliver better consumer outcomes.
Health systems, hospitals and medical clinics are under immense pressure to improve clinical outcomes and reduce the cost of providing patient care. Investing in new partnerships, clinical services and technology is not enough to create meaningful and substantive change. To succeed long-term, healthcare organizations must empower leaders, clinicians, employees, affiliates and communities to build cultures that foster innovation to achieve the best outcomes for patients.
Joining the Huron team means you’ll help our clients evolve and adapt to the rapidly changing healthcare environment and optimize existing business operations, improve clinical outcomes, create a more consumer-centric healthcare experience, and drive physician, patient and employee engagement across the enterprise.
Join our team as the expert you are now and create your future.

• Lead intake, scoping, and documentation of clinical research data requests, ensuring alignment with organizational goals.
• Convert clinical and research needs into technical specifications, including SQL queries and data model designs.
• Design, build, and maintain data assets such as relational databases, data marts, data lakes, and flat files (.csv) for research use.
• Write, test, and optimize SQL queries to extract and transform data; participate in code reviews and ensure data accuracy and integrity.
• Manage and execute data requests within defined scope and timelines, adhering to a one-business-day service level agreement (SLA).
• Identify and resolve data issues, validate new data sources, and ensure overall data reliability.
• Perform on-demand data analysis to support research and operational decision-making.
• Develop and maintain documentation, including technical specifications, job aids, and best practices.
• Research and evaluate new tools, technologies, and data sources to enhance research capabilities.
• Perform other duties as assigned.
   

Requirements:

• Bachelor’s degree in a health science (e.g., biostatistics, epidemiology) or technical field (e.g., computer science, engineering), or a related discipline.
• 5+ years of experience working with healthcare data in Epic Clarity or Caboodle EHR data warehouses.
• 5+ years of experience with standardized clinical coding systems (e.g., ICD-10, SNOMED CT, LOINC, RxNorm, UMLS) and common data models (e.g., OMOP).
• 5+ years of experience in healthcare reporting or biomedical research, including data profiling, data quality assessment, data analysis/reporting, and dataset curation.
• 5+ years advanced SQL programming expertise.
• Experience with data mapping, terminology management, and documentation.

Preferences:

• Master’s degree in a health science or technical field, or a related discipline.
• Epic certification in Caboodle, Clarity, and/or Clinical Data Models.

The estimated base hourly rate range for this job will vary based on multiple factors, including but not limited to specific skills or certifications, years of experience, market changes, and required travel. The job is also eligible to participate in Huron’s benefit plans, which include medical, dental and vision coverage, and other wellness programs. The rate range of information provided is in accordance with applicable state and local laws regarding salary transparency that are currently in effect and may be implemented in the future.