Data Analyst I

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):

211 Bailey Rd, Rochester, New York, United States of America, 14586

Opening:

Worker Subtype:

Regular

Time Type:

Full time

Scheduled Weekly Hours:

40

Department:

500232 Microbiology SMH

Work Shift:

UR - Day (United States of America)

Range:

UR URG 106 H

Compensation Range:

$21.36 - $29.90

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.

Responsibilities:

GENERAL PURPOSE:
Under general direction from the Laboratory Directors and Manager, and with latitude for the exercise of independent judgement, provides specialized data analytics supporting clinical and business needs requiring advanced organizational, analytical, and computer proficiency. Applies statistical analysis methods to collect, organize, interpret, and summarize quantitative clinical data, creating reports that detail trends in performance and processes, and developing reports to provide usable information, drive decision making, and recommend improvements that benefit the department in terms of costs savings and improved laboratory procedures and patient care.

SUPERVISION AND DIRECTION EXERCISED:

• Under supervision of Laboratory Directors and Manager

MACHINES AND EQUIPMENT USED:

• Standard office equipment such as telephone, PC, Laboratory Information System (LIS), calculator, copier, fax printer and other similar equipment.

TYPICAL DUTIES:

Technical Support (70%)

• Analyzes data and reports to develop trend and comparative executive summaries to include structured and graphical displays for distribution. With minimal direction and using multiple data warehouses, creates, designs, and develops relevant laboratory and financial reports. Analyzes results and prepares executive summary for delivery. Interprets findings and makes recommendations based upon analysis of information gathered.
• Works heavily with SQL, Excel, Pivot Tables, Macros, Visual Basic, Access, SOFT LIS, SharePoint, Box, UR Financials Procure to Pay, Jaeggar Marketplace, and other software and databases.
• Performs preparation and analysis of laboratory statistics, creating customized data analytics tools, conducting research, and creating statistical reports. For variables under examination, assesses data quality by obtaining descriptive statistics for them such as mean, median, and standard deviation. May analyze the distribution of key variables to see how the individual values cluster around the mean.
• Visually represents complex information; designs, produces, deploys, and maintains metrics, scorecards, dashboards, ad hoc and scheduled reporting, with high-impact intuitive visualization of relevant clinical data, including customized dynamic graphical visualization and mapping.
• Ensures the integrity and quality of data reporting. Responsible for the validation, timeliness, accuracy, and improvement of the data feeding performance reports, management information, and KPIs.  Takes initiative to conduct root cause analysis of data quality issues and initiate and drive data quality improvement programs.
• Performs analysis and reporting of several laboratory QA monitors such as COVID TATs, Blood Culture Discrepancies and Volumes, and Viral Loads/Logs for HIV, Hep B, Hep C, & CMV.
• At discretion of Directors, collaborates with clinical researchers to understand needs and source information that supports laboratory and clinical method development. Performs sourcing and data integration from a variety of databases, combining data residing in different sources and providing users with a unified view.

Financial Operations Support (10%)

• At discretion of Manager, investigates discrepancies in financial variance reports. Researches, extracts data, and presents findings using a variety of financial databases such as UR Financials Workday P2P. Maintains relationships with other University Departments such as Accounts Payable and Purchas