Clinical Pharmacy Consultant / Informaticist

American Unit, Inc; Iowa; On-site; USD 130,000 - 180,000; Full time

Job summary

American Unit, Inc. seeks an experienced Clinical Pharmacy Consultant / Informaticist with an active pharmacist license to bridge clinical operations and data engineering.

The role emphasizes pharmacy analytics, Epic Willow/Beacon/Cadence, data governance, and developing AI/ML-ready data models for ROI, safety, and compliance.

Collaborate with data scientists to build feature stores, ensure data lineage, and implement automated validation that aligns with G/L and cash cycle processes.

Qualifications

• Active, unrestricted pharmacist license.
• 8+ years clinical pharmacy experience in hospital, infusion center, or consulting.
• 5+ years healthcare informatics, especially EHR analytics.

Responsibilities

• Lead clinical discovery workshops mapping pharmacy workflows and KPIs.
• Develop use-case specs covering outcomes, performance and financial impact.
• Trace data lineage across multi-vendor systems and ensure data integrity.
• Collaborate with data scientists to build feature stores for ML use cases.

Skills

Clinical pharmacy

Healthcare informatics

Data analysis

SQL

Documentation

Cross-functional collaboration

Communication

Education

PharmD

BS in Pharmacy (RPh)

Tools

Epic Willow

Epic Beacon

Epic Cadence

Clarity

Caboodle

Databricks Unity Catalog

Databricks Delta Lake

DoseEdge

Omnicell

BD Pyxis

Job description

We are seeking an experienced Clinical Pharmacy Consultant / Informaticist with an active pharmacist license, strong clinical pharmacy expertise, and healthcare informatics experience. The ideal candidate will bridge clinical pharmacy operations and data engineering, translating complex workflows into analytics requirements, data validation frameworks, audit logic, and AI/ML-ready data models.

This role focuses on pharmacy analytics, Epic systems, medication data standardization, revenue optimization, controlled substance diversion surveillance, and enterprise healthcare data governance.

• Lead clinical discovery workshops to map pharmacy workflows, define clinical logic, and establish key performance indicators.
• Develop functional use-case specifications covering clinical outcomes, operational performance, and financial impact.
• Evaluate analytics use cases based on ROI, clinical safety, regulatory compliance, and data feasibility.
• Trace transactional data lineage across multi-vendor healthcare systems.
• Support the development of a standardized Master Drug Index using NDCs and RxNorm Concept Unique Identifiers (CUIs).
• Analyze data structures across Epic Willow, Beacon, Cadence, Clarity, Caboodle, and Epic Inpatient MAR.
• Reconcile pharmacy automation and compounding data from systems such as DoseEdge, Omnicell, and BD Pyxis.
• Define data requirements for medication safety, surveillance, risk management, and compliance platforms.
• Analyze data from retail pharmacy, 340B, procurement, supply chain, and cost-accounting systems.
• Partner with Data Scientists and Machine Learning Engineers to build feature stores for care-setting routing, stockout forecasting, and diversion anomaly detection.
• Establish automated data validation and reconciliation frameworks aligned with general ledger entries and cash collections.
• Support Databricks Unity Catalog governance, including row-level facility filters and column-level dynamic masking to protect PHI and confidential vendor pricing.
• Collaborate with pharmacy, clinical operations, finance, compliance, analytics, and engineering teams.

Required Skills

• PharmD or BS in Pharmacy (RPh) from an accredited institution.
• Active, unrestricted license from a State Board of Pharmacy.
• 8+ years of clinical experience in inpatient hospitals, outpatient infusion centers, or specialized healthcare consulting.
• 5+ years of healthcare informatics experience, particularly EHR analytics and pharmacy systems.
• Functional knowledge of Epic Willow (Inpatient and/or Ambulatory).
• Functional knowledge of Epic Beacon.
• Understanding of Epic Cadence Scheduler and scheduling slot templates.
• Healthcare terminology and medication data standards:
• HCPCS J-Codes
• ICD-10
• LOINC
• Ability to translate clinical pharmacy workflows into technical and analytics requirements.
• Experience with fragmented, multi-system healthcare data.
• Experience with data lineage, entity resolution, audit logic, and data validation.
• Strong analytical, documentation, and cross-functional communication skills.
• Epic certification or formal proficiency in Willow Inpatient, Willow Ambulatory, Beacon, Clarity, or Caboodle.
• Direct implementation experience with at least three of the following:
• DoseEdge
• Sentry 340B
• ControlCheck
• EnterpriseRx
• Meperia SCM
• Intermediate SQL skills for exploring relational database schemas.
• Familiarity with Databricks Medallion architecture, Delta Lake, and Unity Catalog.
• Experience with healthcare data lakehouse platforms.
• Experience supporting predictive analytics and machine learning use cases.
• Knowledge of pharmacy procurement, supply chain, 340B, cost accounting, and revenue-cycle operations.
• Experience collaborating with clinical, pharmacy, finance, compliance, data science, and engineering teams.