Data Engineer: BigQuery & PostgreSQL on GCP (Python)

Motion Recruitment; Lake Forest (CA); On-site; USD 140,000 - 155,000; Full time

Benefits offered by this job

Healthcare benefits (medical, dental,/

Vision coverage

401(k) Plan with employer match

Generous paid time off

Job summary

Motion Recruitment seeks a hands-on data platform engineer to expand our client's data platform on Google Cloud. You will build and optimize PostgreSQL and BigQuery warehouses, develop Python data pipelines, and expose data through secure APIs for customer products and internal reporting.

The ideal candidate has 3–7 years of experience and a track record of building production data systems, collaborating with engineers and operations to improve reliability and deliver new capabilities.

Qualifications

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

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.

Skills

BigQuery

PostgreSQL

GCP

Python

Backend development

Data warehousing

APIs

Data pipelines

SQL

Tools

Terraform

Cloud SQL

REST APIs

Job description

Motion Recruitment seeks a hands-on data platform engineer to expand our client's data platform on Google Cloud. You will build and optimize PostgreSQL and BigQuery warehouses, develop Python data pipelines, and expose data through secure APIs for customer products and internal reporting.

The ideal candidate has 3–7 years of experience and a track record of building production data systems, collaborating with engineers and operations to improve reliability and deliver new capabilities.