Salesforce Data Architect
$160,000–$170,000 year
On-siteVienna, Virginia, United States
Job Summary
Design Salesforce data models, write migration scripts, configure MuleSoft integrations, and stand up Data 360 semantic models. Lead end-to-end data migration activities including source profiling, field mapping, ETL development, and iterative validation. Build and maintain API-led integrations using MuleSoft Anypoint Platform, implementing System, Process, and Experience API layers with DataWeave transformations and automated alerting. Develop complex Flows, Flow Orchestrations, Apex classes, and Lightning Web Components to support reporting and automation. Own data quality for compliance pipelines, implement automated validation checks, and produce data profiling reports and reconciliation deliverables. Requires Public Trust security clearance and U.S. citizenship.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, Data Science, or related field
- Minimum 5 years of professional Salesforce development experience (Flows, Apex, LWC, SOQL)
- At least 2 years focused on data architecture, data modeling, or large-scale data migration within Salesforce
- Prior project experience with MuleSoft Anypoint Platform including API design (RAML/OAS), Mule flows, DataWeave transformations, and CloudHub or Runtime Fabric deployment
- Must demonstrate integration work delivered on a real engagement, not just training or certification
- Hands-on project experience with Salesforce Data 360 (formerly Tableau CRM Data Prep or Data Cloud components)
- Must have configured semantic models, defined business metrics, or built data pipelines within Data 360 on a delivered project
- Deep understanding of Salesforce standard and custom objects, relationships, field types, record types, data storage limits, and data architecture best practices
- Experience with Salesforce Data Loader, Bulk API, Metadata API, and data import/export patterns
- Salesforce Platform Developer I certification
- At minimum one additional relevant certification (e.g., Platform Developer II, Data Architect, Integration Architect, MuleSoft Developer, or OmniStudio Developer)
- Proficiency with SQL, Git/GitHub, JIRA, VS Code with Salesforce Extensions, and at least one data profiling or ETL tool
- Must be eligible for Public Trust (Tier 2 / MBI) security clearance
- U.S. citizenship or permanent residency
Desired Qualifications
- Salesforce Data Architect or Integration Architect certification
- MuleSoft Certified Developer or MuleSoft Certified Integration Architect
- Experience with Salesforce Public Sector Solutions (PSS) Grants Management data model
- OmniStudio experience (DataRaptors, Integration Procedures) for data orchestration within Salesforce
- Experience with CRM Analytics (formerly Einstein Analytics) or Tableau Next
- Agentforce or Einstein AI experience - grounding data pipelines, retrieval-augmented generation, or AI data preparation
- FedRAMP compliance experience or prior work on federal government Salesforce contracts
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.