Salesforce Data Migration Architect

TechByte Talent Ltd; United Kingdom; Remote; GBP 92,000 - 120,000; Full time

Job summary

TechByte Talent Ltd is seeking a hands-on contractor to own a Salesforce data migration data workstream end to end. You’ll use Microsoft SQL Server as the staging and transformation layer, handling profiling, mapping and production cutover.

The role requires delivering complex data migrations between Salesforce orgs, maintaining data quality, referential integrity and GDPR compliance, with a focus on robust error handling and repeatable runbooks. Remote UK-based.

Qualifications

• Proven hands-on delivery of Salesforce-to-Salesforce data migrations.
• Experience with production cutovers and data validation checks.
• Strong knowledge of Salesforce data model and object relationships.
• Experience with GDPR and data governance.
• Excellent communication with business stakeholders.
• Ability to work independently in a fast-paced environment.

Responsibilities

• Profile source Salesforce data across objects and dependencies.
• Design and maintain SQL Server staging schemas.
• Develop and test T-SQL for ETL rules.
• Migrate parent/child relationships while preserving referential integrity.
• Extract and load using Data Loader, Bulk API, SSIS, ADF, or dbAmp.
• Plan migration cycles and manage production cutover.
• Create reconciliation checks and sign-off evidence.
• Identify and mitigate migration risks (API limits, data volumes).
• Deliver handover pack with mapping specs and runbooks.

Skills

Salesforce data migration

Data profiling and cleansing

Data mapping and reconciliation

GDPR compliance

Stakeholder communication

Independent delivery

Education

Salesforce Data Migration Certification

GDPR/Data Protection Certification

SQL Server Certification

Tools

Data Loader

Bulk API

SSIS

Azure Data Factory

Informatica

Talend

Boomi

dbAmp

Power BI

Job description

• Remote, must be UK based
• Up to £575 Outside IR35

Our client, a well-established organisation, is moving data from one Salesforce org to another and needs a hands-on contractor to own the migration data workstream end to end. You’ll use Microsoft SQL Server as the staging and transformation layer, taking the work from profiling and mapping through to production cutover.

The technical scope

• Profile source Salesforce data across standard and custom objects: volumes, quality, duplication and dependencies
• Produce object- and field-level mapping documents covering data types, picklists, record types, required fields and validation rules
• Design and maintain SQL Server staging databases and schemas for extracting, cleansing, transforming and staging data
• Write, optimise and test T-SQL (stored procedures, views, ETL logic) to implement transformation and cleansing rules
• Migrate parent/child relationships and record ownership while preserving referential integrity, using source-to-target ID cross-referencing and the correct load order
• Extract and load using tools such as Data Loader, Bulk API, SSIS, Azure Data Factory or dbAmp, with robust error handling and re-runs
• Plan and run multiple migration cycles (dev, test/UAT and production dress rehearsals) and execute the production cutover, including rollback planning
• Design and run reconciliation checks (record counts, field-level comparisons, sampling) and produce sign-off evidence
• Manage migration risks: data volume and API limits, trigger and flow impacts, and sharing/ownership considerations
• Handle personal data in line with GDPR and data governance standards
• Deliver a handover pack: mapping specs, scripts, runbooks and lessons learned

Architect-level candidates will also shape the overall migration approach and standards.

Essential skills

• Proven, hands-on delivery of data migrations between Salesforce orgs, or from other systems into Salesforce, ideally including at least one full production cutover
• Strong knowledge of the Salesforce data model: standard objects (Account, Contact, Lead, Opportunity, Case, User), custom objects, lookup and master-detail relationships, record types and field types
• Strong SQL Server and T-SQL skills: stored procedures, joins across large data sets, performance tuning and data quality checks
• Experience with Salesforce extraction and loading tools (Data Loader, Bulk API, SSIS, ADF, Informatica, Talend, Boomi, dbAmp or similar)
• Solid experience in data profiling, cleansing, deduplication and mapping, with a methodical approach to reconciliation and audit trails
• Understanding of ownership and sharing, validation rules, triggers/flows, API limits and managing record IDs across orgs
• Awareness of GDPR and secure handling of customer data
• Excellent communication skills, able to explain technical data concepts to business stakeholders and work independently in a fast-paced environment
• Salesforce certifications (Data Architecture and Management Designer, Administrator, Platform App Builder)
• Multi-org consolidation or org merge/split experience
• Sales Cloud and/or Service Cloud experience, ideally in a customer-facing retail or automotive-type environment
• Migration of attachments, files and content (ContentVersion, ContentDocumentLink)
• Power BI or similar for reconciliation and progress reporting