Data Analyst II

University of Rochester | Rochester, NY

Posted Date 3/27/2024


Full Time 40 hours Range URG 108 Pharmacy SMH


Develops methods for data collection and analysis to create and maintain an NDC optimization workflow. Analyzes and interprets data to redistribute slow moving inventory. Works directly with the pharmacy buyer, inventory technicians and pharmacy managers to lessen WAC exposure and maintain inventory levels across all ambulatory pharmacy locations. This analyst will have the ability to work as part of a team or independently to provide seamless service across the department with daily tasks in the aforementioned area. Collects, analyzes and documents business requirements and translates into function and system requirement specifications. May guide other less experienced team members.


  1. Tracks and Compiles comprehensive business metric data for evaluating effectiveness of programs, processes, or practices. Signs off on accuracy of all compiled data. Protect and ensure confidentiality of data per applicable policies and procedures (i.e. HIPPA etc.). Create and maintain an NDC optimization process to ensure consistency and lessen WAC exposure across all ambulatory pharmacies. Will require utilization of reports from multiple sources including wholesaler and pharmacy software. Track and review changes on a daily basis and share with pharmacy buyer.
  2. Collect requirements and design reports to meet data analysis needs. Use pharmacy software reports to identify slow moving inventory and redistribute it across the ambulatory pharmacies to be utilized. Will report on 180-day accumulations to ensure unreplenished 340b drug is accounted for appropriately from a financial perspective.
  3. Updates and maintains the integrity of assigned databased on an ongoing basis. Use pharmacy software reports to set and maintain appropriate par and optimum levels for inventory items across all ambulatory pharmacies. May conduct training sessions regarding proper technology usage to staff.
  4. Create and maintain an internal cash plan for patients across all ambulatory pharmacies.
  5. May develop standard operating procedures, process maps, code manuals and project plans for all major reporting projects.

Other duties as assigned


  • Bachelor’s Degree in statistical analysis, data base management, or related discipline required
  • 3 years of data analysis or customer resource management systems experience required
  • Or Equivalent combination of education and experience
  • Attention to detail required
  • Accuracy and record keeping required
  • Organization required
  • Data analysis and problem solving required
  • Statistics preferred
  • Advanced Excel preferred
  • Portraying data visually preferred

The University of Rochester is committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion to advance the University’s mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion/creed, sex, sexual orientation, citizenship status, or any other status protected by law. This commitment extends to the administration of our policies, admissions, employment, access, and recruitment of candidates from underrepresented populations, veterans, and persons with disabilities consistent with these values and government contractor Affirmative Action obligations.

How To Apply

All applicants must apply online.

EOE Minorities/Females/Protected Veterans/Disabled

Pay Range

Pay Range: $50,752 - $71,053 Annually

The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job’s compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.

Salary50,752.00 - 71,053.00 Annual
Employment Type
Full Time

Share this job