Database Architect Amazon.com Services LLC
- $60,000–$80,000 Per Year
- Full-time
| Location | (Remote) |
| Job Type | Contractor, Full-time |
| Salary | $85–$90 Per Hour |
| Company Size | 201 - 500 |
| Headquarters | Livonia, MI, US |
| Website | https://plugins-inc.com/ |
Job Title: Data Architect - Adobe Analytics
Location: Wilmington, DE
Location Options: Remote
Experience: 10+ Years
Employment Type: W2
Job summary:
We are seeking an experienced Data Architect to lead the design and implementation of a modern customer data and analytics platform that integrates Adobe Analytics clickstream data, customer identity resolution, and enterprise data warehouse capabilities. The architect will define scalable data models, identity stitching frameworks, governance processes, and analytics-ready datasets supporting digital marketing, customer journey analytics, membership conversion tracking, campaign attribution, and Customer 360 initiatives. The role requires deep expertise in Adobe Experience Cloud (Adobe Analytics, ECID, A4T integrations), enterprise data warehousing, customer identity management, and large-scale behavioral data platforms.
Responsibilities:
- Lead the data architecture workstream for a MarTech Optimization initiative defining the end-to-end data strategy from web engagement capture through to analytics ready dimensional models in BigQuery
- Architect ingestion and integration of Adobe Analytics clickstream data into enterprise analytical platforms
- Design scalable solutions for capturing web behavioral data including Page visits, Button clicks, User journeys, Campaign interactions, Offer impressions and responses
- Define architecture for Adobe Analytics EVAR management and downstream consumption
- Establish enterprise standards for EVAR inventory, metadata documentation, and governance
- Design and implement Customer 360 identity frameworks
- Architect identity stitching capabilities across Adobe Experience Cloud ID (ECID), internal Identities, device identifiers, browser identifiers, Cookie-based identifiers and Sitecore customer attributes
- Design ingestion pipelines to land Adobe Analytics data via Data Feeds or Reporting API into GCP Cloud Storage as a raw/staging layer
- Define file formats, partitioning strategies, and schema standards for the staging area
- Design conceptual, logical, and physical data models supporting Customer 360, Digital behavior analytics, Marketing attribution, and Journey analytics
- Develop dimensional modeling designing fact and dimension tables for marketing and clickstream data
Qualifications and skills:
- 10+ years in Data Architecture, Data Warehousing, or Customer Data Platforms
- 5+ years architecting Adobe Experience Cloud solutions
- Experience implementing enterprise Customer 360 solutions
- Experience with large-scale clickstream and digital analytics platforms
- Hands-on experience supporting marketing analytics and attribution use cases
- Deep hands-on experience with Adobe Analytics implementation concepts including eVars, props, events, and success metrics
- Strong understanding of attribution models (last touch, first touch, linear, participation)
- Experience with customer journey tracking across Anonymous sessions, authenticated sessions and mobile to offline interactions
- Experience with clickstream data structures understanding session, hit, and visitor-level granularity
- Experience creating deterministic and probabilistic matching strategies
- Experience with GCP Cloud Storage, BigQuery, batch feed ingestion, incremental loads, and schema evolution

