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 provide data quality, master data management, data governance, security, privacy and compliance frameworks (PII, PCI, HIPAA, GDPR).
• Build data lake and real-time customer profile solutions, and design ingestion pipelines (streaming and batch) and ETL/ELT workflows with data engineers.
• Tune queries, audit existing Adobe solutions, assess platform maturity and document reconciliation and integration points.
• Map legacy infrastructure to AEP schemas and CJA data views, migrate large datasets while preserving data quality, and write validation and reconciliation documentation.
• Act as liaison between customers and Adobe, advocate for scalable solutions and present migration strategies to executives.

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 related field; equivalent senior data architecture experience accepted.
• Nice to have: Adobe ACE in CJA or AEP Data Architect, ACA in Real-Time Customer Data Platform or Analytics, hands-on AEP Content or Commerce experience, Analytics-to-CJA migration experience, Git and CI/CD experience, and a track record presenting to C-suite stakeholders.

Required skills

• Advanced SQL (window functions, complex joins, stored procedures, query optimization)
• Hands-on 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 and consent management

What we offer

• Salary range of $113,000 - $158,750, based on experience and skills.
• 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.