Salesforce Data Migration Data Engineer
Role summary
Seeking a hands-on Data Engineer for a large-scale Salesforce implementation focused on complex legacy data migration. Responsibilities include extracting, transforming, validating, and loading data into Salesforce platforms (Sales Cloud, Service Cloud, Experience Cloud, SFMC) using Azure services (ADF, Synapse) and Databricks. The role requires strong SQL skills, understanding of Salesforce data models, and experience with data quality, reconciliation, and testing. Collaboration with business analysts and Salesforce teams is key to ensuring reliable, production-ready data assets and timely delivery aligned with program milestones.
We are seeking hands‑on Data Engineers to support a large‑scale Salesforce implementation involving complex legacy data migration. The role focuses on extracting, transforming, validating, and loading data into Salesforce platforms while ensuring data quality, reconciliation, and adherence to program standards. The Data Engineer will work closely with business analysts, Salesforce teams, and cross‑functional workstreams to deliver reliable, production‑ready data assets.
Key Responsibilities: Data Engineering & Migration
Extract legacy data from relational databases (e.g., SQL Server) using Azure‑based services such as Azure Data Factory and Azure Synapse
Design and implement source‑to‑target mappings aligned to Salesforce data models
Build and optimize data transformation pipelines using Databricks
Load, validate, and reconcile data across Salesforce platforms including Sales Cloud, Service Cloud, Experience Cloud, and Salesforce Marketing Cloud (SFMC)
Data Quality & Testing
Perform data validation, reconciliation, and defect analysis
Conduct unit testing and support User Acceptance Testing (UAT)
Identify data gaps and work with stakeholders to resolve inconsistencies
Delivery & Collaboration
Manage work items, defects, and priorities using Jira
Collaborate with business analysts, Salesforce developers, and program teams across multiple workstreams
Contribute to reusable migration frameworks, standards, and playbooks
Ensure timely delivery aligned to program milestones and governance processes
Skills & Experience: Technical Skills
Strong experience in data engineering and ETL/ELT development
Hands‑on experience with Azure Data Factory, Azure Synapse, and Databricks
Experience loading data into Salesforce platforms
Solid understanding of Salesforce data models
Strong SQL skills and experience working with large, complex datasets
Prior experience in Salesforce data migration projects
Strong analytical and problem‑solving skills
Excellent communication and documentation skills
Ability to work across multiple workstreams and collaborate with distributed teams
Preferred Qualifications
Experience in enterprise‑scale CRM or Salesforce transformation programs
Familiarity with data quality, reconciliation, and migration best practices
Experience working in Agile delivery models