LEAD SOFTWARE ENGINEER

Required Skills · 8+ years of overall experience in technology engineering domains · Experience with Python required · Experience with SQL required (preferably Snowflake platform) · Experience with CDP and Analytics platforms is a plus · Experience with Analytics Engineering Tools like dbt is a plus 1. Data Ingestion & Integration - Ingest data from multiple sources such as Adobe Analytics, Iterable, CRM systems, web tracking, mobile apps, and offline sources. - Implement ETL (Extract, Transform, Load) or ELT pipelines using tools like Snowflake, and Hightouch. - Work with APIs, webhooks, and batch processes to fetch and load data. 2. Data Modeling & Transformation - Design and optimize data schemas for efficient querying in Snowflake. - Implement data transformations to unify customer profiles across multiple touchpoints. - Develop identity resolution logic to stitch customer data together using unique identifiers (email, device ID, cookie, etc.). - Use SQL-based transformations to clean and enrich data. 3. Data Quality & Governance - Set up data validation checks to monitor accuracy and completeness. - Implement data observability using Snowflake's built-in features. - Manage PII (Personally Identifiable Information) data encryption and masking. 4. Data Activation & Reverse ETL - Use Hightouch to sync data from Snowflake to marketing platforms (Google Ads, Meta, Iterable, Salesforce, etc.). - Build audience segmentation logic to personalize customer experiences. - Automate activation workflows for real-time customer engagement.