Hightouch CDP Engineer

Job Details:

Job Title: Hightouch Engineer / Marketing Data Engineer

Location: 100% Remote

Duration: Long Term Contract

Job Description:

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 account level conditions (active status, role type, age, email availability).
• Develop SQL based 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 e statement 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 (customer centric, one to many relationships).
• Hands on experience with Hightouch or similar reverse ETL tools.
• Experience integrating warehouse data with marketing platforms.
• Understanding of data privacy practices (account masking, last 4 digit handling).

Preferred Experience

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