Salesforce Data Architect

Salesforce Data Architect

Location : Chicago, IL

Duration : Long term

Day one onsite (Hybrid 3 days / week )

ROLE OVERVIEW

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.

“Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.”