Salesforce Data Architect

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.