Sr. Pharmacy Data Analyst Drug Use Management Clinical Services (DECISION SUPP SPEC )

UCSF Health

Job Overview

Weekly Hours

40 ; 100% Appointment Type Career Department Clin Svcs Parnassus Shift 8-hour Days Union Information This classification is not represented by a union

At UCSF Health, our mission of innovative patient care, advanced technology and pioneering research is redefining what’s possible for the patients we serve – a promise we share with the professionals who make up our team. 

Ranked by U.S. News & World Report as seventh in the country – UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere. In an environment that allows for continuous learning and opportunities for professional growth, UCSF Health offers the ideal atmosphere in which to best use your skills and talents.

Department Description

The Department of Pharmaceutical Services provides a full range of contemporary services for patients cared by the UCSF Medical Center, as well as its providers and payers.

The UCSF Pharmacy Enterprise encompasses Inpatient Pharmacy Services, Ambulatory Care Services, Specialty Drug Pharmacy, Pharmacy Business Services, Pharmacy Informatics, Medication Safety and Regulatory Compliance, Oncology Infusion Services, 340B Management, Pharmacy Revenue Cycle and Central Pharmacy Production and Repackaging Services.

The Department of Pharmaceutical Services is fully responsible for the medication use process across the health system. Services provided by pharmacy include, but are not limited to, drug procurement, drug storage and security; safe, accurate and timely preparation and distribution of drugs; clinical pharmacy services for patients; drug information services for clinicians and patients; retail specialty drug pharmacy services; ambulatory care pharmacy services; oversight of sate medication practices; antimicrobial stewardship; pharmacy oncology infusion services; pharmacy revenue cycle; central drug production and distribution with state-of-the-art automation; and development and management of drug use policies and procedures within the Medical Center.

The department is integrated with the Department of Clinical Pharmacy, an academic campus unit within the School of Pharmacy, which has a primary responsibility for teaching professional courses in the PharmD curriculum, research, and public service.

Department of Pharmaceutical Services provides inpatient pharmacy services for Moffitt Long Hospital at Parnassus, Benioff Children’s Hospital in Mission Bay and Mount Zion Hospital. Inpatient pharmacies provide clinical and drug distribution services to the associated clinics and medical offices of each hospital.

Job Summary

The Pharmacy Senior Data Analyst is responsible for supporting the management of the department’s financial performance and opertional productivity and efficiency.

The analyst maintains critical databases and analytical tools to develop reports, dashboards, and drug management utlization tracking tools to identify trends and opportunities for improvement of Pharmacy Operations, Business, Finance and Clinical Services to reduce cost and improve quality, service and productivity.

This position plays a critical role in developing Pharmacy Department business strategy, developing ROIs for pharmacy projects and programs, and participating in the annual captial, operating and VIP budgeting, including evaluating the impact of annual drug price changes on gross drug revenue.

Required Qualifications

  • Five years experience in Decision Support or Financial Management in managed care, hospital, or similar setting, preferably in Pharmacy
  • Epic Systems Certification in analytical or reporting modules (e.g., Clarity); or positioned for training and certification on hire
  • Bachelor’s Degree in business, health related, finance, data science, or a directly related field
  • Experience developing and implementing reporting solutions and tools for evaluation of financial performance, purchasing, inventory management, drug utilizaiton and drug reimbruesement (e.g. SQL Analysis Services, Tableau, MS Office Excel)
  • Knowledge of and experience working with Healthcare specific EMR, Decision Support, and Financial accounting software. (e.g. Epic, Tag Bio or similar)
  • Advanced knowledge of MS Excel required; Experience with MS Application (e.g. Word, Visio, PowerPoint, SQL Server/Access)
  • Advance experience in using automation and data visualization, preferably MS Office Excel, Tableau and SQL, with strong skills in developing self-service analytical solutions
  • Advanced interpersonal skills, with the ability to lead projects and teams and collaborate productively on highly-complex projects with key personnel at all professional and technical levels
  • Advanced written and verbal communications skills, with the ability to interpret and convey highly sophisticated technical and financial information in a clear, concise manner, and to make cogent presentations of analyses, reports, and investigation results. Ability to convey technical topics to non-technical audiences
  • Advanced problem-solving skills analytical ability, and in-depth knowledge of documentation and reporting, with the ability to run highly complex queries and studies, to collect and analyze financial and performance data, and to produce relevant, meaningful reports, analyses, and forecasts
  • Advanced data management and mining skills including ability to develop and execute highly complex SQL queries and stored procedures to organize, transform and extract financial and clinical data for production of relevant, meaningful reports, statistics, analyses and forecasts
  • Advanced experience in working with relational databases, large data sets and multiple data sources required – including validating and auditing data
  • Strong leader with previous hands on technical experience, through understanding of data marts, ETL processing, data visualization, and information delivery
  • Professional approach to work including a strong sense of responsibility for assigned duties; demonstrated ability to handle and prioritize multiple assignments and overlapping deadlines
  • Ability to work well independently and as part of a team
  • The flexibility to orient and work at all UCSF Health locations
  • Preferred Qualifications

  • Epic Systems Certification in medication use modules (e.g., Willow Inpatient, Willow Ambulatory, Willow Inventory, Beacon); or positioned for training and certification on hire
  • EPIC Clarity Data Model Certification (Willow IP/OP)
  • Licensure/Certification

  • Epic Systems Certification in analytical or reporting modules (e.g., Clarity); or positioned for training and certification on hire
  • Living Pride Standards

    Service Excellence

  • Demonstrates service excellence by following the Everyday PRIDE Guide with the UCSF Medical Center standards and expectations for communication and behavior. These standards and expectations convey specific behavior associated with the Medical Center’s values: Professionalism, Respect, Integrity, Diversity and Excellence, and provide guidance on how we communicate with patients, visitors, faculty, staff, and students, virtually everyone, every day and with every encounter. These standards include, but are not limited to: personal appearance, acknowledging and greeting all patients and families, introductions using AIDET, managing up, service recovery, managing delays and expectations, phone standards, electronic communication, team work, cultural sensitivity and competency.
  • Uses effective communication skills with patients and staff; demonstrates proper telephone techniques and etiquette; acts as an escort to any patient or family member needing directions; shows sensitivity to differences of culture; demonstrates a positive and supportive manner in which patients / families/ colleagues perceive interactions as positive and supportive. Exhibits team work skills to positively acknowledge and recognize other colleagues, and uses personal experiences to model and teach Living PRIDE standards. 
  • Exhibits tact and professionalism in difficult situations according to PRIDE Values and Practices
  • Demonstrates an understanding of and adheres to privacy, confidentiality, and security policies and procedures related to Protected Health Information (PHI) or other sensitive and personal information.
  • Demonstrates an understanding of and adheres to safety and infection control policies and procedures.
  • Assumes accountability for improving quality metrics associated with department/unit and meeting organizational/departmental targets. 
  • Work Environment

  • Keeps working areas neat, orderly and clutter-free, including the hallways. Adheres to cleaning processes and puts things back where they belong. Removes and reports broken equipment and furniture.
  • Picks up and disposes of any litter found throughout entire facility. 
  • Posts flyers and posters in designated areas only; does not post on walls, doors or windows.
  • Knows where the Environment of Care Manual is kept in department; corrects or reports unsafe conditions to the appropriate departments.
  • Protects the physical environment and equipment from damage and theft.
  • The flexibility to orient and work at all UCSF Health locations is required.

    View More
    Job Detail
    Shortlist Never pay anyone for job application test or interview.