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

Opening:

Worker Subtype:

Time Type:

Scheduled Weekly Hours:

Department:

Work Shift:

Range:

Compensation Range:

Responsibilities:

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 Purchasing to track Purchase Orders and payment progress. Calls external suppliers when necessary.

Acts as back up to Microbiology Administrative Assistant and Microbiology Secretary (20%)

Performs other related duties as required.

QUALIFICATIONS:

• Bachelor’s degree with major coursework in a technical or analytic field or an equivalent combination of training and coursework.  Bachelor’s degree with coursework in computer programming, statistics, advanced math, and natural science preferred.
• Advanced computer skills and proficient in use of spreadsheet software and other specialized computer software, with particular expertise in data analysis and developing reports through use of Excel, Pivot Tables, dynamic graphical data visualization, and development of Macros using Visual Basic.
• Demonstrated experience with a variety of databases and software such as SQL, Microsoft Excel and Access, SOFT LIS, Pivot Tables, Macros, Visual Basic, UR Financials Workday Procure to Pay, Jaeggar Marketplace, McKesson/Allscripts PMM Supply Chain Management Solutions (Materials Management Information System, MMIS), URMC IBM Cognos Analytics, Oracle, OnBase. SharePoint, Box.
• Excellent problem solver and capable of working well with a substantial amount of data and information.
• Must be self-directed and able to work independently.

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 Classes). 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.