Reporting and Analytics Specialist

Ohio State University; United States; Remote; USD 65,000 - 90,000; Full time

Job summary

The Ohio State University is seeking a Reporting and Analytics Specialist to transform data into meaningful insights. You will support current users with reports, dashboards, and data requests, turning data into strategic guidance for the department.

Responsibilities include building Tableau datasources, maintaining reports, and collaborating with IT and Finance to ensure data accuracy and alignment with budgeting processes. Remote-friendly role with regular hours.

Qualifications

• Bachelor's Degree in relevant field; 2 years of relevant experience required; strong analytical skills.
• Proficiency in Excel, Access, Tableau and Microsoft Office desired.
• Knowledge of the general ledger and SQL is desirable.

Responsibilities

• Provide reports, dashboards, and data insights to business stakeholders.
• Collaborate with the business to design analytical approaches and drive strategic decisions.
• Prepare financial and operational reports for senior management and ROI analyses.

Skills

Excel

Access

Tableau

SQL

Education

Bachelor's Degree in relevant field

Tools

Microsoft Office

Job description

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact [e-mail] . If you have questions while submitting an application, please review these frequently asked questions .

Current Employees and Students: If you are currently employed or enrolled as a student at The Ohio State University, please l og in to Workday to use the internal application process.

Welcome to The Ohio State University's career site. We invite you to apply to positions of interest. In order to ensure your application is complete, you must complete the following: Ensure you have all necessary documents available when starting the application process. You can review the additional job description section on postings for documents that may be required.

Prior to submitting your application, please review and update (if necessary) the information in your candidate profile as it will transfer to your application.

Job Title:

Reporting and Analytics Specialist

Department:

CCC | Administrative Office

Scope/Summary:

The Reporting Analytics Specialist 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 to impact performance optimization, goal setting, strategic decisions, and create reports. Utilizes the RAE database to create Tableau datasources and reports for the department. Functions as a Reporting and Analytics Analyst supporting the cancer research program by performing analysis and data mining of financial and research operations and databases and facilitating the 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 Analyt produce financial analytical reports, scorecards and summaries related to the Comprehensive Cancer Center (CCC) Programs, membership and associated departments and divisions for senior management to support key decisions. Responsible for data and maintain spreadsheets and funding databases for Cancer supported recruits, Intramural Research Awards (IRP), Pelotonia Scholarship Awards and CCC Funding as well as new CCC databases. Validates and ensures accuracy, consistency, and appropriate use of data in reports. Assists with coordinating with IT and Finance team regarding database creation and maintenance. Needs to understand the how data is reported in the General Ledger as well as the CCC financial reconciliation and budgeting process and requires understanding of Center's business operations. Assists with budget to actual data on monthly, quarterly, and annual bases for fund financial review, forecasting and variance analysis. Assists with the creation and maintenance of monthly and quarterly monthly 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) for publications and grants listed and maintains ROI for IRP and Fellowship Awardees. 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 and prepares customized reports for special projects as needed. Works with OSUCCC supported Faculty and Cost Center Managers in the department to provide support in financial management, budgeting, reporting and other financial services as needed; processes, performs other analysis and reporting as assigned.

Minimum Qualifications

Bachelor's Degree in relevant field, 2 years of relevant experience required, 2-4 years of relevant experience preferred, or an equivalent combination of education and experience required. Strong analytical skills, computer skills, and the 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.

Career Roadmap

• FUNCTION: Business Planning and Operations
• SUB-FUNCTION: Reporting and Analytics
• CAREER BAND: Individual Contributor - Specialized
• CAREER LEVEL: S2

Additional Information

• Location: Remote Location
• Position Type: Regular
• Scheduled Hours: 40
• Shift: First Shift
• Final candidates are subject to successful completion of a background check. A drug scree