Data Architect

This is a fully remote position, open to applicants in United States.

📋 Description

• Oversee the design and execution of product modernization projects for enterprise clients transitioning from legacy Adobe solutions to contemporary platforms across Analytics, Content, and Commerce.

• Design and implement comprehensive data foundations encompassing data strategy, modeling, integration, and governance.

• Assess customer systems and business processes to enable data discovery.

• Integrate various CRM, sales, analytics, call center, content, commerce, and other data sources for digital marketing, content, and commerce applications.

• Lead conceptual, logical, and physical data modeling for multiple solution deliveries.

• Establish and implement frameworks for data quality, master data management, data services, governance, security, privacy, and compliance.

• Collaborate with clients, Adobe experts, data engineers, and interdisciplinary teams to identify requirements and overcome technical challenges.

• Deliver data lakes on the Adobe platform and real-time customer profiles for ingestion and activation.

• Utilize REST APIs, Postman, and scripting to automate setup and implementation processes.

• Create solutions for streaming, batch, online, and offline data ingestion within AEP.

• Work on ETL/ELT pipelines for data gathering and extraction.

• Optimize data models and query performance while adhering to platform guidelines.

• Drive comprehensive data migration projects while ensuring data quality, integrity, and compliance.

• Review existing Adobe solutions to identify technical debt, governance issues, and data quality concerns.

• Evaluate platform maturity, consistency of taxonomy, metadata tagging, standards compliance, and enhancement of commerce product data.

• Align legacy infrastructure with AEP schemas and CJA data views, determining what elements to migrate, transform, or redesign.

• Design AEP data models spanning Analytics, Content, and Commerce areas.

• Create relational and dimensional analytics models across RDBMS, columnar, warehouse, and data lake settings.

• Support modernization migrations while maintaining metric definitions, historical accuracy, content governance, and the integrity of commerce data.

• Develop documentation for validation and reconciliation comparing legacy platforms to modern ones.

⛳️ Requirements

• A minimum of 8 years of practical experience in data architecture, data modeling, SQL development, and analytics platforms, particularly with enterprise clients.

• Expert knowledge of customer-focused database models and datasets utilizing relational, hierarchical, RDBMS, columnar, data warehouse, BI, document, semantic layer, data lake, OLTP, and OLAP modeling.

• Experience in auditing, evaluating, and documenting data components of implementations.

• Capability to translate intricate data configurations and models into business requirements and technical documentation.

• Advanced SQL proficiency, including window functions, complex joins, aggregations, stored procedures, and query optimization.

• Practical experience with Adobe Experience Platform (AEP), including data ingestion, schema design, unified profiles, segmentation, real-time activation workflows, and native AI tools.

• Understanding of identity resolution, data privacy frameworks, and consent management.

• Skills in REST, webhooks, Postman, and foundational Python or Bash scripting.

• Strong written and verbal communication skills and excellent organizational abilities.

• Capacity to manage multiple customer engagements and effectively communicate architectures and migration strategies to both executive and technical audiences.

• A degree in Computer Science, Information Systems, Data Science, or a related technical field; equivalent experience in a senior data architecture role is considered acceptable.

• Adobe Certified Expert in CJA or AEP Data Architect is a desirable qualification.

• Adobe Certified Associate in Real-Time Customer Data Platform or Analytics is an added advantage.

• Familiarity with Adobe Experience Platform for Content or Commerce, Adobe Analytics API, Analytics-to-CJA migrations, Git, and CI/CD is beneficial.

🏝️ Benefits

• Medical, vision, and dental insurance.

• Life insurance.

• Short-term and long-term disability insurance.

• 401k plan.

• Flexible paid time off.

• At least 15 paid holidays each year.

• Paid sick and safe leave.

• Paid parental leave.

• Relevant state and local employee leave benefits.