Customer Data Architect (Salesforce)

Responsibilities

• Own the customer data architecture from the enterprise customer data platform into Salesforce Data 360 and Marketing Cloud, including ingestion, mapping, refresh cadence and data quality rules.
• Define identity and match logic, including owner and customer resolution, household and vehicle relationships, and golden record rules.
• Lead the data model and data model object (DMO) strategy in Data 360.
• Define audience eligibility, segmentation, suppression and consent rules for all programs.
• Design the activation architecture: what is prepared in the enterprise data layer and what is activated in Data 360, balancing capability and platform consumption.
• Identify and resolve data quality issues, including conflicting sources overriding trusted records.
• Coordinate third-party data partners for data hygiene, address standardization and ownership verification.
• Maintain data processing instructions, data dictionaries and source-to-target documentation.
• Partner with client data, privacy and security teams on governance, consent and data agreements.
• Define measurement data foundations, including KPI definitions and the datasets needed for reporting and attribution.
• Partner with the Salesforce Solution Architect, journey and operations teams on audience and data requirements.

Requirements

• 8+ years in data architecture, customer data strategy or enterprise data engineering, with a focus on marketing and customer data.
• Hands-on experience with Salesforce Data 360 or another enterprise CDP such as Adobe Real-Time CDP, Tealium, Segment or Treasure Data.
• Strong understanding of identity resolution, profile unification and household or relationship modeling.
• Advanced SQL, plus familiarity with Python and cloud data platforms such as Snowflake, Databricks or BigQuery.
• Experience designing data ingestion pipelines and data quality frameworks.
• Working knowledge of consent, privacy and data governance in large enterprise environments.
• Excellent documentation skills and the ability to explain complex data concepts to marketing stakeholders.

Preferred Qualifications

• Salesforce Data Cloud Consultant certification.
• Automotive, OEM or dealer-network experience, including vehicle ownership, VIN relationships, registration, DMS and dealer data.
• Experience working with third-party data providers for hygiene, identity and enrichment.
• Experience with zero-copy or data federation patterns between cloud warehouses and Data 360.
• Background in MarTech consulting or agency delivery.

Work Environment

Additional information