Data Architect- Google Spanner, Scottsdale

Lead Data Architect - Google Spanner

Own the target-state data architecture on Google Spanner, ensuring the new data model satisfies functional correctness, performance SLOs, and transactional semantics required by 1000+ applicationsbefore large-scale app rewrites occur. This role is not a schema converter. It is a distributed systems architect role.Key Responsibilities Data Architecture&Modeling Define the Logical Canonical Data Model (LCDM) independent of physical storage. Design Spanner-native physical schemas: Primary key strategy Row key distribution (hotspot avoidance) Interleaving decisions Secondary index strategy Decide where denormalization, projections, or materialized views are required.Transaction&Consistency Design Define transaction boundaries under Spanner constraints: Single-partition vs multi-partition transactions Atomicity and consistency trade-offs Classify workloads by strong consistency vs bounded staleness tolerance. Define idempotency and retry-safe patterns. Compatibility&Contract Validation Work with QA and platform teams to validate: CRUD contracts Query semantics Transaction invariants Review and sign off on schema compatibility scorecards. Performance&Scalability Participate in workload replay analysis. Diagnose and resolve: Hot key risks Transaction conflicts Index amplification Size Spanner instances and estimate cost envelopes. Leadership Act as final authority for Spanner data design decisions. Mentor domain architects and engineers.Provide executive-level architectural rationale. Required Skills&Experience 10+ years in large-scale data architecture Deep expertise in Google Spanner internals: TrueTime Distributed transactions Synchronous replication Experience designing petabyte-scale, multi-region OLTP systems Strong understanding of: Distributed consistency models Failure modes in globally distributed databasesPrior Oracle ? distributed DB migration experience strongly preferred Key Deliverables Canonical logical data model Spanner physical schemas&index strategies Transaction design guidelines Performance readiness assessments Migration readiness sign-off per domain Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.