Lead Data Architect (Google spanner)

Diverse Lynx LLC

San Jose, United States of America

3 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Senior

Compensation

$ 130K

Job location

San Jose, United States of America

Tech stack

Big Data

Data Architecture

Distributed Data Store

Distributed Systems

Online Transaction Processing

Oracle Applications

Crud

Job description

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+ applications-before large-scale app rewrites occur. This role is not a schema converter. It is a distributed systems architect role., 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., Compensation: DOE Seeking an experienced and highly motivated Lead Business Analyst to support the design and implementation of various critical technology initiatives for the Fi…