AEP - Data Architect
Job Description
•Collaborate with Customer’s Technical & Marketing teams to finalize use cases & relevant documentation
•Coordinate with Customer’s Technical team to review all customer data sources required for use cases fordeeper data discovery
•Create necessary technical documentation, Entity Relationship Diagrams (ERD) to review & sign-off with the customer
•Architect tailored Adobe Experience Platform detailed data model, data mapping to meet defined uses cases
•Create all required Adobe XDM (Experience Data Model) in JSON based on approved data model for all loading data files
• Utilize Adobe Experience Platform (AEP) UI & POSTMAN to automate all customer schema data lake & profile design setups within each sandbox environment
• Configure within Adobe Experience Platform all necessary identities & privacy settings
• Coordinate with customer’s IT team and/or Data Engineers on the XDM requirements needed for data ingestion into AEP
• Create new segments within AEP to meet customer use cases. Test/Validate the segments with the required destinations
• Develop & write custom & complex queries using SQL to build reports, views & CTAS
• Leverage AEP Query Service to aggregate & transform data for DSW, CJA data format requirements & various other destinations
• Setup BI connections & coordinate with customer team with the data exports
• Coordinate with Application Services (e.g. RTCDP, CJA) members for data validations, destinations, troubleshooting within AEP
Qualifications
Typical Skills:
•Business & Technical Discovery
•Data Modeling
•Entity Relationship Diagrams (ERD)
•JSON
•Complex SQL
•API via POSTMAN
•DB/EDW/MDM/Cloud/Big Data
•BI & Reporting Tools