Senior Business Intelligence Analyst

Job Title

Senior Business Intelligence Analyst

Dentistry | College Administration

Postle Hall (0024)

Regular

40

First Shift

Monday‑Friday

The Ohio State University College of Dentistry is seeking a Senior Business Intelligence Analyst whose focus will be on optimizing the financial health and performance of the college. Reporting to the Chief Administrative Officer, this highly visible and high‑impact position is responsible for providing insightful analysis and decision support.

• Work with the business to understand and design analytical approaches to open‑ended strategic business problems and communicate insights.
• Fuel strategic decision‑making with key stakeholders through reports, dashboards, presentations, storytelling, and thoughtful discussion.
• Develop and leverage business understanding, analytical and visualization tools, and knowledge of data sources.
• Perform sophisticated statistical analyses on data sets from multiple sources to impact performance optimization, goal setting, strategic decisions, and the generation of new hypotheses.
• Provide insightful analysis as a basis for information dissemination, strategic planning, and decision making related to the operational and financial performance of the College.
• Identify trends and areas of performance opportunity.
• Assess information needs and develop and maintain analytic and visualization systems, processes, and business intelligence tools to support budgeting, modeling, forecasts, reports, analyses, and presentations of results.
• Prepare analyses, visualizations, and reports of operational and financial performance, including comparisons to identified standards, targets, and/or strategic plans, for senior leaders.
• Identify and interpret financial and operational trends and projections and effectively communicate the meaning of analytical findings; develop and present recommendations.
• Initiate and prepare analyses of complex business issues related to strategic priorities of the college; identify appropriate techniques and methodologies for conducting analysis and presenting results; establish performance metrics and standards.
• Provide analytical support to the annual budget process and forward‑looking forecasts; develop “what‑if” scenarios as requested.
• Lead analytical initiatives with cross‑functional groups across the college and University.

• Bachelor's degree.
• 7‑10 years of experience as a financial or business analyst preparing analyses and reports using statistical, operational, and financial data.
• Extensive experience with accounting, budgeting, and forecasting systems, processes, and procedures.
• Extensive experience with databases and data warehouses.
• Demonstrated ability to create and utilize analytic, forecasting, modeling, and business intelligence tools and concepts.
• Demonstrated ability to create and utilize financial model projections and scenarios.
• Excellent analytical skills, including experience with data modeling, spreadsheets, and databases.
• Advanced experience with Excel and Tableau or similar software.
• Demonstrated ability to work independently and as a member of a team with individuals at all levels within the college.
• Analyze and resolve operational needs and problems.
• Apply financial, policy, and program requirements to system functionality.
• Read, interpret, and apply complex financial rules and technical material.
• Understand relationships among multiple interrelated systems.
• Excellent oral and written communication skills, including presentations of financial and operational data and recommendations.

• Master's degree in business.
• 7‑10 years of experience as a financial analyst in higher education.
• Extensive experience with the Ohio State University budgeting and accounting systems, processes, and procedures.
• Experience with Workday.
• Experience with Tableau.
• Experience in healthcare information systems.

• This position requires successful completion of a criminal background check and drug and alcohol screening.
• Work is performed primarily in an office environment; the employee in this class is…