Technical Lead

Job Summary

Owns the canonical, extendable AlloyDB order data model underpinning OMX, ensuring the schema scales cleanly from Milestone 1 (Furniture orders) to future business-line onboarding.

Key Responsibilities

Key Responsibilities

• Design and maintain the canonical, extendable order data model on AlloyDB (PostgreSQL) shared across every business line
• Apply normalization and schema-design best practices to support decoupled, independently scalable services
• Tune SQL performance and indexing strategy for high-volume order, shipment, and purchase-order tables
• Partner with the Technical Architect and Java Technical Leads on data-access patterns and connection-pool limits
• Validate the data model against Staples' Enterprise Architecture team and version data contracts for downstream consumers
• Support Redis caching strategy for high-read OMS journeys

Skill Requirements

Mandatory Skills (Core Technical)

• AlloyDB (PostgreSQL)
• Canonical/extendable order data model design
• Normalization & schema design
• SQL performance tuning & indexing

Optional Skills (Upgradeable from Adjacent Experience)

• Any RDBMS experience (Oracle/MySQL/SQL Server) — upgradeable to AlloyDB (PostgreSQL-compatible)
• NoSQL experience (MongoDB) — potential upgrade to Couchbase (usage unconfirmed)

Trainable Skills (Enabled via SME-led Training / Day-0 Onboarding)

• GCP data services (Cloud SQL/BigQuery) if new to GCP
• Basic AI agent/skill usage in data modeling

Other Requirements

Experience & Qualifications

• 8+ years in data modeling/database design, including large-scale transactional systems
• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent practical experience
• Comfortable working in a squad-based Agile delivery model with onsite/offshore collaboration

Program Context

Staples operates a fragmented order-management landscape spanning eight legacy platforms (COMS, CFS, SOMS/Sterling, and several custom orchestration layers) across B2B, B2C, Services, and 3PL commerce. The OMX Transformation program consolidates these into a single, cloud-native, event-driven Order Management platform ("OMX") — built on Java/Spring Boot microservices on Google Kubernetes Engine (GKE), with Temporal workflow orchestration, a Drools or config-driven business-rules engine, Solace Pub/Sub event messaging, Azure API Management, and AlloyDB/Redis for transactional and caching data.

Milestone 1 scope is to design, build, test, and deploy product-only Furniture orders on OMX — approximately 25% of CFS volume — establishing a reusable architecture for future onboarding of B2B OMS, B2C OMS, 3PL, Projects, and beyond. The program targets a Q1 go-live, delivered through a squad-based Agile model with onsite/offshore delivery teams, governed by HCLTech's AIForce ALM DevSecOps framework and accelerated by GHCP/VibePath AI-assisted engineering.

The roles below reflect the Program/Strategy Team, the squad-based Delivery Team (Technical Architecture, Java/UI development, and DB Modeling), and the Quality Engineering track (test strategy, automation/SDET, and performance testing) required to deliver Milestone 1. Each job description lists mandatory core-technical skills, optional skills that are upgradeable from adjacent experience, and skills that can be enabled through SME-led or Day-0 training.