Production Data Engineer (SQL, Python, dbt & Snowflake)

Motion Recruitment; El Monte (CA); On-site; USD 100,000 - 150,000; Full time

Job summary

Motion Recruitment in City of Industry, CA is seeking a hands-on Data Engineer to join its growing technology team. This role focuses on building and maintaining production data solutions, supporting critical data operations, and improving the reliability and scalability of the overall data environment.

The ideal candidate engineers production pipelines, models, and integrations with SQL, Python, dbt, and cloud data technologies, while owning day-to-day data operations, troubleshooting

Qualifications

• Strong SQL skills, including joins, window functions, and data grain understanding.

Responsibilities

• Design, build, and maintain production-grade data pipelines and transformations.
• Develop and maintain reliable data models supporting reporting, analytics, and business applications.
• Work extensively with SQL, Python, dbt, and cloud-based data technologies.
• Own day-to-day production data operations, including orchestration, scheduled refreshes, monitoring, and alerting.
• Troubleshoot pipeline failures, data quality issues, and other production incidents.
• Support database administration activities, including user access, roles, permissions, performance, and maintenance.
• Manage data deployments and contribute to CI/CD and infrastructure automation.
• Investigate unfamiliar or poorly documented data sources and determine how systems, schemas, and integrations function.
• Build data solutions supporting reporting, billing, customer, and operational use cases.
• Integrate and work with data from internal, third-party, and legacy systems.
• Partner with engineering, product, operations, and business teams to translate requirements into technical solutions.
• Participate in code reviews and contribute to engineering standards and best practices.
• Improve documentation, knowledge sharing, and overall platform reliability.

Skills

SQL

Python

Production data pipelines

dbt

Dimensional modeling

Fact/Dimension tables

SCD

Git/CI-CD

Tools

Git

CI/CD

Terraform

Azure

Snowflake

Job description

Motion Recruitment in City of Industry, CA is seeking a hands-on Data Engineer to join its growing technology team. This role focuses on building and maintaining production data solutions, supporting critical data operations, and improving the reliability and scalability of the overall data environment.

The ideal candidate engineers production pipelines, models, and integrations with SQL, Python, dbt, and cloud data technologies, while owning day-to-day data operations, troubleshooting