Senior Data Migration Analyst — Salesforce & SQL Expert

Keyloop

Reading

On-site

GBP 70,000 - 110,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Keyloop is seeking an experienced contractor to lead the analysis, design and execution of a data migration between Salesforce orgs, using SQL Server as the staging/ transformation layer. You will own end-to-end data workstream: profiling, mapping, loading, reconciliation and cutover support.

The role can be filled at Data Analyst or Data Architect level; architect-level candidates will shape migration approach and standards.

Qualifications

  • Hands-on experience delivering data migrations between Salesforce orgs or into Salesforce.
  • Strong knowledge of Salesforce data model, standard and custom objects, relationships, and field types.
  • Strong SQL Server / T‑SQL skills, with data cleansing and validation checks.

Responsibilities

  • Define and document data migration approach, scope and sequencing, including cutover and rollback considerations.
  • Profile source Salesforce data to assess volumes, quality, duplication and dependencies.
  • Create object/field mappings between source and target orgs, covering data types and validation rules.
  • Design and maintain SQL Server staging databases and schemas for extraction, cleansing and transformation.
  • Develop and test T-SQL to implement transformation and data cleansing rules.
  • Preserve referential integrity during parent/child relationships and record ownership changes.

Skills

Salesforce data migrations
Data modelling
SQL & T‑SQL
Data profiling
Stakeholder communication

Tools

SQL Server
SSIS
Azure Data Factory
Data Loader/Bulk API

Job description

Keyloop is seeking an experienced contractor to lead the analysis, design and execution of a data migration between Salesforce orgs, using SQL Server as the staging/ transformation layer. You will own end-to-end data workstream: profiling, mapping, loading, reconciliation and cutover support.

The role can be filled at Data Analyst or Data Architect level; architect-level candidates will shape migration approach and standards.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Interim Data Migration Analyst (Salesforce, SQL)
Interim Data Migration Analyst (Salesforce, SQL)

Go Fractional • Reading

Hybrid
GBP 83,000 - 138,000
Hybrid work model
Hybrid Data Migration Analyst: Salesforce & SQL
Hybrid Data Migration Analyst: Salesforce & SQL

Go Fractional • Reading

Hybrid
GBP 83,000 - 138,000
Hybrid work model
Salesforce Data Migration Specialist
Salesforce Data Migration Specialist

Advanced Resource Managers Ltd • United Kingdom

Remote
GBP 90,000 - 130,000
Data Migration Analyst (Salesforce, SQL) - Fixed Term Contract
Data Migration Analyst (Salesforce, SQL) - Fixed Term Contract

Keyloop • Reading

On-site
GBP 70,000 - 110,000
Remote Salesforce Data Migration Lead
Remote Salesforce Data Migration Lead

Advanced Resource Managers Ltd • United Kingdom

Remote
GBP 90,000 - 130,000
Senior Data Analyst - Data Quality & Migration Lead
Senior Data Analyst - Data Quality & Migration Lead

Target • Cardiff

Hybrid
GBP 43,000 - 53,000
30 days holiday entitlement
Pension scheme (Employer matched)
Employee Discount Scheme
+4
Hybrid Senior Data Analyst: Data Migration & Quality
Hybrid Senior Data Analyst: Data Migration & Quality

Netcompany Group A/S • Greater London

Hybrid
GBP 60,000 - 80,000
Hybrid working
Private medical insurance
Pension & Life Assurance
+3
Senior Data Engineer
Senior Data Engineer

Intellias • Greater London

On-site
GBP 45,000 - 85,000
Lead Data Engineer - Azure PostgreSQL & Migration Expert
Lead Data Engineer - Azure PostgreSQL & Migration Expert

Scrumconnect • Newcastle upon Tyne

On-site
GBP 75,000 - 110,000
Senior Migration Delivery Lead, Marketing Cloud
Senior Migration Delivery Lead, Marketing Cloud

Salesforce, Inc. • Greater London

On-site
GBP 90,000 - 120,000