Senior Data Engineer - Production Data Platform (Onsite CA)

DataJobs; California (MO); On-site; USD 140,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401k plan eligibility

Job summary

iDC Logistics, Inc. is seeking a Senior Data Engineer for an onsite role in City of Industry, CA. You will own the data platform from deployment to production, focusing on secure access, reliable transformations, and legacy reporting alignment.

You will work with SQL, Python, and dbt-style modeling, ensuring production pipelines are robust, auditable, and maintainable, while guiding teams on best practices and AI-assisted verification.

Qualifications

• Bachelor’s degree in a related field.
• 7+ years designing, developing, and maintaining large-scale data pipelines and data warehouses.
• Proficient SQL with complex joins, window functions, grain and aggregation tradeoffs.

Responsibilities

• Own environment setup, monitoring, and incident response for production data platform.
• Manage security-role hierarchies and grants, optimize performance and maintenance.
• Maintain pipeline automation and environment promotion for reliable releases.
• Build staging and production dbt models with defined semantics and tests.
• Validate new platform outputs against legacy reporting and billing figures.

Skills

SQL

Python

dbt

SQLMesh

Dataform

Git

Communication

Independent problem-solving

AI tooling

Production operations

Dimensional modeling

Education

Bachelor’s degree

Tools

Azure Data Factory

Azure ADLS Gen2

Azure Key Vault

AWS

GCP

Snowflake

Terraform

Databricks declarative pipelines

Job description

iDC Logistics, Inc. is seeking a Senior Data Engineer for an onsite role in City of Industry, CA. You will own the data platform from deployment to production, focusing on secure access, reliable transformations, and legacy reporting alignment.

You will work with SQL, Python, and dbt-style modeling, ensuring production pipelines are robust, auditable, and maintainable, while guiding teams on best practices and AI-assisted verification.