Job Description

Employment Status:
Full time
Job Function:
Business Professional
Department:
302102
Shift Hours / Days:
Hours / Pay Period:

Advisor, Pharmacy Analytics

We Fight Cancer: Care That Never Quits®

Cancer Treatment Centers of America® (CTCA®) delivers an extraordinary patient experience that delivers state-of-the-art, high quality care through an integrative model where a team of experts puts patients at the center of their own care. Every day is purposeful. Every day, you will help patients win the fight against cancer. Every day is challenging and rewarding beyond your imagination.

The Best Place to Work

We call ourselves Stakeholders because we all have a stake in the care and success of every patient. Today, CTCA Stakeholders deliver healing and hope to patients fighting complex and advanced cancer in Atlanta, GA, Chicago, IL, Philadelphia, PA, Phoenix, AZ and Tulsa, OK. Each of our hospitals earned a Best Place to Work distinction and has received numerous accreditations that celebrate our culture of clinical quality, innovation, high performance and wellness.

A Culture of Teamwork, Empowerment & Development

CTCA provides Stakeholders with exceptional support and easy access to a wide range of tools and resources they need to bring the best of themselves, every day. Our benefits, wellness, and compensation programs lead the market. Imagine accessing your own personal health coach! We also provide extensive training and career development opportunities that encourage professional and personal growth,it is a point of pride. Those are just a few of the ways we empower our Stakeholders to deliver the highest standard of care that we call the Mother Standard®.

Job Overview:

The Advisor, Pharmacy Analytics reports to the Director of Pharmacy Business Services.  This resource is a key player in the Office of Pharmacy Services’ analytical and business intelligence capabilities for managing the annual revenue stream for the enterprise.  Managing this volume of data requires a focused resource that can coordinate and provide insightful analytics in order to enable informed and timely business decisions. 

The Advisor, Pharmacy Analytics will be in charge of creating and distributing various pharmacy analyses to the Office of Pharmacy Services, Site Pharmacy teams, Site Finance teams, and Site Operations teams, as well as conducting ad hoc analysis to support initiatives and requests emanating from those aforementioned teams. The Advisor, Pharmacy Analytics is responsible for developing and maintaining the Pharmacy Pricing model by site which rolls up at the enterprise level. The Advisor, Pharmacy Analytics is an internal expert regarding the system reporting capabilities and is also responsible for maintaining accurate metric measures and providing management with the data needed to make informed business decisions.    Additional responsibilities include assisting with: planning, organizing and maintaining data sources such as the data warehouse for pharmacy’s business intelligence strategy, acting as liaison with IT/Business Intelligence for report creation and distribution, acting as liaison with Corporate Finance’s Decision Support team, coordinating User Acceptance Testing for Pharmacy reporting tools, conducting report testing, driving analysis that will be critical inputs into pharmacy-related decisions for the enterprise. The Advisor, Pharmacy Analytics will be responsible for training and developing Pharmacy Analysts to tackle analytical problems using CTCA standardized approaches and workarounds as needed. The Advisor, Pharmacy Analytics will also assist with management of the Pharmacy Analysts’ work streams. The Advisor, Pharmacy Analytics will assist with: assessing operations and making recommendations to leadership; providing translations, analyses and interpretations of information; and assisting with project management for the various enterprise initiatives.

Functions that will be covered include but not be limited to: trend analysis (actual vs. budget), prescribing/ordering, billing, collections, expenses, revenue, and clinical outcomes, as well as what-if business modeling. 

More specifically, analysis conducted will include but not be limited to the following:

  1. Pharmacy Pricing Model
  2. Trending of actual vs. target pharmacy revenue while differentiating between Categories and type of charge as needed
  3. Financial impact of fluctuations in drug pricing, drug costs, etc.
  4. Financial and operational impact of unexpected industry events such as drug shortages, regulatory shifts, brand to generic shifts, etc.
  5. Comparison of enterprise-wide drug prices and volumes against industry benchmark analysis
  6. Drug margin analysis comparing acquisition cost (as well as ASP, AWP, and WAC) of common doses to charged amounts
  7. Differences between AWP, ASP, WAC, and Acquisition Cost to assist with pharmacy pricing strategy
  8. Tracking of drug charges and relative position against corporate initiative
  9. Support of ad-hoc pharmacy analysis with critical timelines
  10. Formulary purchasing analysis monitoring usage post-formulary decisions
  11. Revenue modeling to support the Pharmacy Pricing Committee
  12. Assessing the overall pharmacy pricing logic, pricing trend analyses
  13. AWP quarterly impact modeling
  14. Off-label drug usage analysis and monitor reimbursement trends
  15. Assist in managing the pharmacy revenue cycle, from acquisition and pricing through billing, reimbursement, and denials (reimbursement and denials when reporting capabilities are possible)
  16. Wholesaler and GPO purchasing analysis
  17. Building requirements for the Pharmacy Data Mart, as well as testing and training
  18. Managing and coordinating reporting from Data Mart
  19. Building and maintaining the Pharmacy Dashboard and other business intelligence tools
  20. Analyzing centralized packaging, mail order business, PBM, and supplements
  21. Assisting with modeling third-party payer contracts
  22. Implementing and monitoring formulary changes
  23. Monitoring and expanding billing for cognitive services
  24. Preparing for future enterprise expansion
  25. Monitoring oral chemo adoption, prescribing and reimbursement
  26. Monitoring the Pharmacy Chargemaster
  27. Other ad hoc activities related to monitoring the pharmacy revenue cycle
  28. Build detailed models for prescribing information for key clinical and executive leadership

