Data Cleansing & CRM Migration Officer

Citizens Online; Greater London; Hybrid; GBP 25,000 - 30,000; Part time

Benefits offered by this job

Hybrid working

Job summary

Anonymous Membership Organisation in London is seeking a Data Cleansing & CRM Migration Officer for a temporary 3-month assignment, with hybrid working (office-based induction and four days remote per week). You will prepare ~3,000 museum records for migration from Dynamics to Salesforce, ensuring data is complete, accurate, and correctly structured.

Responsibilities include cleansing records, updating critical fields, validating sources, and building CRM hierarchies while maintaining high

Qualifications

• Experience with large datasets and databases.
• Advanced Excel skills: Pivot Tables and VLOOKUP.
• Excellent attention to detail and data accuracy.
• Experience in data cleansing, CRM administration or data migration.
• Familiarity with Dynamics and Salesforce is desirable.

Responsibilities

• Review, cleanse and verify about 3,000 museum records.
• Update addresses, websites, pricing, ownership, and contacts.
• Aggregate data from multiple sources and spreadsheets.
• Analyze large datasets to identify inaccuracies and gaps.
• Use Excel to support data review and analysis (Pivot Tables, VLOOKUP).
• Assist in creating organisational hierarchies in the new CRM.
• Prepare records for migration to Salesforce.
• Maintain high accuracy through detailed data checking.
• Collaborate with colleagues to meet project deadlines.

Skills

Large datasets

Excel Pivot Tables

VLOOKUPs

Attention to detail

Data cleansing

CRM administration

Data migration

Organisational skills

Dynamics Salesforce

Tools

Salesforce

Dynamics 365

Job description

Data Cleansing & CRM Migration Officer

Ready to play a key role in an important digital transformation project that will support museums across the UK?

This is an exciting opportunity to join a purpose-led membership organisation within the museums and heritage sector. As Data Cleansing & CRM Migration Officer, you will contribute to a major CRM migration project, helping to ensure that thousands of organisational records are accurate, accessible, and ready for transition to a new platform.

If you enjoy working with large datasets, solving problems, carrying out detailed research, and delivering high-quality work with exceptional attention to detail, this could be an excellent opportunity to make a tangible impact.

Role: Data Cleansing & CRM MigrationOfficer

Organisation: Membership Organisation (Anonymous)

Salary: £18+ per hour

Location: London / Home Working

Working Pattern: Hybrid, with 4 days remote working per week following an initial office-based induction and weekly office attendance on Tuesdays

Contract Type: Temporary

Duration: Initial 3-month contract (October to January) with potential for extension subject to project requirements

About the Role:

You will play a central role in preparing organisational data for migration from Dynamics to Salesforce. Working across approximately 3,000 museum records, you will help ensure data is complete, accurate, and correctly structured ahead of a significant CRM implementation.

This is an excellent opportunity to gain valuable experience in data quality management, CRM migration, and organisational data architecture while supporting a sector-wide digital transformation initiative.

Responsibilities:

• Review, research, and cleanse approximately 3,000 museum records
• Verify and update key organisational information, including addresses, websites, admissions pricing, ownership structures, and contact details
• Collect, collate, and validate data from multiple sources and spreadsheets
• Analyse large datasets and identify inaccuracies, inconsistencies, and missing information
• Use Excel functions, including Pivot Tables and VLOOKUPs, to support data review and analysis
• Support the creation of organisational hierarchies within a new CRM system
• Prepare and validate records for migration to Salesforce
• Maintain exceptional levels of accuracy through detailed data checking
• Work closely with colleagues to ensure project objectives and deadlines are achieved

About You We are looking for someone who has:

• Experience working with large datasets and databases
• Strong Excel skills, including Pivot Tables, VLOOKUPs, and data manipulation
• Excellent attention to detail and commitment to data accuracy
• Confidence carrying out detailed online research and data verification
• Experience in data cleansing, CRM administration, data migration, or database management
• Strong organisational skills and the ability to manage a high volume of work independently
• Experience with Dynamics and/or Salesforce (desirable)
• Knowledge of the museums, heritage, arts, or membership sectors (beneficial but not essential)

Why Join?

• Contribute to a significant CRM transformation project
• Support an organisation with a meaningful mission and sector-wide impact
• Benefit from flexible hybrid working arrangements
• Gain valuable experience in large-scale data migration and CRM implementation
• Work within a collaborative and supportive team environment
• Opportunity for contract extension depending on project requirements