Data Engineer – Salesforce Data Migration

TechClub Inc; Chicago (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology solutions provider in Illinois seeks skilled Data Engineers for a large-scale Salesforce implementation. This role emphasizes data extraction, transformation, validation, and loading while ensuring quality and compliance. The ideal candidate will have strong experience with Azure Data Factory, Databricks, and SQL. Join a collaborative environment working closely with analysts and cross-functional teams to deliver reliable data assets on time.

Qualifications

• 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.

Responsibilities

• Extract legacy data from relational databases using Azure services.
• Design and implement source-to-target mappings aligned to Salesforce.
• Build and optimize data transformation pipelines using Databricks.

Skills

Data engineering and ETL/ELT development

Azure Data Factory

Azure Synapse

Databricks

SQL

Salesforce data models

Analytical skills

Communication skills

Job description

Overview

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.

Responsibilities

• 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