NEWPosted 3 hours ago

Job ID: JOB_ID_2775

Role Summary

Responsible for building and maintaining Hightouch data models, traits, and syncs to enable personalized, product level customer email campaigns. The role focuses on translating SQL logic into Hightouch, aggregating multi-account customer data, and syncing clean, compliant data to Salesforce Marketing Cloud.

Key Responsibilities

  • Configure Hightouch audiences on the Customer entity using eligibility, relationship, and accountlevel conditions (active status, role type, age, email availability).
  • Develop SQLbased aggregated traits that consolidate multiple financial accounts into a single customer record (one row per customer).
  • Implement consistent financial account filtering logic (DDA, LAS, SAV; valid class codes; active status) across audiences and traits.
  • Build structured aggregated fields containing product type, class code, product description, and last 4 digits of account number.
  • Configure Hightouch Salesforce Marketing Cloud syncs using Upsert with Customer ID as the primary key.
  • Map customer and account traits to Marketing Cloud Data Extensions to support personalized fee and estatement messaging.
  • Validate data accuracy, aggregation logic, and sync reliability; troubleshoot failures and data mismatches.

Tools & Technologies

  • Hightouch (Audiences, Traits, Reverse ETL, Syncs)
  • SQL (CTEs, aggregation, string concatenation, conditional logic)
  • Cloud Data Warehouse (e.g., Snowflake, BigQuery, Redshift source for Hightouch models)
  • Salesforce Marketing Cloud (Data Extensions, Email Personalization)
  • Salesforce CRM IDs (Customer / Contact identifiers)

Required Skills

  • Strong SQL and data modeling experience (customercentric, onetomany relationships).
  • Handson experience with Hightouch or similar reverse ETL tools.
  • Experience integrating warehouse data with marketing platforms.
  • Understanding of data privacy practices (account masking, last4digit handling).

Preferred Experience

  • Financial services or banking data models (customers, accounts, roles).
  • Marketing activation use cases involving multiproduct personalization.

Special Requirements

Onsite

Compensation & Location

Salary: $110,000 – $140,000 per year (Estimated)

Location: Columbia, SC

Recruiter / Company – Contact Information

Email: dsingh@alltechconsultinginc.com

Interested in this position?
Apply via Email

Recruiter Notice:
To remove this job posting, please send an email from
dsingh@alltechconsultinginc.com with the subject:

DELETE_JOB_ID_2775

to delete@join-this.com.