Data Engineer for Production Pipelines - SQL dbt Snowflake

Motion Recruitment Partners LLC; California; On-site; USD 120,000 - 180,000; Full time

Job summary

Motion Recruitment Partners LLC is seeking a Mid-Senior Data Engineer to design and maintain production data pipelines and data models in a City of Industry, CA environment. The role emphasizes hands-on development and ownership of data operations.

You will work with SQL, Python, dbt, and cloud tech to support reporting, analytics, and operational use cases across internal and third-party data sources. The team values reliability, scalability, and collaboration with engineering and product teams.

Qualifications

• Strong SQL skills, including complex joins, window functions, aggregations, NULL handling, and data grain.
• Hands-on Python development in production.
• Professional experience building or supporting production data pipelines.
• Experience with a modern data transformation framework; dbt strongly preferred.
• Strong understanding of dimensional data modeling, including: Fact and dimension tables, Data grain, Conformed dimensions, Slowly changing dimensions.
• Experience supporting production environments, including deployments, monitoring, environment management, troubleshooting, and incident response.
• Strong experience with Git, pull requests, code reviews, and CI/CD.
• Ability to independently investigate and debug unfamiliar technical problems.
• Strong communication skills and ability to work across technical and business teams.
• Comfortable contributing within an established architecture and engineering environment.

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

dbt

Data pipelines

Git & CI/CD

Tools

Snowflake

Azure

Azure Data Factory

ADLS Gen2

Key Vault

Terraform

Job description

Motion Recruitment Partners LLC is seeking a Mid-Senior Data Engineer to design and maintain production data pipelines and data models in a City of Industry, CA environment. The role emphasizes hands-on development and ownership of data operations.

You will work with SQL, Python, dbt, and cloud tech to support reporting, analytics, and operational use cases across internal and third-party data sources. The team values reliability, scalability, and collaboration with engineering and product teams.