Pharmacy Business Analyst III
About The Position
An advanced analytical professional who exercises independent judgment to solve complex pharmacy business questions. Requires both domain or pharmacy business and technical analytics expertise. As a deep domain subject matter expert, this role builds predictive models, delivers actionable insights, and leads project teams to drive specific pharmacy operational or financial decisions. This position is an independent professional contributor within the pharmacy system office. Bridges the gap between raw data and actionable strategy. Focuses on business value and regulatory compliance—leading business and technical requirements gathering, building rapid proofs-of-concept (POCs), and presenting data-driven recommendations to operational leaders. Working with minimal oversight, this role applies pharmacy knowledge and advanced analytical skills to novel pharmacy business problems where no clear procedure exists and supports operational analytic training.
Requirements
- Bachelor's degree in Business Analytics, Healthcare Administration, Statistics, Economics, Finance, Computer Science, or a related field (Equivalent experience will be accepted in lieu of the required degree or diploma)
- 6 years recent relevant experience
- 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
- Advanced understanding of statistical analysis, forecasting, and predictive modeling concepts
- Advanced proficiency in data visualization platforms (Tableau, Power BI) or in application tools and advanced Excel modeling
- Advanced SQL skills (SELECT, JOIN, GROUP BY, CTEs) for independent data extraction and exploration
- Excellent data storytelling and presentation skills; ability to influence non-technical stakeholders
- Strong ability to exercise independent judgment and tackle novel, ambiguous business questions
Nice To Haves
- Epic Cogito Certification within one year
- Microsoft Certified Power BI Data Analyst Associate within one year
- 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
Responsibilities
- Builds predictive models
- Delivers actionable insights
- Leads project teams to drive specific pharmacy operational or financial decisions
- Bridges the gap between raw data and actionable strategy
- Focuses on business value and regulatory compliance
- Leads business and technical requirements gathering
- Builds rapid proofs-of-concept (POCs)
- Presents data-driven recommendations to operational leaders
- Applies pharmacy knowledge and advanced analytical skills to novel pharmacy business problems where no clear procedure exists
- Supports operational analytic training
Benefits
- Comprehensive benefits package
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Principal
