[Hiring] Reporting and Analytics Analyst @The Ohio State University

Role Description

The Reporting Analytics Analyst provides customer support to current users through analysis, creation of reports, current report maintenance, and custom data requests turning data into meaningful insights to meet business needs of the department. Works with the business to understand and design analytical approaches to communicate insights and fuel strategic decision-making with key stakeholders through reports, dashboards, presentations, and storytelling.

• Leverages business understanding, sophisticated report writing tools, programming skills, and knowledge of databases to consume and interpret data sets from multiple sources.
• Impacts performance optimization, goal setting, and strategic decisions through report creation.
• Utilizes the RAE database to create Tableau datasources and reports for the department.
• Supports the cancer research program by performing analysis and data mining of financial and research operations and databases.
• Facilitates alignment of value-added data-driven approaches in key performance areas through the Cancer Program.
• Utilizes databases, Excel, Access, and Tableau to assist Manager Reporting and Analytics in producing financial analytical reports, scorecards, and summaries.
• Responsible for data maintenance and spreadsheets for Cancer supported recruits, Intramural Research Awards (IRP), Pelotonia Scholarship Awards, and CCC Funding.
• Validates and ensures accuracy, consistency, and appropriate use of data in reports.
• Coordinates with IT and Finance team regarding database creation and maintenance.
• Assists with budget to actual data on monthly, quarterly, and annual bases for fund financial review, forecasting, and variance analysis.
• Creates and maintains monthly and quarterly reports used by CCC leadership.
• Maintains and updates the CCC Workday Tag mapping dashboard used by various Cancer center departments.
• Creates/reviews progress reports and analyzes financials and grants to create reports for programmatic Return on Investment (ROI).
• Collects accurate data from PI Portal, NIH reporter, and PubMed.
• Works with Pelotonia Fellowship Administrator Manager, Manager Reporting and Analytics, and Finance Director to assist with reporting requests.
• Prepares customized reports for special projects as needed.
• Provides support in financial management, budgeting, reporting, and other financial services as needed.

Qualifications

• Bachelor’s Degree in relevant field.
• 2 years of relevant experience required; 2-4 years of relevant experience preferred.
• Strong analytical skills and computer skills.
• Ability to manage time efficiently to complete multiple tasks with competing deadlines.
• Proficiency in Excel, Access, Tableau, and Microsoft Office desired.
• Knowledge of the general ledger and SQL is desirable.

Requirements

• Final candidates are subject to successful completion of a background check.
• A drug screen or physical may be required during the post-offer process.

Company Description

The university is an equal opportunity employer, including veterans and disability.