About the role
- Role: Data Architect
- Experience Required: 5+
- Cloud Data Warehouses such as BigQuery, Snowflake, Redshift, or Synapse, with experience modelling and querying large, complex datasets.
- Marketing Tech or Campaign Platforms, with ownership of source to target mapping, metadata mapping, and data dictionaries (not campaign execution).
- MDM Platforms, with hands on work in master data, entity resolution, and identity stitching.
- Understand source systems and map them to AEP XDM Schemas using L
- Work with structured and semi structured data formats across diverse pipelines.
- Define entity relationships, cardinalities, and ER diagrams.
- Write and optimise SQL at source and within AEP Query Service, including
- Own source to target mapping, metadata documentation, and schema
- Strong data modelling fundamentals covering relationships, keys, and
- Hands on SQL experience across source systems and large-scale query engines.
- Experience producing data dictionaries and source to target mapping documents.
- Ability to independently map a source system to a target schema.