Data Migration & Cleanse Analyst (Salesforce)

Data Migration & Cleanse Analyst (Salesforce)

Global Partnerships

9 months Fixed Term Contract | Full Time

Office location: White City, London | Hybrid

Hiring range: £50,000 - £60,000

For more information please email TalkingCareers@itv.com

Your work matters to millions.

Shaping culture is in the DNA of ITV. So, it's not surprising that you'll find us in every home in the UK, our productions are famous all over the world and we're at the forefront of the digital streaming revolution.

When you join us, you enter a fun working environment. With opportunities to learn, to grow and make a real difference. Small enough that your impact's felt in the business, but big enough that your impact reaches millions of people.

Come develop your skills, change TV and the course of your career. Don't just watch it. Be part of it. Join ITV.

Your impact sends ripples.

The team

ITV Studios is one of the biggest global creators, producers and distributors of TV content in the world. Within ITV Studios is our Global Partnerships function, responsible for distributing over 90,000 active catalogue hours of film and television content to buyers such as broadcasters, streaming platforms, airlines and many more. As we continue to grow,

providing the sales and distribution teams with the right tools to succeed in a competitive environment is critical to powering the future value of our content

To meet the ever evolving needs of the business, and to ensure we remain a market leader in the distribution space, ITV Studios and Global Partnerships are working on a major programme of change, building out new systems and capabilities for Rights, Content Sales & Licensing

A key part of this programme is to consolidate and deliver a single unified Salesforce solution for ITV Global Partnerships fulfilling the foundational requirement to simplify and standardise the end-to-end GP sales processes and tools. Currently there are two different instances of Sales Cloud.

The role

The Data Migration & Cleanse Analyst will be responsible for identifying, overseeing and performing data cleanse activities for the migration of data from two legacy Salesforce instances to the new GP Salesforce system. As part of the role you will be responsible for defining the objects, fields, and records to be migrated, setting target state for future GP Salesforce data models and sales processes, and ensuring the critical data required for Go-Live Day 1 is identified and agreed upon in collaboration with business teams (e.g Sales, Finance, Marketing). The role also involves managing data export, assessing business needs for data migration, and ensuring that only necessary data not available from other systems is migrated. Additionally, the candidate will assure alignment with the Rightsline data dictionary, assess data ownership for GP Salesforce, and consider the transition states between GP and Rightsline Go-Live targets.

The role would be ideally suited to someone equally comfortable working across both business and technical domains. A core responsibility of the position will be to analyse, understand and organise large sets of media industry data. Additionally, experience or involvement in previous data migration programmes would be beneficial to the individual taking on this role. The role will entail but not be limited to:

• Support the Programme Team and Business Sponsor with decisions on the target state for GP Salesforce data models and sales processes.
• Work closely with the GP Salesforce implementation team and the Business Sponsor to understand the scope and ambition of the GP Salesforce implementation transformation programme at ITV and, specifically, the importance of the data cleanse and migration workstream within it.
• Define and agree critical data required for GP Salesforce by Go-Live Day 1.
• Engage with business teams to define key objects/records, prioritise them (critical to low use), and log known issues in data.
• Clearly define objects, fields, records to be migrated to the new GP Salesforce.
• Clearly define the extent of data cleansing required facilitate the data migration
• Track, perform and coordinate cleansing activities, ensuring cleansing of migration critical activities are prioritised and completed on time.
• Be the central person for facilitating conversations across all business areas (Sales, Rights In, Finance and Catalogue), and raising risks/issues to the Salesforce Programme team where appropriate.
• Engage with business teams such as Sales, Finance, and Marketing to identify that needs are met.
• Export data from legacy Sales Cloud instances into CSV files while ensuring data integrity and completeness.
• Identify and exclude redundant legacy data from migration.
• Assess where required data will be mastered. If data will be mastered in GP Salesforce through integration, data cleanse may not be needed
• Validate data migrated into the new GP Salesforce, support error handling and resolution (including source data cleansing, recreate files for data reloads) and provide sign-off report for Business Sponsor approval
• Ensure alignment overall across the wider Sales & Licensing programme and with the Rightsline Data Migration Strategy in supporting the business and Salesforce to Rightsline workflows and identifying interdependencies. Consider data migration scope in relation to transition states for GP Salesforce and Rightsline Go-Live.
• Provide regular updates to Programme Teams and Business stakeholders on progress of the data cleanse and migration activities, including identifying and tracking any risks and dependencies to senior stakeholders

Skills you'll need (minimum criteria)

• Demonstrable experience driving and coordinating data migration and data cleansing activity in at least 1 project
• Demonstrable experience of working in Sales and Licensing or other Salesforce migration projects within the Media and Entertainment sector
• Self-starter, able to prioritise and manage tasks and deadlines across multiple projects concurrently.
• Hands on experience and expertise working with Salesforce solutions
• Experience of working on data analysis and migration programmes

The following may also be beneficial

• Experience with or knowledge of Rightsline

Other things we're looking for (key criteria)

• Strong literacy, numeracy and IT skills (Experience of using google docs/google suite)
• Excellent attention to detail
• Strong communication skills
• Methodical and detailed
• Logical approach to problem solving
• Ability to identify when a problem may require escalation
• Polite and constructive
• Maintain high standards of work and professionalism
• Personal determination to increase knowledge and competencies
• Team working skills
• Positive can do attitude

ITV is for everyone.

ITV strongly encourages applications for this role from disabled people. As a Disability Confident Leader, if you meet the minimum criteria for a role and you have declared that you are disabled, we'll guarantee to take you to the next stage* (minimum criteria above).

We're happy to discuss any support/personalisation you may need during our application and selection process as part of our reasonable adjustments. Drop us a line if you require anything at talkingcareers@itv.com.

Find out more about applying with a disability.

* There may be a few exceptions where we are not able to take all eligible candidates to the next stage due to the volume of applications.

Because those who make an impact deserve to be rewarded for it.

ITV offers some great rewards and benefits including

• Flexible working with a range of options to suit everyone
• Generous holiday allowance, plus you can buy more
• Annual bonus opportunity
• Competitive pension contribution
• Save as you earn - with an opportunity to buy ITV shares
• Wellbeing and volunteering days plus a wide range of opportunities to help you live a balanced and healthy life

More about our benefits

Closing date: Sunday 16th February 2025

"Please note, on occasion we may receive a very large volume of applications which means applications for a role may close earlier than the referenced closing date. We'd encourage you to apply as soon as possible if interested."]]>