Data Architect

Position Details

**Role:**Senior Data Architect

Location: Bangalore-Hybrid

Experience Required: 8+

Role Overview

This role requires deep data expertise that goes beyond tool familiarity. The ideal candidate will have worked close to the data layer, modelling it, mapping it, and querying it at scale across complex enterprise environments.

Relevant Backgrounds

Candidates may come from any of the following areas:

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.

Key Responsibilities

Understand source systems and map them to AEP XDM Schemas using L

LDM methodology.

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

joins, filters, and aggregations.

Own source to target mapping, metadata documentation, and schema

governance.

Required Skills and Experience

Strong data modelling fundamentals covering relationships, keys, and

cardinalities.

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.