Financial Planning and Analysis Coordinator

This is a Full Time Job

The Coordinator, Financial Planning and Analysis (FP&A) position will be responsible for assisting the Director, Financial Planning and Analysis (FP&A) and Financial Analyst with budgeting, forecasting, long-term planning, implementation, and business strategic analysis of the financial team.

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.
• Format monthly financial statements to be distributed to department heads.
• Create and maintain revenue model and update monthly.
• Work with the revenue model in our Oracle NetSuite ERP.
• 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 project, while being detail oriented in a fast paced environment
• Discretion with confidential information