Sr. Data and Platform Engineer

Postgres
UNITED STATES
October 20, 2026
Full Time
Apply Now

Job Description

Company: Gatekeeper Systems, Inc.
Location: Foothill Ranch, CA
Workplace Type: On-site
Employment Type: Full-time

About the Role

At Gatekeeper Systems, we’re revolutionizing retail loss prevention and customer safety through a powerful combination of physical deterrents and cutting-edge technology—including AI, computer vision, and facial recognition. This is a senior hands-on engineering role at the center of our data platform transformation. You will own the backend data infrastructure — relational database design, cloud data warehouse architecture, and the API layer that connects them to customer-facing products and internal analytics tools.

What You’ll Do / Key Responsibilities

  • Relational Database Design & Operations: Own the operational PostgreSQL database end-to-end, including schema design, migration tracking, indexing strategy, connection pooling, high availability configuration, point-in-time recovery, and read replica management on Google Cloud SQL.
  • Data Modeling & Multi-Tenancy: Build data models powering product features, customer reporting, and device management while enforcing multi-tenant data isolation with row-level security at the database layer.
  • Cloud Data Warehouse Architecture: Design and build a clean, layered BigQuery data warehouse architecture organized into raw ingestion, curated analytics, and pre-aggregated intelligence layers.
  • API Design & Backend Engineering: Design, build, and maintain GraphQL and REST APIs that customer applications, internal analytics tools, and LP workflow platforms read from.
  • GCP Infrastructure & DevOps: Own GCP data infrastructure as code using Terraform, build CI/CD pipelines, and maintain security posture across managed database and analytics warehouse components.
  • Production Support & Mentoring: Serve as the technical escalation point for data platform issues, mentor junior and offshore developers, and collaborate closely with product and hardware teams.

Requirements & Qualifications

  • 7+ years of hands-on backend data engineering experience with clear ownership of production systems.
  • Deep PostgreSQL expertise: schema design, query optimization, indexing, migration management, connection pooling, and managed cloud database operations (high availability and PITR).
  • BigQuery mastery: partitioning and clustering strategy, materialized views, BI Engine, authorized views, and row-level security.
  • Production-quality Python experience on serverless compute, event-driven functions, and GCP SDK integrations.
  • Comprehensive GCP platform depth across managed databases, analytics warehouses, object storage, messaging, serverless compute, and infrastructure-as-code with Terraform.
  • Proven experience designing and maintaining production REST or GraphQL APIs with authentication and role-based access control.
  • Demonstrated commitment to security by default (credentials in secrets management, least-privilege service accounts, audit logging).
  • AI-native productivity using Claude AI or equivalent tools daily for design research, code generation, and documentation.

Preferred / Bonus Qualifications (if applicable)

  • GoLang familiarity for device event pipeline contributions.
  • Real-time OLAP database experience (ClickHouse, Apache Pinot, or similar).
  • Experience with dbt or Dataform for transformation layer definition.
  • ML pipeline or MLOps exposure.
  • Domain knowledge in retail technology, IoT, physical security, or loss prevention.

Gatekeeper Systems, Inc. is an Equal Opportunity Employer. We are committed to developing a diverse workforce and cultivating an inclusive environment, and do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status, or any protected basis.

Related Jobs