Sr. Analyst – Sales Planning Distribution Operations
| Company | Sony Pictures Entertainment |
|---|---|
| Location | Culver City, CA, USA |
| Salary | $74000 – $89000 |
| Type | Full-Time |
| Degrees | |
| Experience Level | Mid Level, Senior |
Requirements
- Minimum of 3-5 year’s work experience; prior experience in TV Distribution strongly preferred, international and financial experience a plus.
- Strong analytical and problem-solving skills.
- Highly proficient in Excel.
- Ability to monitor and correct one’s mistakes.
- Hands on and an obsessive attention to detail.
- Comfortable using and proposing technology to improve processes.
- Flexibility, ability to work under changing priorities/and or tight timelines.
- Ability to prioritize multiple important projects.
- Proficient at establishing relationships with cross-functional peers.
- Excellent verbal and written communication skills.
- Proactive, positive team-player.
Responsibilities
- Utilize Excel based allocation models to analyze and assess proper allocation of license fees based on contract terms and market value.
- Track and report on the progress of all allocation requests received.
- Evaluate opportunities to streamline the allocation process.
- Maintain and further automate Excel based models to support revenue analysis for linear renewal deals.
- Review with Distribution Finance for approvals.
- Identify new deals subject to quarterly financial disclosure reporting requirements.
- Compile reporting necessary for fair market value assessment on major deals.
- Work with regions to prepare and compile compliance audit data, track and respond to external auditor inquiries in a timely manner.
- Monitor upcoming deals via internal reporting during month end.
- Coordinate between Finance and the international Sales Planning leads to ensure all deal revenue is fully approved in system by monthly system close.
- Coordinate the setup of new product features/TV assumptions provided by Finance, Product Strategy/Product Owners.
- Prepare variance reports highlighting assumption changes.
Preferred Qualifications
- Experience using Tableau or other analytical tools a plus but not required.