Merkle seeks a senior Data Architect to lead product modernization for enterprise customers migrating legacy Adobe solutions to modern platforms across Analytics, Content, and Commerce. Responsibilities include designing and operationalizing data foundations, building data solutions across Adobe products, unifying disparate data sources, developing data models, defining data governance standards, collaborating with cross-disciplinary teams, delivering data ingestion solutions, improving query performance, driving data migration initiatives, auditing existing solutions, assessing platform maturity, and supporting end-to-end modernization migrations. Requirements include 8+ years of data architecture experience, advanced SQL skills, hands-on experience with Adobe Experience Platform, knowledge of data privacy and identity resolution, proficiency in API integration and scripting, and strong communication skills. Benefits include medical, vision, dental, life insurance, disability insurance, 401k, flexible PTO, paid holidays, sick leave, and parental leave.
What you'll do
Lead design and delivery of product modernization initiatives for enterprise customers migrating legacy Adobe solutions
Similar jobs
More roles worth a look
Related opportunities based on specialty and working model so candidates can keep momentum.
Architect and operationalize end-to-end data foundations across Analytics, Content, and Commerce domains
Build data solutions across multiple Adobe products and cloud platforms aligned with enterprise data strategy
Engage with customers and Adobe team to facilitate data discovery and evaluate systems and business processes
Unify disparate data sources to meet digital marketing use cases
Develop conceptual, logical, and physical data models for multi-solution delivery
Define standards for data quality, master data management, data governance, security, privacy, and compliance
Collaborate with cross-disciplinary groups and Adobe professionals to identify customer demands and provide strategic blueprints
Provide solutions for growing data volumes, tools, and integrations aligned to customer objectives
Deliver Adobe platform data lake and real-time customer profile for data ingestion and activation
Develop and construct data ingestion solutions for streaming and batch processing within AEP
Collaborate with data engineers to develop and implement ETL/ELT pipelines
Improve data query performance and ensure product guardrails are followed
Drive end-to-end data migration initiatives maintaining data quality, integrity, and compliance
Audit existing Adobe solutions to identify technical debt, governance gaps, and data quality issues
Assess platform maturity and flag redesign opportunities prior to modernization
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 across multiple datasets
Architect AEP data ingestion pipelines and collaborate with data engineers on automation
Support end-to-end modernization migrations preserving metric definitions and data integrity
Develop validation and reconciliation documentation for legacy vs modern platform comparisons
Requirements
8+ years of hands-on data architecture, data modeling, SQL development, and analytics platform experience
Expert proficiency in database modeling across relational, hierarchical, and data lake environments
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 including data ingestion, schema design, unified profiles, segmentation, real-time activation workflows, and native AI tools
Knowledge of identity resolution, data privacy frameworks, and consent management
Proficiency in API-first integration patterns (REST, webhooks, Postman) and basic scripting (Python or Bash)
Excellent written and verbal communication and strong organizational skills
Medical, vision, and dental insuranceLife insuranceShort-term and long-term disability insurance401kFlexible paid time offAt least 15 paid holidays per yearPaid sick and safe leavePaid parental leave
Apply now
Ready to take the next step in your career? Click the button below to continue to the application process.
