Summary: The Data Migration Specialist at Conexus MedStaff is responsible for overseeing the transfer of legacy data into a new Salesforce implementation, ensuring data accuracy and compliance throughout the process. This role involves collaborating with stakeholders to analyze, cleanse, and migrate data, while managing ETL processes and validating data post-migration. The position is critical for supporting recruitment and business development efforts within the organization. The contract is for 6 to 9 months, requiring a minimum of one day per week in the Skelmersdale office.

Key Responsibilities:

• Collaborate with business stakeholders to understand legacy data structures and map them to Salesforce object model.
• Identify gaps, duplicates, and inconsistencies in legacy data and design solutions to resolve them.
• Extract, transform, and load (ETL) data using tools like Salesforce Data Loader, MuleSoft, or third-party ETL tools.
• Perform data transformations to align with Salesforce field formats and data model requirements.
• Plan and execute migration sequencing to manage parent-child relationships and data dependencies.
• Import data into Salesforce using tools such as Data Loader, Bulk API, or Workbench.
• Conduct test migrations in sandbox environments to validate mappings and transformation rules.
• Perform rigorous validation checks to ensure data accuracy, completeness, and proper relationships.
• Document data mappings, transformation rules, validation criteria, and agreements with business stakeholders.
• Address and resolve migration issues, such as errors, missing records, or incorrect field mappings.

Key Skills:

• Strong understanding of Salesforce data models, relationships, and standard/custom objects.
• Hands-on experience with Salesforce tools such as Data Loader, Data Import Wizard, and Workbench.
• Experience using tools like MuleSoft, Informatica, Talend, Jitterbit, or similar for ETL processes.
• Advanced Excel skills (e.g., pivot tables, VLOOKUP, macros) for data analysis and preparation.
• SQL expertise for querying and transforming data.
• Strong attention to detail for pre- and post-migration validation, ensuring data accuracy and completeness.
• Experience with Python or PowerShell for custom data manipulation tasks (preferred).
• Excellent analytical and problem-solving skills.
• Strong communication and collaboration abilities to work with business stakeholders.
• Highly organized, with the ability to manage multiple migration cycles and meet deadlines.
• 3+ years of experience in data migration, ETL processes, and Salesforce platform usage.
• Proven track record of successfully managing end-to-end data migration projects.
• Familiarity with recruitment, sales, or business development processes is a plus.
• Salesforce Administrator and Salesforce Data Architect certifications (preferred).

Salary (Rate): 550

City: Skelmersdale

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: outside IR35

Seniority Level: Mid-Level

Industry: IT