Lead Data Architect (Google spanner) jobs in United States
cer-icon
Apply on Employer Site
company-logo

NuStar Technologies · 4 hours ago

Lead Data Architect (Google spanner)

NuStar Technologies is seeking a Lead Data Architect to own the target-state data architecture on Google Spanner. The role involves ensuring the new data model meets various requirements for over 1000 applications, and includes responsibilities like defining logical data models, designing physical schemas, and validating contracts with QA teams.

AnalyticsConsultingEnterprise Resource Planning (ERP)IT ManagementStaffing Agency
check
H1B Sponsor Likelynote

Responsibilities

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
Define the Logical Canonical Data Model (LCDM) independent of physical storage
Design Spanner-native physical schemas:
Row key distribution (hotspot avoidance)
Interleaving decisions
Secondary index strategy
Decide where denormalization, projections, or materialized views are required
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
Work with QA and platform teams to validate:
CRUD contracts
Query semantics
Transaction invariants
Review and sign off on schema compatibility scorecards
Participate in workload replay analysis
Diagnose and resolve:
Hot key risks
Transaction conflicts
Index amplification
Size Spanner instances and estimate cost envelopes

Qualification

Google Spanner expertiseLarge-scale data architectureDistributed transactionsPetabyte-scale OLTP systemsCanonical logical data modelTransaction design guidelinesPerformance readiness assessmentsMigration readiness sign-offFailure modes in databasesIndex strategies

Required

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
Distributed consistency models
Failure modes in globally distributed databases
Canonical logical data model
Spanner physical schemas & index strategies
Transaction design guidelines
Performance readiness assessments
Migration readiness sign-off per domain

Preferred

Prior Oracle → distributed DB migration experience strongly preferred

Company

NuStar Technologies

twittertwitter
company-logo
NuStar Technologies provides staffing, recruiting, cloud enablement, ERP implementation, analytics, web solution, and managed services.

H1B Sponsorship

NuStar Technologies has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2023 (3)
2022 (1)
2020 (3)

Funding

Current Stage
Early Stage
Company data provided by crunchbase