Senior Consultant - Epic Report Developer

Huron Consulting Services•Chicago, IL

About The Position

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. Huron’s Healthcare Transformation Services (HDTx) team works with healthcare organizations to solve their most complex EHR challenges, so we are constantly searching for skilled technical consultants to help our clients maximize their technology investments. Our Senior Consultants come with a wide variety of experience leveraging their technical expertise to help our clients enhance their EHR platform to improve care delivery, patient outcomes and profitability.

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.

Nice To Haves

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

Responsibilities

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.