What are the responsibilities and job description for the Salesforce Data Cloud & Marketing Cloud Operational Specialist position at Aditi Consulting?
Payrate: $44.00 - $46.00/hr.
Summary:
The main function of the Salesforce Data Cloud & Marketing Cloud Operational Specialist is to build, test, and activate audience segments within Salesforce Data Cloud (CDP) and configure the downstream data extension structures, automations, and campaign-ready assets within Salesforce Marketing Cloud Engagement (MCE). This role applies hands-on knowledge of Data Cloud segmentation, identity resolution, data modeling, and SFMC data architecture to support enterprise member engagement and personalization initiatives.
Responsibilities
- Work with Product Management, Digital Strategy, and Marketing stakeholders to translate business engagement requirements into Data Cloud segment definitions — including audience criteria, exclusion logic, frequency rules, and activation targets.
- Build, test, and activate audience segments in Salesforce Data Cloud using segmentation canvas, calculated insights, computed traits, and identity-resolved profiles.
- Configure and maintain SFMC data extensions — including schema design, primary key definitions, relationships, and retention policies — to receive activated segments from Data Cloud.
- Design, implement, and maintain Automation Studio workflows (SQL queries, filter activities, import/export activities, data extracts) to transform, enrich, and stage segment data for campaign execution in Journey Builder and Email Studio.
- Monitor and troubleshoot segment activation pipelines between Data Cloud and MCE — identifying and resolving data sync failures, record count discrepancies, identity resolution mismatches, and activation delays.
- Perform end-to-end QA of segment outputs — validating audience counts, data accuracy, suppression logic, consent enforcement, and de-duplication prior to campaign deployment.
- Maintain segment taxonomy, naming conventions, and lifecycle governance to ensure auditability, reuse, and reduction of duplicative audiences across business units.
- Support data model maintenance within Data Cloud — including monitoring data lake objects (DLOs), data model objects (DMOs), identity resolution rulesets, and relationship configurations.
- Document and maintain runbooks, SOPs, and QA checklists for all segment build and activation processes.
- Test new segment configurations and data extension structures in sandbox environments, correct errors, validate against acceptance criteria, and promote to production following IT change control standards.
Qualifications
- Bachelor's degree in a technical field such as computer science, information systems, data analytics, or related field required.
- 2-4 years hands-on experience with Salesforce Marketing Cloud Engagement (data extensions, Automation Studio, SQL, Email Studio) required.
- 1-2 years hands-on experience with Salesforce Data Cloud / CDP (segmentation, activation, identity resolution) required.
- Experience in healthcare, health insurance, or regulated industries strongly preferred.
- Salesforce certifications (Marketing Cloud Email Specialist, Data Cloud Consultant, or equivalent) strongly preferred.
Desired Skills
- Hands-on experience with Salesforce Data Cloud (segmentation canvas, calculated insights, identity resolution, data model configuration, activation targets).
- Hands-on experience with Salesforce Marketing Cloud Engagement (data extensions, SQL queries, Automation Studio, AMPscript, Journey Builder data entry sources).
- Strong understanding of relational data modeling — primary/foreign keys, one-to-many relationships, normalized vs. denormalized structures.
- Knowledge of SQL for audience queries, data transformation, and validation within both Data Cloud and SFMC.
- Familiarity with ETL/data pipeline patterns — particularly ingestion from enterprise data sources (e.g., Snowflake, data lakes) into Data Cloud and downstream into MCE.
- Understanding of consent management, suppression logic, and regulatory compliance (HIPAA, CCPA, TCPA) as applied to audience segmentation and campaign activation.
- Strong QA and troubleshooting skills — ability to trace data from source through identity resolution, segmentation, activation, and into SFMC data extensions to isolate issues.
- Strong written and oral communication skills — ability to document processes and collaborate with cross-functional partners.
- Detail-oriented with a bias toward operational rigor, accuracy, and accountability.
Pay Transparency: The typical base pay for this role across the U.S. is: $44.00 - $46.00 /hour. Non-exempt positions are eligible for overtime at a rate of 1.5 times the base hourly rate for all hours worked in excess of 40 in a work week, or as required by state or local law. Final offer amounts, within the base pay set forth above, are determined by factors including your relevant skills, education and experience. Full-time employees are eligible to select from different benefits packages. Packages may include medical, dental, and vision benefits, health savings accounts with qualified medical plan enrollment, 10 paid days off, 3 days paid bereavement leave, 401(k) plan participation with employer match, life and disability insurance, commuter benefits, dependent care flexible spending account, accident insurance, critical illness insurance, hospital indemnity insurance, accommodations and reimbursement for work travel, and discretionary performance or recognition bonus. Sick leave and mobile phone reimbursement provided based on state or local law.
Consent to Communication and Use of AI Technology: By submitting your application for this position and providing your email address(es) and/or phone number(s), you consent to receive text (SMS), email, and/or voice communication whether automated (including auto telephone dialing systems or automatic text messaging systems), pre-recorded, AI-assisted, or individually initiated from Aditi Consulting, our agents, representatives, or affiliates at the phone number and/or email address you have provided. These communications may include information about potential opportunities and information. Message and data rates may apply. Message frequency may vary.
You represent and warrant that the email address(es) and/or telephone number(s) you provided to us belong to you and that you are permitted to receive calls, text (SMS) messages, and/or emails at these contacts. You also acknowledge and agree to Aditi Consulting LLC’s use of AI technology during the sourcing process, including calls from an AI Voice Recruiter. AI is used solely to gather data and does not replace human-based decision-making in employment decisions. Calls may be recorded.
Consent is not a condition of purchasing any property, goods, or services. You may revoke your consent at any time by replying “STOP” to messages or by contacting privacy@aditiconsulting.com.
For information about our collection, use, and disclosure of applicant's personal information as well as applicants' rights over their personal information, please see our Privacy Policy .
#AditiConsulting
# 26 - 03769
Salary : $44 - $46