"Senior Business Intelligence Analyst"

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 is a highly visible and high impact position with responsibility for providing insightful analysis and decision support.

The Ohio State University College of Dentistry is the fourth largest public dental school in the United States and it is the only public dental school in Ohio. The college is divided into ten divisions with all major ADA-recognized dental specialties represented. The College has approximately 600 students in its undergraduate and graduate programs.

The successful candidate will possess the ability to perform in an environment with multiple priorities, work independently, gather business understanding from key cross-functional stakeholders, have strong problem-solving abilities, take initiative, assist and lead change management process, innovate, and have the ability to communicate complex technical concepts to groups with diverse technical and non-technical backgrounds.

The Senior Business Intelligence Analyst duties may include:

• Works with the business to understand and design analytical approaches to open-ended strategic business problems and communicates insights
• Fuels strategic decision-making with key stakeholders through reports, dashboards, presentations, storytelling and thoughtful discussion.
• Develops and leverages business understanding, analytical and visualization tools, knowledge of data sources,
• Performs sophisticated statistical analyses to consume and interpret data sets from multiple sources in order to impact performance optimization, goal setting, strategic decisions, and the generation of new hypotheses
• Provides insightful analysis as a basis for information dissemination, strategic planning and decision making related to the operational and financial performance of the College.
• Identifies of trends and areas of performance opportunity
• Assesses information needs and develops and maintains analytic and visualization systems, processes and business intelligence tools to support budgeting, modeling, forecasts, reports, analyses and presentations of results.
• Prepares analyses, visualizations and reports of operational and financial performance, including comparisons to identified standards, targets, and/or strategic plans to senior leaders
• Identifies and interprets financial and operational trends and projections and effectively communicates the meaning of analytical findings. Develops and presents recommendations.
• Initiates and prepares analyses of complex business issues related to strategic priorities of the college. Identifies appropriate techniques and methodologies for conducting analysis and presenting results. Establishes performance metrics and standards.
• Provide analytical support to the annual budget process and forward-looking forecasts. Develops what-if scenarios as requested Lead analytical initiatives with cross functional groups across the college and University.

Work Schedule: Monday-Friday

This position requires successful completion of a criminal background check and drug and alcohol screening. Work is performed primarily in an office environment and the employee in this class is subject to inside environmental conditions. This position requires sustained periods using a keyboard and performing other computer work. Requires sufficient personal mobility and physical reflexes, which permits the employee to function in a general office environment to accomplish tasks.

Required Qualifications:

• 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.

Desired Qualifications:

• 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.