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

Mid-Senior Data Engineer – SQL, Python, dbt & SnowflakeCity of Industry, California | Remote Local | Full Time | $150k - $180kOur 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 DoingDesign, build, and maintain production-grade data pipelines and transformationsDevelop and maintain reliable data models supporting reporting, analytics, and business applicationsWork extensively with SQL, Python, dbt, and cloud-based data technologiesOwn day-to-day production data operations, including orchestration, scheduled refreshes, monitoring, and alertingTroubleshoot pipeline failures, data quality issues, and other production incidentsSupport database administration activities, including user access, roles, permissions, performance, and maintenanceManage data deployments and contribute to CI/CD and infrastructure automationInvestigate unfamiliar or poorly documented data sources and determine how systems, schemas, and integrations functionBuild data solutions supporting reporting, billing, customer, and operational use casesIntegrate and work with data from internal, third-party, and legacy systemsPartner with engineering, product, operations, and business teams to translate requirements into technical solutionsParticipate in code reviews and contribute to engineering standards and best practicesImprove documentation, knowledge sharing, and overall platform reliabilityRequired QualificationsStrong SQL skills, including complex joins, window functions, aggregations, NULL handling, and understanding of data grainHands-on Python development experience, including maintaining code running in productionProfessional experience building or supporting production data pipelinesExperience with a modern data transformation framework; dbt strongly preferredStrong understanding of dimensional data modeling, including:Fact and dimension tablesData grainConformed dimensionsSlowly changing dimensionsExperience supporting production environments, including deployments, monitoring, environment management, troubleshooting, and incident responseStrong experience with Git, pull requests, code reviews, and CI/CDAbility to independently investigate and debug unfamiliar technical problemsStrong communication skills and ability to work across technical and business teamsComfortable contributing within an established architecture and engineering environmentPreferred QualificationsExperience with SnowflakeExperience with Microsoft AzureFamiliarity with Azure Data Factory (ADF), ADLS Gen2, and/or Key VaultTerraform or other Infrastructure-as-Code experienceExperience working with multi-tenant or customer-facing dataExperience integrating with or reverse-engineering legacy and third-party systemsFamiliarity with BI, analytics, and downstream data consumption patternsExperience working with supply chain, transportation, warehousing, logistics, or other operational dataThe 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 systemsResearch and evaluate potential technical approachesAutomate repetitive engineering tasks and workflowsImprove development and troubleshooting efficiencyBuild custom scripts, tools, agents, or other AI-assisted workflowsCandidates 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.Specialization: Data Engineering