Adobe Products Data Engineer

Position Overview

We are seeking a highly skilled Adobe Products Data Engineer with deep expertise in Adobe Experience Platform (AEP), specifically Customer Data Platform (RTCDP) and Customer Journey Analytics (CJA).

Key Responsibilities

• Build and maintain scheduled CTAS (Create Table As Select) queries to populate profile-enabled datasets
• Develop JSON-to-Excel transformation processes to support Product Information Management (PIM) workflows
• Create and maintain data transformation pipelines (SQL-based) to onboard and append new brand data
• Evaluate and optimize how datasets are stitched and merged, with a focus on improving current "most recently updated" logic
• Monitor, QA, and troubleshoot dataflow errors in AEP (including intermittent sync issues & transformation issues)
• Perform profile and segment overlap analysis to identify audience conflicts and ensure optimal targeting
• Provide insights into segmentation strategy to prevent competing customer messaging
• Maintain CJA connections and data views, including field-based stitching configuration
• Maintain AEP source connectors, Data Landing Zone, batch vs streaming ingestion, API-based ingestion, familiarity with Postman Documentation & Governance
• Maintain and update segment activation documentation, data dictionaries, and system documentation
• Optimize and maintain XDM schemas and field descriptions within the platform. Contribute to data governance best practices, including data usage standards and process documentation
• Support compliance-related improvements, including processes for profile suppression or deletion (opt-out requests)

Required Qualifications

• Bachelor’s degree (4-year) in Computer Science, Engineering, or a related technical field
• Hands-on experience with: Adobe Experience Platform (AEP) RTCDP, Customer Journey Analytics (CJA)
• Strong expertise in: SQL and data transformation logic, data modeling, schema design, and dataset management, profile-enabled datasets and identity resolution concepts
• Experience with large-scale data migrations and data model architecture best practices

Preferred Qualifications

• Relevant Adobe certifications in: Adobe Experience Platform (RTCDP), Customer Journey Analytics (CJA)
• Experience with additional Adobe products, including: Adobe Marketo Engage, Adobe Analytics, Adobe Experience Manager (AEM), particularly Forms, Adobe Target