Data Architect, Product Modernization
$113k - $158.75kDentsu Group
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 available with this position include:
• 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, and
• 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
To begin the application process, please click on the “Apply” button at the top of this job posting. Applications will be reviewed on an ongoing basis, and qualified candidates will be contacted for next steps.
At dentsu, we believe great work happens when we’re connected. Our way of working combines flexibility with in-person collaboration to spark ideas and strengthen our teams. Employees who live within a commutable distance of one of our hub offices, currently located in Chicago, metro Detroit, Los Angeles, and New York City, are required and expected to work from the office three days per week (two days per week for employees based in Los Angeles). Dentsu may designate other Hub offices at any time. Those who live outside a commutable range may be designated as remote, depending on the role and business needs. Regardless of your work location, we expect our employees to be flexible to meet the needs of our Company and clients, which may include attendance in an office.
Location:
USA - Remote - GeorgiaBrand:
MerkleTime Type:
Full timeContract Type:
PermanentDentsu 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 View email address on us.fitly.work 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.
$125k - $175k
...You Are We’re looking for a Senior Data Analyst to join ShopMy’s growing Data &... ...become a dedicated analytics partner to Product, Engineering, and Design. This role is about... ...and pipelines, and operating within modern cloud data warehouses ~ Strong experience...SuggestedFull timeWork experience placementImmediate startRemote workHome officeFlexible hours- ...Focused on building a robust technical foundation for product analytics, the full-time remote Staff Product Data Analyst will collaborate with Engineering, Product,... ...as Segment or RudderStack Strong understanding of modern cloud data platforms such as Snowflake, BigQuery,...SuggestedFull timeRemote work
$118k - $222k
...re looking for associates who are passionate about delivering extraordinary care.As a Product Architect you will be responsible for providing solution scoping and build services on data-centric enterprise initiatives in support of data and analytic needs. You will have...SuggestedFull timeTemporary workPart timeCasual workWork at officeRemote work2 days per week$84.4k - $127k
...for those navigating care with guidance, products, and services that meet families where they... ...hours of 9am-5pm EST.YOUR ROLEThe Data Product & Integration Analyst serves as a... ...familiarity with data warehouse, data lake, and modern data architecture concepts.Strong...SuggestedFull timeWork experience placementWork at officeLocal areaRemote work$132.4k - $251.6k
...defense.Responsible for one or more of the Collins Aerospace Production Master Data (PMD) objects including, but not limited to, material... ...in digital. If you’re an agile thinker who enjoys utilizing modern technology to make big improvements, then you’re a perfect fit...SuggestedContract workTemporary workWork experience placementRemote workFlexible hours$86 - $119 per hour
...recruitment team will provide more details.We are seeking a Product Analyst, Enterprise Data Catalog to support the evolution and adoption of our... ...and adoption trends, and contribute to the overall modernization of the organization's data management capabilities.This...Full timeWork at officeLocal areaRemote work1 day per week$126.4k - $164.3k
...The Opportunity The Data Architect defines and advances the organization's enterprise data... ...integration patterns support phased modernization. The Data Architect partners closely... ...they have the tools necessary to be productive, whether they choose to work remotely,...Work at officeRemote workWork from homeFlexible hours- ...of our company. About the Role Rain is hiring a Senior Product Data Analyst to be the analytical engine behind our product team.... ...with at least one analytics scripting language (Python or R), modern data warehouses (Snowflake, BigQuery, Redshift, or similar), and...Full timeLive inWork at officeWork from homeWorldwideFlexible hours
$97k - $175k
...CrowdStrike protects the people, processes and technologies that drive modern organizations. Since 2011, our mission hasn’t changed — we’re... ...starts with you. About the Role CrowdStrike's Product Security team breaks the mold of traditional internal security...Permanent employmentWork experience placementWork at officeLocal areaRemote work$118k - $212k
...CrowdStrike protects the people, processes and technologies that drive modern organizations. Since 2011, our mission hasn’t changed — we’re... ...starts with you. About the Role CrowdStrike's Product Security team breaks the mold of traditional internal security...Permanent employmentWork experience placementWork at officeLocal areaRemote work$225k - $235k
...Global Services is looking for a talented Data Architect to design and govern the data foundation that powers analytics, reporting and product decision across multiple government... ...one cloud platform ~ Experience with modern data platforms such as [Snowflake, Databricks...Full timeContract workPart timeFor contractorsRemote work$162k - $212k
...How do we do it? We provide cutting-edge products and services that enhance the trading... ...constantly evolving, pushing boundaries, and modernizing the futures industry. Our commitment to... ...costs anyone money. As aStaff Product Data Analyst, you'll own building and maintaining...Work at officeRemote workWorldwideMonday to FridayFlexible hours- ...the technical design behind modernizing AccuWeather For Business — the... ...that delivers AccuWeather’s data and services to more than half... ...0? We are looking for a Data Architect I who combines strong platform... ...a customer-facing production platform, and design appropriate...Full timeLocal areaRemote work
$127.84k - $197.87k
...workforce that is exponentially more creative and productive. For more information, visit Empower AI is... ...Position Summary We are seeking a Senior Data Architect to establish the data architecture for a modern GSA digital application environment. This individual...Full timeFor contractors$160k - $200k
...entrepreneurial company with a data-first mindset. We bring... ...time and batch ingestion using modern orchestration and streaming frameworks... ...with stakeholders, cloud architects, and delivery leads to drive... ...platforms with data products and medallion architectures...Full timeLocal area- ...Job Title :Data Architect US Remote Visa :GC , USC(Non Indians) Role Overview... ..., and growth across GTM, Finance, Product, Customer Experience, and Operations.... ...who can actively simplify complexity, modernize fragmented ecosystems, and build enterprise...Remote work
$138k - $200.1k
...this time, including CPT/OPT. The Data Architect will analyze, design, and implement... ...analytics, reporting, and operational data products. Working with data architects,... ...and data visualization tools. Apply modern data architecture patterns, including data...16 hoursContract workTemporary workWork experience placementCasual workWork at officeLocal areaRemote workWork from homeWork visaFlexible hours- ...We are seeking an experienced Product Architect to shape the design and evolution of innovative cybersecurity... ...security challenges involving data analytics, attack detection, and... ...lifecycle (SDLC), web technologies, and modern architecture principles to ensure high-quality...Work at officeRemote workWorldwideFlexible hours
- ...the core enterprise account, converge product and telemetry data into the Construction Data Cloud, and... ...that teams can copy. Architect the decoupled raw layer on Iceberg tables... ...SQL, and working fluency in dbt and modern ELT practices. Design experience with...Contract workRemote work
- ...Overview The Principal Product Architect will play a pivotal role in leading the design and architecture... ...and regulations, with a strong focus on data security and privacy. Produces and... ...AWS. ~5 years experience with modern development practices such as CI/CD,...Temporary workRemote workWork from homeHome officeNight shift
$180k - $220k
...Piper Solutions is seeking an experienced Product Architect to support a leading technology and... ...and trusted advisor, helping customers modernize legacy engineering tools and processes... ...test planning, test case execution, test data preparation, and requirements traceability...Remote work- ...additives, vaccines, nutritional specialty products, and mineral nutrition. We strive to be... ...for this role or other positions.The Data Architect is an integral part of our Digital... ...not limited to:Key Responsibilities1. Modern Data Architecture LeadershipOwn and enhance...Remote workWorldwideMonday to Friday
- ...bespoke solutions powered by data and technology for several Fortune... ...large-scale cloud and data modernization initiatives that transform... ...with business goals. The Data Architect will support enterprise data... ...using Kafka. # Partner with product owners, domain architects,...Local areaRemote work
- ...Microsoft Fabric/Cloud Solution Architect for a 3-month project-based... ...Microsoft Fabric environment and modernizing existing Azure Synapse workloads. The Senior Data Architect will partner with architecture... ...Microsoft Fabric experience in production or enterprise-scale...Hourly payContract workRemote work
- ...Role: Principal Data & AI Architect Location: Dallas, TX - Remote (Locals Preferred) We... ...scalable architecture and practical, production-ready solutions. This role requires someone... ...deep technical leadership across modern data platforms, data architecture, data...Full timeFor contractorsLocal areaRemote work
$107.5k - $188.4k
Help product teams understand how clinicians and care teams engage with UpToDate's clinical... ...customer-facing teams to turn product data into clear insights, better decisions, and... ...customer journey analytics. Experience with modern data platforms and business intelligence...Full timeWork at officeRemote work- ...Job Description Job Description Data Architects 6 12-month contract that may go perm... ...in the Architecture community to drive modernization opportunities for the advancement of PBM... ...and guidance to Engineering and Product teams across the organization. Architect...Permanent employmentContract workLocal areaRemote work
- ...Overview We are seeking a Data Architect to lead the data architecture for a federal modernization initiative supporting permitting and natural resource management... ..., GIS integration, and governed data products. The environment includes Amazon S3, Apache...Remote work
- ...Responsibilities: Architect scalable, high-performing data solutions to meet both functional and non-functional... ...objectives, data strategy, and modernization initiatives. Partner directly... ...of hands-on experience delivering production-ready Databricks solutions. ~ Strong...Full timeRemote work
- Acxiom, a leader in data services, is seeking a Data Analyst to support next‑gen products across US and global operations. You will work hands‑on with modern technologies to build scalable data products, evaluate data partners, and ensure data quality before release. Join...Remote job
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Architect, Product Modernization. Be the first to apply!





