Data Architect, Product Modernization

About the role

Merkle's Adobe Practice, part of Dentsu, is looking for an experienced Data Architect to lead product modernization for enterprise customers moving legacy Adobe solutions to modern platforms across Analytics, Content and Commerce. You will design and deliver the data foundations behind customers' digital marketing, content and commerce ecosystems, using Adobe Experience Platform, Analytics, Content and Commerce.

Key responsibilities

• Evaluate customer systems and business processes, analyze data sources, movement, granularity and formats, and unify disparate data (sales, CRM, analytics, etc.) for digital marketing use cases.
• Lead conceptual, logical and physical data models and audit existing Adobe solutions to find technical debt, governance gaps and data quality issues.
• Design AEP data models and ingestion pipelines (streaming, batch, online, offline) and ETL/ELT pipelines with data engineers, and tune queries for performance.
• Drive end-to-end data migration, map legacy infrastructure to AEP schemas and CJA data views, and deliver validation and reconciliation documentation.
• Showcase data quality, master data management, data governance, data security, privacy and compliance frameworks (PII, PCI, HIPAA, GDPR).
• Use REST APIs, Postman and basic scripting to automate implementation and setup.

Required profile

• 8+ years of hands-on data architecture, data modeling, SQL development and analytics platform experience with enterprise customers.
• Degree in Computer Science, Information Systems, Data Science or a related field; equivalent senior data architecture experience considered.
• Nice to have: Adobe ACE in CJA or AEP Data Architect, ACA in Real-Time Customer Data Platform or Analytics, and experience presenting modernization audits to C-suite stakeholders.

Required skills

• Advanced SQL, including window functions, complex joins, aggregations, stored procedures and query optimization.
• Hands-on experience with Adobe Experience Platform (data ingestion, schema design, unified profiles, segmentation, real-time activation).
• API-first integration (REST, webhooks, Postman) and basic scripting (Python or Bash).
• Knowledge of identity resolution, data privacy frameworks and consent management.

What we offer

• Salary range of $113,000 - $158,750.
• Medical, vision and dental insurance, life insurance, and short- and long-term disability insurance.
• 401k, flexible paid time off, at least 15 paid holidays per year, paid sick and safe leave, and paid parental leave.
• Hybrid work: three days in the office per week for those living near the hubs (Chicago, metro Detroit, Los Angeles, New York City); remote possible for others.