Sr. Analyst, Sales Planning Distribution Operations

Job Description

Sr. Analyst, Sales Planning Distribution Operations

The Team
The Global Distribution group is a multi-billion-dollar division within Sony Pictures Entertainment focused on licensing features, series and formats to linear and digital platforms worldwide. The role will work with Sales Planners around the world.

The Role
The role is responsible for supporting Sales and Sales Planning by ensuring that deal fees are allocated fairly across titles, revenue processes are being followed and SOX compliant, and all necessary product information is available to support sales opportunities. The role requires a hands-on, detail-oriented individual who is financially & technically savvy and proficient in excel. The areas of responsibility include the following:

TITLE ALLOCATIONS -
• Utilize Excel based allocation models to determine proper allocation of license fees based on contract terms and market value. Year-end volumes will require prioritization, commitment, and quick turnaround
• Track and report on allocations received and in process
• Evaluate opportunities to create efficiencies with the allocation process

SOX CONTROLS & COMPLIANCE SUPPORT –
• Maintain knowledge of revenue recognition rules and SOX control deadlines
• 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
• Provide timely feedback on delays or challenges for all workflows
• Maintain new TV season pick-up dates and related email communications

QUEUE REPORT & ACCRUAL REPORTING –
• Monitor upcoming deals which are expected to close by 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
• Confirm deal revenues subject to accruals through timely communications with international Sales Planning leads and Finance

BUDGET ASSUMPTIONS -
• Setup new product features/TV assumptions provided by Finance, Product Strategy/Product Owners as required for each forecast cycle
• For each budget cycle, prepare variance reports highlighting assumption changes between each forecast cycle
• Ensure product information is updated as assumptions change throughout the year

Qualifications:
• Minimum of 3-5 year's work experience; prior experience in TV Distribution strongly preferred, international and financial experience a plus
• Strong analytical skills and ability to problem solve
• 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
• Experience using Tableau or other analytical tools a plus but not required

#salesplanning

The anticipated base salary for this position is $72,000 to $78,000. This role may also qualify for annual incentive and/or comprehensive benefits. The actual base salary offered will depend on a variety of factors, including without limitation, the qualifications of the individual applicant for the position, years of relevant experience, level of education attained, certifications or other professional licenses held, and if applicable, the location of the position.

* Sony Pictures - CA - Culver City Area & Studios

Jobcode: Reference SBJ-gk8260-18-222-125-171-42 in your application.