Key Responsibilities

Data Architecture & Modeling

" Define the Logical Canonical Data Model (LCDM) independent of physical storage.

" Design Spanner-native physical schemas:

o Primary key strategy

o Row key distribution (hotspot avoidance)

o Interleaving decisions

o Secondary index strategy

" Decide where denormalization, projections, or materialized views are required.

Transaction & Consistency Design

" Define transaction boundaries under Spanner constraints:

o Single-partition vs multi-partition transactions

o Atomicity and consistency trade-offs

" Classify workloads by strong consistency vs bounded staleness tolerance.

" Define idempotency and re...