Salesforce & SQL Data Migration Consultant

About 108 ideaspace

At 108 ideaspace, you'll be part of a dynamic, purpose-driven team dedicated to empowering nonprofits, associations, and regulators through transformative technology and design. We seek candidates who thrive in environments of continuous learning, value meaningful client relationships, and are driven by delivering exceptional outcomes. If you have a passion for leveraging innovative solutions like AI to amplify positive impact, and align with our core values—care, solution-orientation, quality excellence, accountability, and continuous growth—then 108 ideaspace is the place for you to make a significant difference while growing professionally.

About the role

We are seeking an experienced
Salesforce & SQL Data Migration Consultant
to lead and execute a large-scale data migration from legacy systems into a highly customized Salesforce application. The project involves migrating approximately
12 million records
into a Salesforce environment with
70+ custom objects
, complex relationships, and strict data quality requirements.

This is a
client-facing role
that requires close collaboration with internal data engineers and the client's consulting team. The ideal candidate is hands-on, methodical, and capable of leading both the technical execution and the documentation of the full data migration lifecycle.

Key Responsibilities

Data Migration Strategy & Execution

• Lead end-to-end data migration planning and execution from legacy systems into Salesforce.
• Analyze and document legacy data structures and map them to Salesforce standard and custom objects.
• Define transformation rules, validation logic, deduplication strategies, and reconciliation processes.
• Plan and execute migration waves, including mock runs, test loads, and production cutover.

SQL & Data Engineering Collaboration

• Write advanced SQL queries to extract, transform, validate, and reconcile large datasets.
• Partner closely with internal data engineers to align migration logic, performance optimization, and tooling.
• Work with the client's consultants to validate assumptions, resolve data issues, and agree on migration outcomes.

ETL & Tooling

• Design and implement ETL pipelines using tools such as Jitterbit, , Azure Data Factory, or similar platforms.
• Optimize migration performance for high-volume data loads (12M+ records).
• Manage incremental loads, error handling, retries, and rollback strategies.

Salesforce-Specific Responsibilities

• Execute data loads using Salesforce APIs and bulk processing strategies.
• Manage dependencies across objects, including lookup and master-detail relationships.
• Ensure correct sequencing of reference data, transactional data, and historical records.
• Coordinate with Salesforce developers to align migration logic with application behaviour, automation, and validation rules.

Client Engagement & Documentation

• Act as a primary migration point of contact for client stakeholders.
• Clearly communicate migration approach, risks, and progress to both technical and non-technical audiences.
• Lead the creation and maintenance of detailed migration documentation and artifacts,
• including: Data mapping documents, Transformation and business rules, Migration runbooks, Validation and reconciliation reports, Cutover plans and rollback procedures, Support UAT, defect triage, and post-migration validation.

Required Qualifications

• 8+ years
  of experience in Salesforce and data migration projects.
• Proven experience migrating
  millions of records
  into Salesforce environments.
• Strong understanding of Salesforce data architecture, custom objects, relationships, and limits.
• Advanced SQL expertise
  across complex, high-volume datasets.
• Hands-on experience with at least one ETL platform (Jitterbit, , Azure Data Factory, or equivalent).
• Experience working in highly customized Salesforce orgs.
• Demonstrated experience working directly with clients in delivery-focused roles.

Nice-to-have qualifications

• Experience migrating from legacy CRM, ERP, or custom-built systems.
• Salesforce certifications (Administrator, Platform App Builder, Data Architect, Integration Architect).
• Experience with phased or multi-wave migration strategies.
• Familiarity with Salesforce Bulk API, Data Loader CLI, or custom migration frameworks.

What do we look for?

• Alignment with our values
• Great problem-solving skills.
• Excellent written and verbal communication skills.
• Proven success in contributing to a team-oriented and remote environment.
• Willingness to travel

This position is only open to applicants with the legal right to work in Canada.

IMPORTANT: Pls answer a few questions at to complete your application process.

More about 108 ideaspace