Salesforce Data Architect
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.1
Reclaim your time by letting our AI handle the grunt work of job searching.
We continuously scan millions of openings to find your top matches.
Overview
Job Description
Position: Salesforce Data Architect
Location : Chicago, IL (Hybrid) Experience: 10 15 years overall; 3+ years in Salesforce data architecture
We are looking for Salesforce Data Architect consultants in Chicago, IL, it's a hybrid role, 3 days work from office in week is must in this role.
We are seeking a Salesforce Data Architect to own the data architecture, data modeling, and data governance across enterprise Salesforce programs. The role designs the trusted data foundation that powers Customer 360, Data 360 (Data Cloud) and agentic AI (Agentforce) - spanning data modeling, large-scale migrations, identity resolution, master-data alignment and data quality. The Data Architect ensures that unified, governed and high-quality data underpins personalization, analytics and AI-led decisioning at scale.
KEY RESPONSIBILITIES
Data Architecture & Modeling
Own the enterprise data model across the Salesforce estate - objects, relationships, LDV (large data volume) design, indexing and skinny tables.
Design canonical data models and mapping to enterprise / master-data definitions for consistency across systems.
Define data-partitioning, archival and retention strategies to sustain performance at scale.
Data Migration & Integration
Define end-to-end data migration strategy from legacy CRMs / ERPs (including cleansing, dedup, reconciliation and cutover).
Architect data integration and synchronization patterns (API-led, ETL/ELT, batch and streaming) with ERP, MDM and data-platform ecosystems.
Ensure reliable handling of high-volume, high-velocity data with data lineage and traceability.
Data Governance, Quality & Security
Establish data governance - ownership, stewardship, quality rules, MDM alignment and metadata management.
Define data-quality KPIs (completeness, accuracy, duplication) and remediation frameworks.
Ensure data privacy and compliance (GDPR / CCPA), data masking, encryption and role-based access to sensitive data.
Advisory & Practice Contribution
Support presales, data-strategy assessments, estimation and solution defence for data-centric pursuits.
Build reusable data-migration frameworks and accelerators; mentor data engineers and consultants.
REQUIRED SKILLS & EXPERIENCE
10 15 years overall with 6+ years on Salesforce and 3+ years in data architecture / Data Cloud.
Strong Salesforce data modeling, LDV optimization, and sharing/visibility implications on the data layer.
Hands-on Data Cloud (Data 360) - DLO/DMO, Identity Resolution, Calculated Insights, Segmentation, Activations.
Proven large-scale data migration experience with cleansing, dedup and reconciliation frameworks.
Strong SQL and data-integration skills (API-led, ETL/ELT, middleware); familiarity with data platforms (Snowflake / BigQuery / Redshift) is a plus.
Understanding of MDM, data governance, and data-quality tooling and practices.
CERTIFICATIONS (Nice to have)
Salesforce Certified Data Architect
Salesforce Data Cloud Consultant
Application Architect / Integration Architect / Platform Developer certifications.
KEY COMPETENCIES
Rigorous data-modeling and data-governance discipline.
Strong analytical and problem-solving skills with attention to data quality and detail.
Clear communication of data strategy to technical and business stakeholders.
Outcome orientation - trusted data that measurably enables AI, analytics and personalization.
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
