Clinical Pharmacy Consultant / Informaticist

🚨 Hiring: Clinical Pharmacy Consultant / Informaticist 🚨📍 Location: USA – Iowa (Remote)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.🔹 Key ResponsibilitiesLead 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 SkillsPharmD 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:NDC (10/11-digit National Drug Codes)HCPCS J-CodesRxNorm Concept Unique Identifiers (CUIs)ICD-10LOINCAbility 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.⭐ Preferred SkillsEpic certification or formal proficiency in Willow Inpatient, Willow Ambulatory, Beacon, Clarity, or Caboodle.Direct implementation experience with at least three of the following:DoseEdgeSentry 340BStrataJazzControlCheckEnterpriseRxMeperia SCMUKG/Kronos HealthcareIntermediate 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.