CDP Data Engineer

Cliff Services Inc is seeking a skilled CDP Data Engineer to join their Data & Analytics team. This role involves end-to-end data management, focusing on data collection, unification, segmentation, and activation to enable data-driven marketing and business decisions.

Responsibilities:

• Design and implement data collection pipelines from multiple sources into the CDP
• Ensure data quality, consistency, and completeness during ingestion
• Collaborate with source system teams to define and document data schemas
• Build and maintain identity resolution frameworks to unify customer profiles across channels
• Implement data deduplication and matching logic using CDP capabilities
• Work with business stakeholders to define unified customer identity rules
• Develop and manage audience segments within the CDP for targeted campaigns
• Partner with marketing teams to translate business requirements into technical segmentation logic
• Monitor and optimize segment performance and refresh rates
• Integrate CDP segments with downstream activation platforms (ad platforms, CRM, email, etc.)
• Configure and manage data flows from CDP to activation channels using tools like Hightouch
• Ensure timely and accurate data delivery for marketing activation use cases

Requirements:

• Functional knowledge of CDP platforms (e.g., Segment, Adobe CDP, Tealium, or similar)
• Proficiency in Snowflake SQL for data analysis, transformation, and querying
• Strong experience in Data Modeling — designing efficient, scalable data models
• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related field
• 3–6 years of experience in data engineering, analytics engineering, or a similar role
• Strong problem-solving skills and ability to work in a fast-paced environment
• Excellent communication skills with ability to collaborate across technical and business teams
• Experience with Hightouch or similar reverse ETL tools for data activation
• Hands-on experience with ETL/ELT pipelines and workflow orchestration
• Working knowledge of REST APIs and API-based integrations
• Familiarity with data governance, privacy regulations (GDPR, CCPA), and consent management
• Experience in media, entertainment, or e-commerce domain (AETN context)
• Knowledge of dbt (data build tool) for data transformation
• Experience with cloud platforms such as AWS, GCP, or Azure