Senior Salesforce ETL/Data Migration Specialist to lead and support data migration, and transfo[...]

S I Systems; Toronto, Ottawa, Calgary, Vancouver, Edmonton; Remote; CAD 80,000 - 100,000; Full time

Job summary

A leading company is seeking a Senior Salesforce ETL/Data Migration Specialist to lead data migration initiatives. The ideal candidate will design and maintain ETL processes, collaborate on data requirements, and ensure data quality within Salesforce. This fully remote role offers the opportunity to work with a dynamic team on large-scale projects.

Qualifications

• 3+ years of experience in data integration and ETL processes.
• Experience with SQL Server management and Salesforce deployments.
• Ability to write complex SQL queries and troubleshoot data issues.

Responsibilities

• Design and develop ETL processes for data migration within Salesforce.
• Create and optimize SSIS packages for data flows.
• Monitor SQL queries for performance improvements.

Skills

ETL processes

SQL Server

SSIS

Salesforce CRM

Data migration

Problem-solving

Communication

Tools

Salesforce

dbAmp

T-SQL

Data Loader

Job description

Senior Salesforce ETL/Data Migration Specialist to lead and support data migration, and transformation initiatives within our clients Salesforce environment

Job Type: Contract

Positions to fill: 1

Start Date: Jul 28, 2025

Job End Date: Jan 31, 2026

Pay Rate: Hourly: Negotiable

Job ID: 146735

We are seeking a skilled Salesforce Data migration/ETL Specialist to lead and support data migration, and transformation initiatives within our Salesforce environment. The ideal candidate will have hands-on experience with SQL Server , SSIS packages , and ETL processes , as well as a strong understanding of Salesforce data models and best practices

Work Mode - 100% remote EST

Roles and Responsibilities:

• Design, develop, and maintain ETL processes for data migration and integration between Salesforce and external systems.
• Create and optimize SSIS (SQL Server Integration Services) packages to support robust and scalable data flows.
• Perform data cleansing, deduplication, validation, and transformation to ensure high-quality data in Salesforce.
• Collaborate with business analysts and Salesforce admins to understand data requirements and deliver solutions.
• Troubleshoot and resolve data issues related to synchronization, integrity, and quality.
• Monitor and tune SQL queries for performance improvement in large-scale data environments.
• Build Extract, Transform, Load (ETL) processes, leveraging tools like dbAmp, SQL Server, and SSIS packages, or custom scripts.
• Document data flows, architecture, and integration processes for compliance and knowledge sharing.
• Assist in the implementation of data governance and data security policies.
• Provide support for Salesforce reporting and analytics as needed.

Required Qualifications

• 3+ years of experience in data integration, ETL processes, and SQL Server database management.
• Proven experience working with SSIS , T-SQL , and Salesforce CRM .
• Solid understanding of Salesforce objects, schema, and API tools (e.g., Data Loader, Workbench).
• Experience with large-scale data migration projects and Salesforce deployments .
• Ability to write complex SQL queries, stored procedures, and performance-tuned data scripts.
• Excellent problem-solving and communication skills.

Preferred Qualifications

• Salesforce certifications (e.g., Salesforce Administrator, Platform App Builder, Data Architecture)..
• Familiarity with Agile or Scrum development methodologies.
• Knowledge of Apex, Visualforce, or Lightning components is a plus.