What are the responsibilities and job description for the Senior Data Architect position at Kismet Search?
TL;DR: Fast growing Technology Firm in San Diego, CA. Digital marketing, ecommerce and 3PL platform supporting 200 brands is hiring a Principal Data Architect to rebuild and future-proof its data foundation. BigQuery and Snowflake are in place, but governance, modeling discipline, and architectural consistency need a reset. You will clean up the current warehouse, define the canonical data model, and architect a scalable platform that supports analytics, logistics, pricing, and customer dashboards.
POSITION DETAILS
Our client is seeking a hands-on Principal Data Architect to stabilize, modernize, and redesign our data ecosystem. This leader will define the long-term data architecture strategy while addressing immediate challenges within our current warehouse environment.
Their systems ingest high-volume data feeds, scraped competitive data, warehouse management data, and ERP/WMS-related operational datasets. The current environment leverages BigQuery and Snowflake but lacks architectural consistency and best-practice governance.
Core Architecture Responsibilities:
- Own the canonical enterprise data model across ecommerce, marketplace feeds, warehouse operations, and financial systems.
- Define and enforce data contracts between ingestion pipelines, operational systems, and analytics layers to ensure schema consistency and reliability.
- Design clear separation between operational and analytical data systems, ensuring warehouse, WMS, and transactional systems remain performant while enabling scalable analytics.
- Architect reconciliation and validation logic to ensure data accuracy across Amazon feeds, inventory systems, financial reporting, and customer dashboards.
- Develop deep expertise in Amazon marketplace data structures, including Seller/Vendor feeds, product performance metrics, and pricing data flows.
- Design data architecture spanning multiple systems, including warehouse management, accounting/financial workflows, and client-facing analytics portals.
QUALIFICATIONS
- 8 years in data engineering, data architecture, or platform engineering
- Deep experience with BigQuery and/or Snowflake in production environments
- Experience designing canonical data models in ecommerce, retail, or logistics environments
- Strong understanding of Amazon Seller/Vendor data feeds preferred
- Experience integrating ERP, WMS, or 3PL systems highly desirable
- Expertise in ingestion pipelines, data transformation frameworks, and warehouse optimization
- Familiarity with cost governance in large-scale analytics environments, preferred
- Experience managing or mentoring engineers and external vendors preferred but not required
- Location: Position is based in San Diego working hybrid onsite ~3 days per week
Ideal Industry Background:
We are especially interested in candidates who have worked in:
- Ecommerce platforms
- Digital agencies managing marketplace brands
- 3PL or logistics environments
- Retail data analytics
- High-volume data feed environments