Coordinator, Financial Planning and Analysis

Duties And Responsibilities

• Manage excel files that create functional strategies and specific objectives for the financial planning and analysis team.
• Game by game revenue files related to game day revenues for all companies.
• Investigate and summarize variance explanations into game day per caps.
• Conduct revenue analysis including volume/rate relationships.
• Summarize trends through graphs and data visualization software.
• Gather data to assist in conducting financial analysis, modeling, forecasting and reporting efforts to ensure efficient financial operations.
• Create and maintain monthly financial statements to be distributed to department heads.
• Create and maintain revenue model and update monthly.
• Create and maintain monthly forecast file.
• Maintain monthly analysis of multiple departments expenses.
• Set up, maintain and analyze Game Day Profit Loss (PL) statements.
• Prepare upcoming year’s expense budget files and revenue forecast files.

Qualifications

• Bachelor’s degree in Finance
• Intermediate Excel skills
• Experience with SQL is a plus
• Ability to work independently, prioritize multiple projects, while being detail oriented in a fast-paced environment
• Discretion with confidential information