United Talent Agency→
Analyst, FP&A at United Talent Agency in Los Angeles, CA
Entry LevelOn-siteFull-timeLos Angeles, CA$80k–$100k/yr
Skills
financial planning & analysisfinancial modelingbudgetingvariance analysispythonsqlvbaexcelpowerpointdata visualizationpower bierp systemsplanning systems
Job Description
Summary: United Talent Agency (UTA) is a leading global entertainment company that represents iconic artists and creators. They are seeking an Analyst for Financial Planning & Analysis to support the execution of the annual budget, quarterly reforecasts, and monthly financial reporting, focusing on variance analysis and key business performance metrics.
Responsibilities:
- Prepare monthly P&Ls and dashboards with actual vs. budget and prior year metrics for each Division/Department
- Research variances including actual vs. budget and actual vs. prior year
- Assist in the preparation of the annual operating and capital budgets by gathering and analyzing information and projecting costs
- Project revenue by analyzing booking report data and working closely with divisional key contacts
- Create financial models to help with analysis and consolidation
- Assist in the preparation of quarterly reforecasts
- Prepare monthly departmental expense reports including comparisons to budget and prior year
- Respond to senior management questions by researching and analyzing data
- Provide management reports and analysis as requested
- Assist on special projects that address key strategic issues at the Company
- Communicate issues to management both in writing and verbally
- Support system or process improvement projects
- Assist with merger integration projects, as needed
Required Qualifications:
- Bachelor's degree in Finance, Accounting, or other quantitative field required
- Minimum 1+ years of prior experience in Financial Planning & Analysis, Management Consulting, or Investment Banking, entertainment industry preferred but not required
- Strong analytical skills required
- Detailed oriented
- Excellent Excel and PowerPoint skills required
- Excellent written and verbal communication skills with the ability to collaborate with colleagues across the organization
- Ability to work in a fast-paced, deadline-driven environment
Preferred Qualifications:
- Experience with Python, SQL or VBA preferred
- Experience with data visualization tools such as Power BI is a plus
- Experience in using and managing ERP and Planning systems preferred
Required Skills: Financial Planning & Analysis, Financial modeling, Budgeting, Variance analysis, Python, SQL, VBA, Excel, PowerPoint, Data visualization, Power BI, ERP systems, Planning systems
Benefits: The unique and exciting opportunity to work at one of a leading global entertainment companies, Access to the tools, leadership, and resources you will need to create and drive a center of excellence, The opportunity to do the best work of your career, Work in an inclusive and diverse company culture, Competitive programs to support your well-being, Experience working in a collaborative environment with room to grow
Benefits
The unique and exciting opportunity to work at one of a leading global entertainment companies
Access to the tools, leadership, and resources you will need to create and drive a center of excellence
The opportunity to do the best work of your career
Work in an inclusive and diverse company culture
Competitive programs to support your well-being
Experience working in a collaborative environment with room to grow