Data Cloud Consultant

We are seeking a focused, hands-on Salesforce Data Cloud Consultant to guide our data harmonization strategy on a part-time basis. In this role, you will bridge the gap between our raw data sources and actionable customer insights. You will be responsible for setting up data streams, mapping ingestion schemas, and establishing unified individual profiles that power our personalized marketing and analytics engines.

Because this is a fractional role (15–20 hours/week), we need someone who can work autonomously, manage their own delivery timelines, and hit the ground running without hand-holding.

Key Responsibilities

1. Data Ingestion & Architecture

• Configure secure data streams to ingest data from diverse sources (Salesforce CRM, MuleSoft, AWS S3, webhooks, and external data lakes).
• Map ingested Data Lake Objects (DLOs) to the standard Customer 360 Data Model (DMOs).

2. Identity Resolution & Segmentation

• Design, test, and refine Identity Resolution Rulesets to accurately match and consolidate duplicate records into a single, unified profile.
• Create complex, high-performing segments using both behavioral and transactional attributes.

3. Insights & Activation

• Build Calculated Insights using SQL to compute aggregate metrics (e.g., customer lifetime value, churn risk, or recent engagement scores).
• Set up activation targets and actions to push unified data back into Salesforce Core, Marketing Cloud, or external analytics tools.

4. Strategy & Collaboration

• Advise internal stakeholders on Data Cloud best practices, data governance, and storage optimization.
• Document data lineage, schemas, and mapping configurations for long-term maintainability.

Technical Requirements & Qualifications

• Salesforce Certified Data Cloud Consultant credential is highly preferred.
• 2+ years of hands-on experience specifically deploying, configuring, and troubleshooting Salesforce Data Cloud (formerly CDP/Genie).
• Strong proficiency in SQL for writing Calculated Insights and troubleshooting data issues.
• Deep understanding of the Salesforce Customer 360 Data Model and entity-relationship diagrams (ERDs).
• Familiarity with data privacy regulations (GDPR, CCPA) and consent management within Salesforce.
• Ability to look at a backlog, identify high-impact tasks, and execute them efficiently.
• Intermediate-Advanced English skills