What are the responsibilities and job description for the Coordinator, Financial Planning and Analysis position at Tampa Bay Rays?
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
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, sexual orientation, age, disability, gender identity, marital or veteran status, or any other protected class.
