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. As part of the central Sales Planning & Operations team, this 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 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: 1. TITLE ALLOCATIONS · 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. · Year-end volumes will require commitment and quick turnaround. 2. LINEAR RENEWALS REVENUE ANALYSIS · Maintain and further automate Excel based models to support revenue analysis for linear renewal deals. · Track and report on the progress of all requests received. · Review with Distribution Finance for approvals. · Year-end volumes will require commitment and quick turnaround. 3. 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. 4. QUEUE REPORT & ACCRUAL REPORTING – · 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. Confirm deal revenues subject to accruals. 5. BUDGET ASSUMPTIONS - · Coordinate the setup of new product features/TV assumptions provided by Finance, Product Strategy/Product Owners. · For each budget cycle, prepare variance reports highlighting assumption changes. · 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 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. · Experience using Tableau or other analytical tools a plus but not required.

The anticipated base salary for this position is $74,000 to $89,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 Entertainment is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status, age, sexual orientation, gender identity, or other protected characteristics. SPE will consider qualified applicants with arrest or conviction records in accordance with applicable law. To request an accommodation for purposes of participating in the hiring process, you may contact us at SPE_Accommodation_Assistance@spe.sony.com.