Job Description
Salesforce Data Architecture & Migration Consulting Support
5 months Contract
Remote (LATAM)
8+ years
Scope of Work
The contractor will provide data architecture, data mapping, and migration advisory support for two Salesforce data migrations into the organization’s Salesforce Illuminate instance. This role will operate within an established migration program and will work in collaboration with internal resources responsible for program management, stakeholder coordination, and ETL execution.
Key Responsibilities
Analyze and interpret source system data models, including objects, fields, relationships, and dependencies
Support the design and documentation of source-to-target data mappings between legacy systems and Salesforce Illuminate
Identify, document, and resolve data mapping gaps where source and target data models do not align 1:1
Define and clearly transcribe required data transformations, business rules, and assumptions for ETL implementation by supporting resources
Collaborate with ETL developers to clarify transformation logic and validate outcomes
Perform data validation and reconciliation support, including review of migrated data for accuracy and completeness
Support process mapping activities to ensure data structures are aligned with business workflows
Document findings, mapping decisions, and transformation logic to support repeatability and auditability
Escalate risks, dependencies, or data quality concerns to appropriate stakeholders
Required Qualifications
Demonstrated experience supporting Salesforce data migrations, including complex or multi-source environments
Strong understanding of data architecture, relational data models, and ETL concepts
Proven ability to independently analyze unfamiliar source data structures and translate them into Salesforce-aligned mappings
Experience documenting data mappings, transformation logic, and data flows
Ability to identify data gaps and propose practical remediation or transformation approaches
Strong analytical, documentation, and cross-functional communication skills
Preferred Qualifications
Alteryx experience (preferred)
Experience with Salesforce Illuminate
Experience supporting system consolidation, carve-out, or acquisition-related migrations
Background in process mapping or business process documentation
Experience working alongside dedicated ETL development resources
Deliverables
Documented source-to-target data mappings
Clearly defined transformation logic and mapping gap resolutions
Data validation and reconciliation findings
Migration support documentation (assumptions, risks, decisions)