> Markdown version of [/jobs/ext/2273705-lead-data-architect](https://www.wearedevelopers.com/jobs/ext/2273705-lead-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Data Architect

- **Company:** Q1 Technologies, Inc.
- **Location:** San Jose, CA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Big Data, Data Architecture, Distributed Data Store, Distributed Systems, Online Transaction Processing, Oracle (Applications), Systems Architecture, Transaction Processing (Computing), Crud
- **Published:** August 27, 2026
- **Apply:** https://www.careerbuilder.com/job-details/lead-data-architect-google-spanner-san-jose-ca--616b5eaa-871e-4cb3-96ba-c5d62784f22b

## About the Role

* 10+ years in large-scale data architecture
 * Deep expertise in Google Spanner internals:
o TrueTime
o Distributed transactions
o Synchronous replication

 * Experience designing petabyte-scale, multi-region OLTP systems
 * Strong understanding of:
o Distributed consistency models
o Failure modes in globally distributed databases

 * Prior Oracle * distributed DB migration experience strongly preferred

Skills:
Analysis Skills, Architectural Services, Data Modeling, DataArchitect Data Modeling Tool, Distributed Computing, Distributed Databases, Editing, Identify Issues, Leadership, Mentoring, Quality Assurance, Scorecarding, System Architecture, Transaction Processing/Management

## Description

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 retry-safe patterns.
Compatibility & Contract Validation

 * Work with QA and platform teams to validate:
o CRUD contracts
o Query semantics
o Transaction invariants

 * Review and sign off on schema compatibility scorecards.
Performance & Scalability

 * Participate in workload replay analysis.
 * Diagnose and resolve:
o Hot key risks
o Transaction conflicts
o 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.


## Related Videos

- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Rest API Antipatterns](https://www.wearedevelopers.com/videos/100208-rest-api-antipatterns)
- [Why and when should we consider Stream Processing frameworks in our solutions](https://www.wearedevelopers.com/videos/1085-why-and-when-should-we-consider-stream-processing-frameworks-in-our-solutions)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Analytics in the Age of Agentic AI: A tour of ClickHouse and Langfuse](https://www.wearedevelopers.com/videos/100240-analytics-in-the-age-of-agentic-ai-a-tour-of-clickhouse-and-langfuse)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Why Event-Driven Architecture Isn’t About Speed (and When You Actually Need It)](https://www.wearedevelopers.com/magazine/745-why-event-driven-architecture-isn-t-about-speed-and-when-you-actually-need-it)
- [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)
- [What does the history of data storage tell us about the future?](https://www.wearedevelopers.com/magazine/495-what-does-the-history-of-data-storage-tell-us-about-the-future)