About this position
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