At a Glance
- Tasks: Support sales operations with reporting, data management, and system improvements.
- Company: Dynamic media company located in White City, London.
- Benefits: Flexible work schedule, competitive salary, and opportunities for professional growth.
- Other info: Collaborative culture with a focus on innovation and career development.
- Why this job: Join a fast-paced environment and make a real impact on sales processes.
- Qualifications: Proficiency in Excel, SQL, and data visualisation tools like Tableau.
The predicted salary is between 40000 - 50000 £ per year.
Workplace: White City, London - 3 days a week in the office
The role involves working with the Director of Sales Operations and across all Global Partnership teams on Reporting to optimise the end to end Sales Process and drive revenue generating activity through our ecosystem of business applications, tools and processes. Key stakeholders for engagement include Global Partnerships Technology and Global Partnerships Data & Insights teams.
Main responsibilities include:
- Providing regular and ad hoc operational reporting for business teams and executives on primary metrics.
- Recommending and actioning areas of data clean up and management across primary business applications to improve speed and accuracy of operational reporting.
- Supporting data quality testing during mass data uploads and new system launches.
- Acting as a Global Partnerships systems superuser, crafting best practices and training new personnel on system improvements.
- Salesforce Reporting to support non-Salesforce users, providing critical support functions in Rights Management, Content Operations teams and other business teams.
- Aligning Content Hub and Licensing System with Weekly Uploads of Rights Summary data, working with Catalogue Manager and Rights Management teams.
- Managing the Expiring Licenses report refresh for Global Sales teams for Finished Tape to track renewal/extensions/new Sales opportunities and training all new Sales and Admin starters on this report.
- Providing reporting support and expertise for Data Cleanse activities across all primary applications of Salesforce, Licensing system and Content Hub.
- Managing Google Cloud (GCP) query for development, running, and scheduling of queries to support cross-functional teams with ad-hoc data requests and data mapping.
- Executing In-House Avail Tool updates weekly from GCP Data Warehouse and Content Hub, providing dedicated support to Sales Admins regarding Sales Histories and Licence Clash Availability.
- Supporting project transformations, including User Acceptance Testing (UAT), data migration, and comprehensive data cleanse activities.
- Providing AI tools support, including training of Sales teams on new AI Agent launches and ensuring rigorous data validation.
- Supporting Business Application Introduction training on key tools as required.
Skills you’ll need (minimum criteria):
- Mastery in setting priorities, planning, stakeholder and time management.
- Advanced proficiency in spreadsheet modelling (MS Excel / Google Sheets).
- Data Visualisation skills with experience in Tableau.
- Database and data manipulation experience in extracting, joining and aggregating datasets.
- Previous experience in a fast-paced media environment.
- SQL expertise, including creating and editing SQL Queries, with experience using Google Cloud Platform preferred.
- Flexible work attitude and willingness to take on duties beyond those specified in the job description.
Other things we’re looking for (key criteria):
- Advanced skills across Excel, Tableau and SQL.
- Result-oriented and tenacious.
- Flexible and able to multitask across business priorities.
Sales Operations Analyst employer: ITV Studios
At our White City, London office, we pride ourselves on fostering a dynamic and inclusive work culture that empowers our employees to thrive. As a Sales Operations Analyst, you will benefit from comprehensive training opportunities, collaborative teamwork, and the chance to engage with cutting-edge technology in a fast-paced media environment. With a focus on employee growth and a commitment to innovation, we offer a rewarding career path where your contributions directly impact our global partnerships and revenue generation.
StudySmarter Expert Advice🤫
We think this is how you could land Sales Operations Analyst
✨Tip Number 1
Network like a pro! Reach out to people in your industry on LinkedIn or at events. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Prepare for interviews by researching the company and its culture. We want you to show how you can fit into their team and contribute to their goals, especially in Sales Operations.
✨Tip Number 3
Practice your data skills! Brush up on Excel, SQL, and Tableau before interviews. Being able to demonstrate your expertise will set you apart from other candidates.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Sales Operations Analyst
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the Sales Operations Analyst role. Highlight your experience with Salesforce, Excel, and SQL, and don’t forget to mention any relevant projects you've worked on that align with our needs.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to tell us why you're passionate about this role and how your skills can help us optimise our sales processes. Keep it engaging and personal!
Show Off Your Data Skills:Since data is at the heart of what we do, make sure to showcase your data visualisation and manipulation skills. Mention specific tools like Tableau and Google Cloud Platform to demonstrate your expertise.
Apply Through Our Website:We love it when you apply directly through our website! It helps us keep track of your application and ensures you get all the updates. Plus, it shows you're keen to join the StudySmarter team!
How to prepare for a job interview at ITV Studios
✨Know Your Tools Inside Out
Make sure you’re well-versed in the tools mentioned in the job description, especially Salesforce, Excel, and SQL. Brush up on your skills with pivot tables, macros, and data visualisation techniques using Tableau. Being able to demonstrate your proficiency will show that you're ready to hit the ground running.
✨Prepare for Scenario-Based Questions
Expect questions that ask how you would handle specific situations related to sales operations and data management. Think of examples from your past experience where you optimised processes or improved reporting accuracy. This will help you showcase your problem-solving skills and adaptability.
✨Understand the Business Context
Familiarise yourself with the company’s ecosystem and how the Sales Operations Analyst role fits into it. Research their Global Partnerships and how they leverage data insights. This knowledge will allow you to speak confidently about how you can contribute to their goals.
✨Show Your Flexibility and Team Spirit
The job requires a flexible attitude and the ability to multitask. Be prepared to discuss times when you’ve taken on additional responsibilities or worked collaboratively across teams. Highlighting your willingness to adapt and support others will resonate well with the interviewers.
