{"schemaVersion":"jobsearcher.job.v1","id":"48fb46224cbd78dacdda6f40","url":"https://jobsearcher.com/jobs/48fb46224cbd78dacdda6f40","canonicalUrl":"https://jobsearcher.com/jobs/48fb46224cbd78dacdda6f40","title":"Remote - Lead Data Architect (Google spanner)","description":"Position : Lead Data Architect (Google spanner)Location :RemoteDuration: Full TimeOwn 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.Key ResponsibilitiesData Architecture & Modeling• Define the Logical Canonical Data Model (LCDM) independent of physical storage.• Design Spanner-native physical schemas:o Primary key strategyo Row key distribution (hotspot avoidance)o Interleaving decisionso 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 transactionso 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:o CRUD contractso Query semanticso Transaction invariants• Review and sign off on schema compatibility scorecards.Performance & Scalability• Participate in workload replay analysis.• Diagnose and resolve:o Hot key riskso Transaction conflictso 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:o TrueTimeo Distributed transactionso Synchronous replication• Experience designing petabyte-scale, multi-region OLTP systems• Strong understanding of:o Distributed consistency modelso Failure modes in globally distributed databases• Prior Oracle → distributed DB migration experience strongly preferred","company":"KPG","rawCompany":"kpg99","isRemote":true,"isActive":false,"createdAt":"2026-05-30T23:02:04.930Z","occupations":[{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Remote - Lead Data Architect (Google spanner)","description":"Position : Lead Data Architect (Google spanner)Location :RemoteDuration: Full TimeOwn 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.Key ResponsibilitiesData Architecture & Modeling• Define the Logical Canonical Data Model (LCDM) independent of physical storage.• Design Spanner-native physical schemas:o Primary key strategyo Row key distribution (hotspot avoidance)o Interleaving decisionso 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 transactionso 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:o CRUD contractso Query semanticso Transaction invariants• Review and sign off on schema compatibility scorecards.Performance & Scalability• Participate in workload replay analysis.• Diagnose and resolve:o Hot key riskso Transaction conflictso 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:o TrueTimeo Distributed transactionso Synchronous replication• Experience designing petabyte-scale, multi-region OLTP systems• Strong understanding of:o Distributed consistency modelso Failure modes in globally distributed databases• Prior Oracle → distributed DB migration experience strongly preferred","datePosted":"2026-05-30T23:02:04.930Z","dateModified":"2026-05-30T23:02:04.930Z","hiringOrganization":{"@type":"Organization","name":"KPG","sameAs":"https://jobsearcher.com"},"jobLocationType":"TELECOMMUTE","applicantLocationRequirements":{"@type":"Country","name":"US"},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"48fb46224cbd78dacdda6f40"},"url":"https://jobsearcher.com/jobs/48fb46224cbd78dacdda6f40"}}