Analyst, Transactional Business Planning & Insights

Please note that this role is based in the United Kingdom. To enable us to meet the statutory and regulatory obligations of the United Kingdom immigration system, you must have the appropriate immigration permission needed to work and reside in the United Kingdom for the duration of the employment.

The EMEA Transactional Business Planning & Insights Analyst plays an important role in supporting data-driven decision-making across Sony Pictures' International Home Entertainment business.

Working alongside the Senior Managers, the Analyst provides analytical support through the preparation of reports, dashboards, forecasting models and commercial insights that enable informed business decisions across EMEA.

This role is ideally suited to an inquisitive and technically capable analyst who enjoys working with large datasets, identifying trends and solving business problems through data. The successful candidate will help maintain the reporting and analytical infrastructure that supports Business Planning & Insights while continually looking for opportunities to improve reporting, automate processes and uncover new commercial insights.

Reporting to the Senior Manager, EMEA Transactional Business Planning & Insights, the Analyst will work closely with Commercial, Finance, Marketing, Research and Global colleagues to ensure accurate, timely and insightful analysis that supports forecasting, planning and retailer engagement.

Whilst knowledge of the Home Entertainment industry is beneficial, the role is primarily focused on analytical capability, technical skills and a proactive approach to problem solving. Industry knowledge and forecasting methodologies can be developed through experience within the role.

Key Responsibilities

Reporting & Analytics

• Produce regular and ad-hoc reports that support Commercial, Finance and Business Planning teams across EMEA.
• Build and maintain dashboards using Tableau, Power BI or similar reporting tools to provide clear and actionable business insights.
• Analyse large datasets to identify trends, opportunities, anomalies and emerging business issues.
• Develop reporting solutions that improve visibility of business performance and support data-driven decision-making.
• Ensure reporting outputs are accurate, timely and presented in a clear and meaningful way.

Data Management & Business Intelligence

• Maintain and validate datasets used across Business Planning & Insights activities, ensuring high levels of accuracy and consistency.
• Support the management of reporting databases and analytical models across multiple business areas.
• Perform regular data quality checks and investigate anomalies where identified.
• Assist in integrating multiple internal and external data sources to create meaningful commercial insights.
• Contribute to maintaining a single source of truth for Business Planning & Insights reporting.

Forecasting & Commercial Support

• Support the preparation and maintenance of forecasting models for New Release and Catalogue planning.
• Produce financial reports and variance analysis to support business planning activities.
• Assist with the preparation of analytical material for retailer meetings, Joint Business Planning sessions and commercial reviews.
• Provide analytical support for pricing, promotions and title performance evaluations.
• Support budget and forecasting submissions through accurate data preparation and model maintenance.

Process Improvement & Automation

• Proactively identify opportunities to improve reporting processes through automation and simplification.
• Develop more efficient reporting solutions using Excel, Tableau, SQL, Power BI or other analytical tools.
• Explore emerging technologies, including AI-assisted analytical tools, that could improve efficiency and insight generation.
• Support continuous improvement initiatives across reporting, forecasting and analytical processes.

Collaboration & Global Alignment

• Build effective relationships across Commercial, Finance, Marketing, Research and Global teams.
• Support Senior Managers by preparing analysis and presentations for business reviews and customer meetings.
• Share insights and analytical findings clearly with colleagues across the business.
• Contribute to a collaborative culture focused on continuous improvement and data-driven decision-making.

Knowledge

• Around 1-3 years' experience in an analytical, reporting, business intelligence or commercial analysis role.
• Experience working with large datasets and producing meaningful business insights.
• Exposure to business reporting, dashboards or performance analysis within a commercial environment.
• Solid grounding in financial planning, forecasting, and performance analytics.
• Experience in digital distribution, home entertainment, or global media strategy, with a strong understanding of the digital transactional home entertainment business, including commercial models and market drivers desired but not essential.
• Experience working across multiple international territories, with exposure to EMEA markets would be beneficial.

Skills

• Highly proficient in Excel and PowerPoint, with the ability to translate data into actionable insights.
• Experience using Tableau, Power BI or similar Business Intelligence tools.
• Working knowledge of SQL for querying and manipulating data.
• Experience using reporting databases and data visualisation tools.
• Experience with Python, Alteryx or AI-enabled analytical tools would be advantageous but not essential.
• Excellent written and verbal communication, capable of presenting findings to senior stakeholders with clarity and impact.

Core Competencies

• Analytical Thinking - Able to interrogate complex datasets and identify meaningful commercial insights.
• Curiosity - Naturally inquisitive, enjoys asking questions and investigating the reasons behind business performance.
• Problem Solving - Able to identify opportunities for improvement and develop practical solutions.
• Learning Agility - Quickly develops knowledge of new systems, industries and commercial models. An enthusiasm for learning the commercial drivers of Sony Pictures' International Home Entertainment business.
• Attention to Detail - Produces consistently accurate work while understanding the wider commercial context.
• Communication - Able to communicate analytical findings clearly to both technical and non-technical audiences.
• Collaboration - Works effectively across multiple teams and builds positive working relationships.

How we take care of you:

• Competitive salary, with annual bonus eligibility.
• A choice of comprehensive health plan options that fit your lifestyle, including private medical insurance.
• Rest and recharge during a week off during the winter holidays, in addition to the 25 days of paid annual leave.
• Participate in extensive learning & development opportunities at all levels, including curated instructor-led classes and high-impact online resources.
• Build your community by joining our Employee Business Resource Groups, and/or Sony Pictures Action – our racial equity and inclusion strategy.
• Access to an employee online store filled with a variety of discounted Sony products.
• Watch the newest movies and TV shows at our exclusive employee screenings at work.
• Entitlement to apply for an interest-free season ticket loan.
• Automatic enrolment in the Company’s Pension Plan
• Free counselling and advisory service.
• You will be automatically enrolled in the Company’s Life Insurance and Group Income Protection Plans, subject to any applicable service requirements.
• The opportunity to attend various social events in our state-of-the-art offices in Paddington.

In addition to the above, we have a range of other optional discounted benefits that are reviewed regularly (e.g., gym memberships, travel insurance, activity passes, car leasing, experience days and many more!)

If you require any reasonable adjustments with any part of the recruitment process, including the application or interview process, please contact us at [email protected]. Please put Reasonable Adjustment Request in the subject line of the email.

Sony Pictures does not allow audio recording, video recording or use of AI note-taking tools during interviews. Candidates requiring these tools as an accommodation during an interview should submit a reasonable adjustment request at the point they are invited to interview.

Sony Pictures Entertainment is committed to equal opportunity in all its employment practices, policies and procedures. No worker or potential worker will therefore receive less favourable treatment due to their race, age, creed, sexual orientation, colour, nationality, ethnic origin, disability, religion, gender, marital status or Trade Union membership (if applicable).