Data Analyst I - Ambulatory Pharmacy Operations

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.

Job Location (Full Address):

601 Elmwood Ave, Rochester, New York, United States of America, 14642

Opening:

Worker Subtype:

Regular

Time Type:

Full time

Scheduled Weekly Hours:

40

Department:

500160 Pharmacy SMH

Work Shift:

UR - Day (United States of America)

Range:

UR URG 106 H

Compensation Range:

$21.36 - $29.90

Responsibilities:

This position will be responsible for compliance, auditing, reporting and general operational support for Ambulatory Pharmacy Services with a focus on inventory operations and compliance. Assists with the creation of presentations and reports based on findings, which includes collating, modeling, interpreting and analyzing data. Collects data requirements, analyzes and determines technical issues, and design ad-hoc reports. Collects, analyzes and documents business requirements and supports translation into function and system requirement specifications. This analyst will have the ability to work as part of a team or independently to provide seamless service across our department with daily tasks in the aforementioned area.

ESSENTIAL FUNCTIONS

• Assists with tracking and compiling of comprehensive business metric data for evaluating effectiveness of programs, processes, or practices  Assists with general pharmacy operations, using routine office software applications (word processing, Excel, Power BI, web browsers, etc), and routinely utilizes multiple software packages relative to inventory management (Cardinal order express, WAMB, eRecord, etc).  Researches and makes recommendations based on findings to ensure smooth department operations.
• Collects requirements and designs reports to meet data analysis needs. Assists in the preparation of detailed documentation and/or reporting, in the case of external audit.  Supports audit process and assists with compilation of required documentation regulatory bodies and PAAS audit assistance.
• Researches root cause of inventory discrepancies and reports them to the Business Manager as well as developing a plan of action to correct the discrepancy. Pulls and analyzes inventory related reports from Cardinal Order Express or eRecord for the Business Manager, Director of Ambulatory Pharmacy Services or the Inventory Manager. Pull purchasing reports and compares them to shipments as necessary.
• Assists in the development of standard operating procedures, process maps, code manuals and project plans for all major reporting projects, as needed. Conducts audits inventory counts during bi-annual inventory and those scheduled off cycle as required.  Remains available to pharmacy staff to field questions and handle technical issues with counting devices, Rovers. 
• Other duties as assigned

MINIMUM EDUCATION & EXPERIENCE

• Bachelor’s Degree in statistical analysis, data base management, or related discipline required
• 1 year of experience with data analysis or customer resource management systems required
• Equivalent combination of education and experience required
• Pharmacy related experience preferred

KNOWLEDGE, SKILLS AND ABILITIES

• Strong attention to detail required
• Strong organizational, data analysis and problem-solving skills required
• Familiarity with statistics and statistical analysis preferred
• Advanced knowledge of Microsoft Excel preferred
• Ability to visually portray data preferred

LICENSES AND CERTIFICATIONS

• Pharmacy Technician Certification preferred

The University of Rochester is committed to fostering, cultivating, and preserving an inclusive and welcoming culture 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 characteristic protected by federal, state, or local law (Protected Characteristics). This commitment extends to non-discrimination in the administration of our policies, admissions, employment, access, and recruitment of candidates, for all persons consistent with our values and based on applicable law.