Hightouch Engineer

Hightouch Engineer || Remote Contract role 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 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. Thanks & Regards Mayank Chaudhary Lead Technical Recruiter (US Talent Acquisition) Email: mayank@indus-grp.com Indus Group Inc.