Senior Analyst, Sales Planning

Please note that this role is based in Spain. In order to enable us to meet statutory and regulatory obligations of the Spanish immigration system you must have the appropriate immigration permission needed to work and reside in Spain for the duration of the employment._

Sony Pictures Entertainment is one of the industry’s leading content providers, producing and distributing worldwide in every genre and for every platform. In addition to managing one of the industry’s largest libraries of award-winning feature films, television shows and formats, SPE is home to a thriving global content business, operating a robust portfolio of wholly owned and joint-venture production companies across the U.S., Europe, Latin America, and Asia Pacific, as well as linear and digital channels around the world.

The TV Distribution Sales Planning team is responsible for setting and delivering our product distribution strategy, supporting negotiations and delivering the end-to-end sales process. This includes franchise planning, managing product availabilities and rights, negotiation and pricing support, contract review and execution, and budget and forecasting.

Our Madrid office has an opportunity for a Senior Analyst to join the Sales Planning and Operations team in TV Distribution, supporting the Iberia region The role in Sales Planning & Operations covers three key areas: Deal Management & Administration, Sales Analysis & Title Inventory Management, and Forecasting & Planning. The role will have a focus on key clients in Iberia and Analysis for the territory.

This position will mainly be supporting the Sales team based in the Madrid office and will need to ensure regular communications and provide expertise on the clients, deals, sales history, current forecasts. They will also support analysis, projects and best practice initiatives.

The job’s most important functions and responsibilities include:
**Deal Management & Administration**
- Set up and maintain deals in Sales & Rights Management systems; create Finance Release Packages and Materials Orders.
- Manage contractual obligations and ensure all deadlines are met as detailed in the contracts
- Draft simple contracts and amendments using standard templates, working with Legal team when necessary
- Develop an excellent working relationship with clients, provide sales support and attend external meetings as required. Liaise with clients on queries relating to deals e.g. billing discrepancies, servicing issues, US Network scheduling changes.
- Internal Relationships:

- Finance - to ensure accurate revenue recognition, customer checks, resolving invoicing/payment issues, and responding to audit queries
- DCS (Materials Fulfilment team) to ensure assets are delivered on time
- Ensure all Sales Planning Procedures are upheld by seeking appropriate reviews, and Approvals
- Actively support system UAT and engage in the process of system development and enhancements

**Sales Analysis & Title Inventory Management**
- Support negotiations of new deals with analysis, working with the Sales team, VP of Sales Planning and the Central Analysis team based in London
- Analyse reports for available products and identify appropriate titles that meet client and sales criteria, and maximise the sales potential
- Window Management - Maximise window opportunities for all product
- Establish Window Strategy for Franchise titles for local and Global Deals
- Utilise and engage in the development of new software tools e.g. Tableau

**Forecasting & Planning**
- Take ownership for ensuring all deals and data in RPM /S2F is accurate and up to date
- Maintain/update the annual and MRP (Mid Range Plan) forecasts in RPM, process changes in a timely manner and keep VP Sales Planning and Sales Teams informed of updates regularly
- Provide variance analysis on product, deals and/or market assumptions to support Sales in preparing the forecast
- Create summaries and commentary to Sales & Finance within prescribed deadlines
- Attend and contribute to regular forecast review meetings with Sales, Planning and Finance teams

**Qualifications and Experience**
- Educated to minimum undergraduate degree level
- Minimum of 3 years’ experience in a similar media environment
- Strong IT skills, in particular Excel (pivot tables, formulae, macros), PowerPoint and must be confident learning new systems
- Fluency in English is essential

**Competencies**
- Highly numerate with excellent attention to detail
- Problem Solving & Decision making - demonstrates an ability to address root causes of problems, identify alternatives and propose solutions.
- Able to use complex information to provide summaries with clear and meaningful insights
- Managing priorities and competing deadlines during busy periods
- Proactive and adaptable - anticipate needs in different situations and takes appropriate action with guidance and on own initiative
- Excellent communication skills
- Sony Pictures Entertainment is committed to equal