Data Science Data Engineering / BigQuery / PostgreSQL / Python / GCP - OC

Motion Recruitment
  • Lake Forest, CA
  • $140,000–$155,000 Per Year
1 day ago

Job Description

Our client is a retail technology company developing connected devices and cloud software to help retailers improve loss prevention and customer safety. Its platform brings together device events, operational data, analytics, and customer-facing applications across store locations.

The company is expanding its data platform on Google Cloud and is seeking a hands-on engineer with strong BigQuery, PostgreSQL, GCP, Python, backend development, and data warehousing experience.

This role sits at the intersection of data engineering and backend development. You will build and improve the PostgreSQL database, BigQuery warehouse, data pipelines, and APIs that support customer products and internal reporting.

The ideal candidate has roughly 3-7 years of relevant experience and has personally built and supported production systems. You will work with other engineers and operations teams to solve data problems, improve reliability, and deliver new capabilities.

Responsibilities
  • Design and maintain PostgreSQL schemas, queries, indexes, migrations, and production database operations on Google Cloud SQL.
  • Build and improve BigQuery datasets, data models, analytical views, and reporting pipelines.
  • Develop Python services and data pipelines that move information between operational systems, event streams, and the warehouse.
  • Build secure REST or GraphQL APIs that make data available to customer applications and internal tools.
  • Improve data quality, pipeline reliability, query performance, and cloud costs.
  • Help enforce access controls and separation of customer data throughout the platform.
  • Use GCP services and Terraform to deploy and maintain data infrastructure.
  • Investigate production issues, work with engineering and operations teams on fixes, and share knowledge through code reviews and collaboration.
Required Skills / Tech
  • Roughly 3-7 years of hands-on data engineering or backend development experience.
  • Strong, direct BigQuery experience, including data modeling, analytical queries, performance optimization, and warehouse design.
  • Strong PostgreSQL experience, including schema design, query optimization, indexing, and production database work.
  • Hands-on GCP experience, particularly with BigQuery, Cloud SQL, and services used to run data pipelines or backend applications.
  • Production Python development experience for backend services, data pipelines, or cloud integrations.
  • Experience building and maintaining data warehouses and reliable data flows.
  • Experience developing APIs or backend services used by production applications.
Preferred Skills / Tech
  • Experience using AI tools or integrating AI capabilities into products or engineering workflows.
  • Experience with event-driven systems, change data capture, or device-generated data.
  • Terraform, CI/CD, and GCP infrastructure experience.
  • Experience with multi-tenant applications, access controls, and data security.
  • Familiarity with retail technology, IoT, or loss prevention.
  • Experience working with hardware, firmware, or distributed engineering teams.
The Offer
  • Attractive total compensation package between 140-155k
  • Comprehensive healthcare benefits including medical, dental, and vision coverage; Life/ADD/LTD insurance; FSA/HSA options
  • 401(k) Plan with employer match
  • Generous paid time off policy
  • Observance of 11 paid company holidays

Numbers & Facts

LocationLake Forest, CA
Salary$140,000–$155,000 Per Year

Skills

  • Access Controlunmatched
  • Application Programming Interface (API)unmatched
  • Artificial Intelligence (AI)unmatched
  • Cloud Computingunmatched
  • Code Reviewsunmatched
  • Computer Firmwareunmatched
  • Customer Support/Serviceunmatched
  • Customer/Client Researchunmatched
  • Data Analysisunmatched
  • Data Collectionunmatched
  • Data Managementunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Data Scienceunmatched
  • Data Warehousingunmatched
  • Database Designunmatched
  • Flexible Spending Accountsunmatched
  • GCP (Good Clinical Practices)unmatched
  • GraphQLunmatched
  • Information Technology & Information Systemsunmatched
  • Internet of Thingsunmatched
  • Loss Preventionunmatched
  • Operational Auditunmatched
  • Performance Tuning/Optimizationunmatched
  • PostgreSQLunmatched
  • Problem Solving Skillsunmatched
  • Process Improvementunmatched
  • Product Engineeringunmatched
  • Product Supportunmatched
  • Production Supportunmatched
  • Production Systemsunmatched
  • Python Programming/Scripting Languageunmatched
  • Quality Managementunmatched
  • Query Optimizationunmatched
  • REST (Representational State Transfer)unmatched
  • Reliability Engineeringunmatched
  • Retailunmatched
  • Retail Softwareunmatched
  • SQL (Structured Query Language)unmatched
  • Software Engineeringunmatched
  • Training Data Setsunmatched
  • Warehousingunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder