Mid-Senior Data Engineer - SQL, Python, dbt & Snowflake

Mid-Senior Data Engineer - SQL, Python, dbt & Snowflake

City of Industry, CA | Full-Time

Our client is a growing organization seeking a Data Engineer to join its expanding technology team. This is a hands-on role focused 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 is a strong hands-on engineer who enjoys working with production systems, troubleshooting unfamiliar problems, and taking ownership of data pipelines and operational processes.

What You’ll Be Doing

• 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

Required Qualifications

• Strong SQL skills, including complex joins, window functions, aggregations, NULL handling, and understanding of data grain

• Hands-on Python development experience, including maintaining code running 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

Preferred Qualifications

• Experience with Snowflake

• Experience with Microsoft Azure

• Familiarity with Azure Data Factory (ADF), ADLS Gen2, and/or Key Vault

• Terraform or other Infrastructure-as-Code experience

• Experience working with multi-tenant or customer-facing data

• Experience integrating with or reverse-engineering legacy and third-party systems

• Familiarity with BI, analytics, and downstream data consumption patterns

• Experience working with supply chain, transportation, warehousing, logistics, or other operational data

AI & Modern Engineering

The engineering team incorporates AI-assisted tools into its development and problem-solving workflows. Candidates should be comfortable using AI tools thoughtfully to:

• Investigate unfamiliar codebases, schemas, documentation, and systems

• Research and evaluate potential technical approaches

• Automate repetitive engineering tasks and workflows

• Improve development and troubleshooting efficiency

• Build custom scripts, tools, agents, or other AI-assisted workflows

Candidates should also understand the limitations of AI-generated output and be able to explain how they verify results, identify incorrect assumptions, and validate technical solutions before putting them into production.