?Specific metrics and measures of success for this role, that will be reported upon, will include but not be limited to:

  1. Performance of Pharmacy Revenue actual vs. target by fiscal year
  2. Ratio of Cost of Drugs to Pharmacy Gross Revenue
  3. Ratio of Pharmacy Expenses to Pharmacy Gross Revenue
  4. Pharmacy Gross Revenue as a % of Total Hospital Gross Revenue
  5. Quarterly AWP revenue impact across all sites
  6. Additional Gross Revenue due to Price or Purchasing Optimization Activities

Job Accountabilities:

  • Lead the development of new analytic capabilities and business intelligence tools while training other analysts to run reports developed in the pharmacy data warehouse and other information systems as requested.  The Advisor, Pharmacy Analytics’s role will be responsible for maintaining the integrity of the Pharmacy Dashboard in support of key pharmacy-related decisions for the purpose of obtaining executive approval. Provide both new and routine management reports required to support; Pharmacy & Therapeutics, Pricing Committee, Corporate Pharmacy, Hospital Pharmacy, Hospital Executive Team, and Corporate/Hospital Board requests.
  • Creates and distribute ad-hoc reports per requests from Pharmacy Leadership, Executive Operations Leadership, and Site Leadership. Ensures all routinely executed reports are distributed electronically as required. Communicate routinely with Pharmacy Leadership, Site Pharmacy teams, Finance, and Corporate Decision Support. Providing ad hoc report analysis on various business functions will include but not be limited to: purchasing, prescribing/ordering, billing, collections, expenses, revenue, and clinical outcomes.  Includes what-if business scenario modeling.
  • Train Pharmacy Analysts to perform various analysis and reconciliations to ensure that automated data pulls continue to balance to their source systems.  This could include Lawson reconciliations for revenue, wholesaler and vendor reconciliations for purchasing, AMPFM reconciliations for transaction detail. Identify reconciliation issues and report to Pharmacy management, and if necessary, assist in the development of solutions to identified issues.
  • Collaborates closely with the user communities, assists Pharmacy teams and leadership to provide support for projects and initiatives.  Assists with the training, education, and instruction of users on functionality, features, and usage of pharmacy data and reporting systems.  Assists with mapping process models, designing automated and reporting solutions to satisfy requirements, and completing formal system testing of reports, scorecards, dashboards, etc.

Education/Experience:

  • A BS/BA in Business or related field (e.g. Finance, Computer Technology, etc.)
  • Must have 5 years working experience with a minimum 3 years of Pharmacy, Pt Accts, Finance or IT experience with focus on analysis and process flow
  • Pharmaceutical, Hospital, healthcare payer, consulting, finance, and/or purchasing experience are a plus. 
  • 1+years of project management experience is preferred.

Knowledge and Skill:

  • Must have strong analytical skills, and reporting experience to key business users
  • Must have management communication and reporting experience, including conducting personal analysis and providing recommendations to management
  • Exceptional analytical ability in structured problem solving
  • Advanced Excel Skills; proficient with Access and PowerPoint a plus
  • Qlikview, Business Objects and/or other database reporting experience (such as SQL) preferred
  • Strong interpersonal, written, and oral communication skills
  • Must have experience in a reporting capacity to key internal customers
  • Must have experience working with IT on business requirements for performance management tools (e.g., scorecards, dashboards)
  • Evidence of continuing education that is directly related to the job specification.
  • Familiarity with “Lean” processes is preferred, A-3 Training and Green Belt extremely beneficial
  • Experience with data warehousing a plus (e.g. QlikView, Business Objects, etc.)
  • Lawson or similar ERP system experience a plus
  • Able to work in a fast-paced environment and handle multiple projects and deadlines
  • Detail oriented with strong organizational and project management skills