[Hiring] Data Architect @dentsu

Role Description

Merkle is seeking an experienced Data Architect to lead the design and delivery of product modernization initiatives for enterprise customers migrating legacy Adobe solutions to modern platforms across Analytics, Content, and Commerce domains. You will architect and operationalize the end-to-end data foundations that power our customers' digital marketing, content, and commerce ecosystems.

• Provide deep experience to build data solutions across multiple Adobe products and cloud platforms aligned with enterprise data strategy.
• Engage closely with customers and Adobe team to facilitate data discovery by evaluating systems and business processes.
• Unify disparate data (e.g., sales, CRM, analytics data) to meet customers’ digital marketing use cases.
• Lead and develop conceptual, logical, and physical data models for multi-solution delivery.
• Showcase and follow frameworks for data quality, define standards, master data management, data services, data governance, data modeling, tools, data security, privacy, and compliance with industry regulations.
• Engage with cross-disciplinary groups and Adobe professionals to identify customer demands.
• Provide solutions for growing data volumes, tools, and integrations, while aligning to customers’ objectives.
• Deliver Adobe platform data lake and real-time customer profile to get ready for data ingestion and activation.
• Develop and construct data ingestion solutions for streaming and batch processing.
• Improve data query performance across platforms by tuning models and adhering to guidelines.
• Drive end-to-end data migration initiatives, transforming and migrating large-scale datasets while maintaining data quality, integrity, and compliance.
• Audit existing Adobe solutions to establish current state baseline and identify technical debt, governance gaps, and data quality issues.
• Assess platform maturity and evaluate taxonomy consistency, content metadata tagging practices, and standards compliance.
• Identify platform-specific reconciliation and integration points and document data consistency requirements.
• Map legacy platform infrastructure to AEP schemas and CJA data views.
• Design AEP data models across Analytics, Content, and Commerce domains.
• Develop relational and dimensional data models for analytics spanning multiple customer datasets.
• Architect AEP data ingestion pipelines across Analytics, Content, and Commerce data sources.
• Support end-to-end modernization migrations, preserving metric definitions, historical accuracy, content governance, and commerce data integrity.
• Develop validation and reconciliation documentation for legacy-vs-modern platform comparisons.

Qualifications

• 8+ years of hands-on data architecture, data modeling, SQL development, and analytics platform experience working with enterprise customers.
• Expert proficiency in crafting customer-centric database models and datasets.
• Demonstrated experience auditing, assessing, and documenting data components of implementations.
• Advanced SQL skills including window functions, complex joins, aggregations, stored procedures, and query optimization.
• Hands-on experience with Adobe Experience Platform (AEP).
• Knowledge of identity resolution, data privacy frameworks, and consent management.
• Proficiency in API-first integration patterns and basic scripting for data pipeline automation.
• Excellent written and verbal communication and strong organizational skills.

Requirements

• Adobe Certified Expert (ACE) in CJA or AEP Data Architect.
• Adobe Certified Associate (ACA) in Real-Time Customer Data Platform or Analytics.
• Hands-on experience with Adobe Experience Platform for Content or Commerce.
• Hands-on experience with Adobe Analytics API for automated assessment and documentation.
• Experience with Analytics-to-CJA migration patterns and common reconciliation challenges.
• Experience with version control (Git) and CI/CD practices for data solution deployment.
• Track record of presenting modernization audits and migration strategies to C-suite and line-of-business stakeholders.

Benefits

• Medical, vision, and dental insurance.
• Life insurance.
• Short-term and long-term disability insurance.
• 401k.
• Flexible paid time off.
• At least 15 paid holidays per year.
• Paid sick and safe leave.
• Paid parental leave.