Pharmacy Business Analyst III

: Please Note: While this position is listed as hybrid, regular in-office attendance is required. Candidates should be prepared to commute to the office on a consistent basis to support team collaboration and business needs.

Equivalent experience will be accepted in lieu of the required degree or diploma.

• Bachelor's degree in Business Analytics, Healthcare Administration, Statistics, Economics, Finance, Computer Science, or a related field

• Epic Cogito Certification within one year
• Microsoft Certified Power BI Data Analyst Associate within one year

• 6 years recent relevant experience

• Experience supporting hospital or health-system pharmacy operations, regulatory compliance, accreditation, and medication safety.
• Familiarity with Epic pharmacy workflows and reporting tools, including Willow, SlicerDicer, and Reporting Workbench, and medication ordering, dispensing, and administration data.
• Experience querying Epic Clarity databases using SQL to extract, reconcile, and validate pharmacy and medication-use data for operational, compliance, and medication safety reporting.
• Experience with Pyxis systems and transaction data, including inventory, overrides, waste, and controlled substance discrepancies.
• Familiarity with pharmacy applications such as BlueSight ControlCheck, Compounding360, or comparable systems.
• Experience supporting SaaS applications and interfaces, including vendor coordination, data-feed validation, troubleshooting, and familiarity with APIs, HL7 messages, or secure file transfers.
• Experience developing and maintaining reports and dashboards using Power BI, Tableau, Epic reporting tools, vendor reporting platforms, or comparable tools.
• Proficiency with SQL and advanced Excel, including cross-system data reconciliation, report validation, metric definitions, and data-quality monitoring.
• Experience analyzing medication errors, near misses, adverse drug events, and quality improvement measures to support medication safety and corrective-action monitoring.
• Experience gathering business requirements, mapping workflows, conducting user acceptance testing, and supporting application implementations or conversions.
• Ability to translate pharmacy data into actionable compliance, medication safety, and operational reports while maintaining healthcare data privacy and security.

• Progressive experience in Data Analytics, Business Intelligence, or a related analytical role.
• Proven experience independently solving complex business problems using advanced analytics and predictive modeling.
• Strong experience building advanced models and dashboards in a primary visualization tool (Tableau or Power BI).
• Experience writing advanced SQL queries for complex data exploration and extraction.
• Experience leading small-to-medium analytical projects.
• Analytics: Advanced understanding of statistical analysis, forecasting, and predictive modeling concepts.
• Tools: Advanced proficiency in data visualization platforms (Tableau, Power BI) or in application tools and advanced Excel modeling.
• Data Access: Advanced SQL skills (SELECT, JOIN, GROUP BY, CTEs) for independent data extraction and exploration
• Communication: Excellent data storytelling and presentation skills; ability to influence non-technical stakeholders.
• Problem Solving: Strong ability to exercise independent judgment and tackle novel, ambiguous business questions.

These Principal Accountabilities, Requirements and Qualifications are not exhaustive, but are merely the most descriptive of the current job. Management reserves the right to revise the job description or require that other tasks be performed when the circumstances of the job change (for example, emergencies, staff changes, workload, or technical development).

Job Shift:

Days