Adobe Products Data Engineer

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). This role will focus on building, managing, and optimizing data pipelines, profiles, and datasets that power customer experiences across the Adobe ecosystem. The ideal candidate combines strong data engineering capabilities with hands-on experience across Adobe products and a solid understanding of identity resolution, data governance, and profile management.

Responsibilities

Build and maintain scheduled CTAS queries to populate profile-enabled datasets; Develop JSON-to-Excel transformation processes to support Product Information Management (PIM) workflows; Design and implement new XDM schemas for onboarding additional brands into AEP; 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; 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; 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)

Requirements

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; Applicants must be currently authorized to work in the United States

Nice to have

Relevant Adobe certifications in Adobe Experience Platform (RTCDP) and Customer Journey Analytics (CJA); Experience with additional Adobe products: Adobe Marketo Engage, Adobe Analytics, Adobe Experience Manager (AEM) particularly Forms, Adobe Target; Familiarity with data pipeline orchestration and automation; Customer segmentation strategies and activation workflows; Data governance frameworks and compliance considerations; Adobe Tags and Tag Management, WbSDK

Benefits

Annual discretionary bonus; Medical, dental, vision; Paid vacation; 401k (up to 4% match); Health Savings Account (with company contribution); Well-being program; Product purchase discounts; Flexible hybrid work environment