Lead Data Architect

Q1 Technologies, Inc.

San Jose, CA, United States

10 days ago

Apply on www.careerbuilder.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

www.careerbuilder.com

Tech stack

Big Data Data Architecture Distributed Data Store Distributed Systems Online Transaction Processing Oracle (Applications) Systems Architecture Transaction Processing (Computing) Crud

Job 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.

Requirements

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

About the company

Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.

Company Size: 500 to 999 employees

Industry: Computer/IT Services