Salesforce Data Architecture & Migration Consulting Support

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

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