Apolis is a company focused on innovative data solutions, and they are seeking a Hightouch Engineer / Marketing Data Engineer. The role involves building and maintaining Hightouch data models to enable personalized customer email campaigns by translating SQL logic into Hightouch and syncing data to Salesforce Marketing Cloud.
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
Requirements:
- 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)
- Financial services or banking data models (customers, accounts, roles)
- Marketing activation use cases involving multi-product personalization