Data Architect, Product Modernization

Dentsu International Americas, LLC

Utah

Hybrid

USD 113.000 - 159.000

Vollzeit

14 Tage+

Eine vollständige Bewerbung in einer Minute

Maßgeschneiderter Lebenslauf und Anschreiben – versandbereit.

Schaffe es an den ATS-Filtern vorbei

Benefits dieser Stelle

Medical, vision, and dental insurance
Life insurance
Disability insurance (short-term and &
401k
Flexible paid time off
15 paid holidays per year
Paid sick and safe leave
Paid parental leave

Zusammenfassung

Dentsu is seeking an experienced Data Architect to lead modernization initiatives for enterprise customers migrating legacy Adobe solutions to modern platforms across Analytics, Content, and Commerce. You will design data models, ingestion pipelines, and governance frameworks to support unified profiles, segmentation, and activation across Adobe Experience Platform.

Responsibilities include end-to-end data migrations, collaboration with customers and Adobe teams, and delivering scalable,

Qualifikationen

  • 8+ years hands-on data architecture and analytics experience.
  • Expert in data modeling across CRM, marketing, offline, and commerce datasets.
  • Advanced SQL skills including window functions and query optimization for analytics workloads.
  • Experience with Adobe Experience Platform (AEP), data ingestion, schema design, and real-time activation workflows.
  • Ability to translate complex data configurations into clear technical and business requirements.

Aufgaben

  • Lead design of data models and ingestion pipelines for AEP migrations.
  • Collaborate with customers and Adobe teams to map data sources and data movement.
  • Develop end-to-end data lake and real-time customer profiles for activation.
  • Ensure data quality, privacy, governance, and compliance across platforms.
  • Deliver migration strategies, validation documentation, and pilot/production artifacts.

Kenntnisse

Data architecture
SQL development
Data modeling
Data governance
Adobe Experience Platform (AEP)
API integration
REST/Postman
Python or Bash

Ausbildung

Bachelor's degree in Computer Science, Information Systems, Data Science, or related field

Tools

Postman
REST

Jobbeschreibung

Job Description: Ready to help shape what’s next in Adobe? Join Merkle’s Adobe Practice and help enterprise brands modernize the data foundations behind their digital experiences. This is an opportunity to tackle complex transformation challenges, influence future‑state architecture, and build scalable solutions across Adobe Experience Platform, Analytics, Content, and Commerce.

We are 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 — spanning data strategy, modeling, integration, and governance across Adobe Experience Platform, content operations, CRM systems, and commerce applications.

As an enterprise data architecture, you'll design the schemas, pipelines, and governance frameworks behind secure, scalable solutions that support unified profiles, segmentation, journey orchestration, and campaign activation for our customers.

What You'll Do

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. Analyze customer sources, data movement, data granularity, relationships, data format, etc. Unify disparate data (e.g., sales, CRM, analytics data, etc.) 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 (PII, PCI, HIPAA, GDPR, etc.). Engage with cross‑disciplinary groups and Adobe professionals to identify customer demands. Provide data layout and strategic blueprints, advocating for scalable, secure resolutions. Assume the role of a liaison to promptly tackle technical obstacles. 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. Employ REST APIs, Postman, and basic scripting to automate and streamline the implementation and setup. Develop and construct data ingestion solutions for streaming and batch processing, online and offline data within AEP. Collaborate with data engineers to develop and implement ETL/ELT pipelines for data collection and extraction. Improve data query performance across platforms by tuning models and adhering to guidelines and ensure product guardrails are followed and deployed in solutions Drives 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: evaluate taxonomy consistency, content metadata tagging practices and standards compliance, and commerce product data enrichment levels; flag redesign opportunities prior to modernization. Identify platform‑specific reconciliation and integration points and document data consistency requirements. Unify disparate data sources (CRM, call center, marketing, sales, content operations, commerce/order data) to meet customers' digital marketing, content, and commerce use cases within a single AEP foundation. Map legacy platform infrastructure to AEP schemas and CJA data views; determine what migrates directly, what requires transformation, and what should be redesigned for improved governance and cross‑domain insights. Design AEP data models (conceptual, logical, physical) across Analytics, Content, and Commerce domains—including event schemas, entity relationships, attribute hierarchies, identity resolution, content asset structures, and product data models. Develop relational and dimensional data models for analytics spanning multiple customer datasets (CRM, marketing, offline, point‑of‑sale, content, commerce) across RDBMS, columnar, data warehouse, and data lake environments. Architect AEP data ingestion pipelines (streaming, batch, online, offline) across Analytics, Content, and Commerce data sources; collaborate with data engineers to build automated ETL/ELT workflows maintaining data freshness and quality. Support end‑to‑end modernization migrations, preserving metric definitions, historical accuracy, content governance, and commerce data integrity through transition phases. Develop validation and reconciliation documentation for legacy‑vs‑modern platform comparisons in pilot and production.

Core Requirements

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, datasets (e.g., CRM, Call Center, Marketing, Offline, Point of Sale, etc.) with relational, hierarchical (e.g., RDBMS, Columnar, Data Warehouse, BI, Document, Semantic layer modeling, Data Lakes, OLTP & OLAP, etc.). Demonstrated experience auditing, assessing, and documenting data components of implementations; ability to translate complex data configurations and data models into clear business requirements and technical documentation. Advanced SQL skills including window functions, complex joins, aggregations, stored procedures, and query optimization for analytics workloads. Hands‑on experience with Adobe Experience Platform (AEP), 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 in a multi‑domain context. Proficiency in API‑first integration patterns (REST, webhooks, Postman) and basic scripting (Python or Bash) for data pipeline automation and validation. Excellent written and verbal communication and strong organizational skills; proven ability to balance concurrent customer engagements and distill complex architectures and migration strategies for executive and technical audiences. Degree in Computer Science, Information Systems, Data Science, or related technical field; equivalent work experience in a senior data architecture role considered.

Nice to Have
  • 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 (Content Hub, Commerce product data, personalization).
  • Hands‑on experience with Adobe Analytics API (Report API, Admin API) for automated assessment and documentation.
  • Experience with Analytics‑to‑CJA migration patterns, common reconciliation challenges, and metric mapping best practices.
  • 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.

The annual salary range for this position is $113,000 - $158,750. Placement within the salary range is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law.

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

Dentsu also complies with applicable state and local laws regarding employee leave benefits, including, but not limited to providing time off pursuant to the Colorado Healthy Families and Workplaces Act, in accordance with its plans and policies. For further details regarding Dentsu benefits, please visit www.dentsubenefitsplus.com.

Location: USA - Remote - Georgia. Brand: Merkle. Time Type: Full time. Contract Type: Permanent.

Dentsu is committed to providing equal employment opportunities to all applicants and employees. We do this without regard to race, color, national origin, sex, sexual orientation, gender identity, age, pregnancy, childbirth or related medical conditions, ancestry, physical or mental disability, marital status, political affiliation, religious practices and observances, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law.

Dentsu is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with us, please send an e‑mail to ApplicantAccommodations@dentsu.com by clicking on the link to let us know the nature of your accommodation request and your contact information. We are here to support you.

About dentsu For over 120 years, innovation is a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Be a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way. Find out more about us Who we are Our Social Impact Our work

Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

Solutions Architect, Adobe Experience Cloud
Solutions Architect, Adobe Experience Cloud

dentsu • Maryland

Remote
USD 94.000 - 155.000
Medical, vision, and dental insurance
Life insurance
401k
+1
Data Architect
Data Architect

Dentsu • USA

Remote
USD 113.000 - 160.000
Medical, vision, dental insurance
Life insurance
Disability insurance
+5
Experience Technical Architect, Innovation & Emerging Technologies
Experience Technical Architect, Innovation & Emerging Technologies

dentsu • Georgia

Remote
USD 136.000 - 190.000
Medical, vision, and dental insurance
Life insurance
Disability insurance
+5
Consulting Manager
Consulting Manager

dentsu • Georgia

Remote
USD 119.000 - 160.000
Medical, vision, and dental insurance
Life insurance
Disability insurance
+5
Business Consultant - Hightouch
Business Consultant - Hightouch

Dentsu International Americas, LLC • Colorado

Hybrid
USD 94.000 - 140.000
Medical, vision, dental insurance
Life insurance
401k
+2
USA - Remote - Georgia / Insights & Analysis
USA - Remote - Georgia / Insights & Analysis

Merkle Inc. • Georgia

Vor Ort
USD 113.000 - 160.000
Medical, vision, and dental insurance
Disability insurance
Flexible paid time off
+2
Business Analyst – Adobe Experience Cloud
Business Analyst – Adobe Experience Cloud

dentsu • California

Remote
USD 59.000 - 84.000
Medical, vision, and dental insurance
Life insurance
Disability insurance (short-term and长期
Business Analyst, Adobe Experience Manager (AEM)
Business Analyst, Adobe Experience Manager (AEM)

Dentsu International Americas, LLC • New York (NY)

Hybrid
USD 78.000 - 95.000
Medical, vision, and dental insurance
Life insurance
Disability insurance
+5
Lead Functional Architect
Lead Functional Architect

Dentsu International Americas, LLC • New York (NY)

Hybrid
USD 113.000 - 170.000
Medical benefits
Dental benefits
Life insurance
+4
Lead Solutions Architect
Lead Solutions Architect

Dentsu International Americas, LLC • Tennessee

Hybrid
USD 113.000 - 163.000
Medical, vision, and dental insurance
Life insurance
Disability insurance