Senior Data Engineer

Kids for the Future; California (MO); On-site; USD 140,000 - 180,000; Full time

Job summary

iDC Logistics in California seeks a Senior Data Engineer to own and operate a production data platform, including environments, database administration, security, and CI-driven deployments. You will build staging and gold dbt models, ensure alignment with legacy reporting, and review code for quality.

Applicants should have 7+ years in data engineering, strong SQL and Python production experience, and familiarity with modern transformation frameworks.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or related field.
• 7+ years of experience designing, developing, and maintaining large-scale data pipelines and data warehouse solutions.
• SQL at working depth: joins, window functions, grain and aggregation tradeoffs, NULL semantics.
• Production Python in a real environment.
• Owned production data pipelines and their diagnosis/fix.
• Experience with a modern transformation framework (dbt preferred; others qualify).
• Production operations including deployments, environment management, and incident response.
• Dimensional modeling: grains, facts, dimensions, conformance, slowly-changing history.
• Git-based workflow: branching, PRs, CI as standard.

Responsibilities

• Production operations and platform health: environment setup, orchestration, monitoring, incident response.
• Database administration: security roles, grants, performance, maintenance.
• Deployment and CI: pipeline automation and environment promotion for reliable releases.
• Modeling and transformation delivery: build dbt models with tests against business semantics.
• Code review: review teammates’ work and AI-generated code for correctness.
• Reverse-engineering source systems: absorb legacy and vendor schemas.
• Report and billing parity: ensure new outputs match legacy systems.

Skills

SQL

Python

Data pipelines

Data warehouse

Git

CI/CD

Bill of materials?

Education

Bachelor's degree in Computer Science or related

Tools

dbt

SQLMesh

Dataform

Coalesce

Databricks

Job description

• Location 19515 E. Walnut Drive N.,City of Industry, CA, 91789,United States
• Base Pay $140,000.00 - $180,000.00 / Year
• Employee Type Exempt - FT
• Required Degree 4 Year Degree
• Travel 25%
• Manage Others No

About iDC Logistics

iDC Logistics, founded in 2004 by logistics industry veterans, is a leading end-to-end logistics company focused on transparency, efficiency, and innovative supply chain solutions. Headquartered in Los Angeles, iDC provides integrated services including freight forwarding, contract logistics, transportation, and distribution management for retailers worldwide.

With expertise across consumer electronics, industrial products, and healthcare industries, iDC Logistics delivers customized logistics solutions through operational excellence, technology-enabled processes, and customer-focused service. Our success is driven by a commitment to customer satisfaction, employee engagement, and continuous innovation.

Position Summary

The Senior Data Engineer owns the operation of that platform as it moves into production: environments, database administration, security roles and grants, refresh and orchestration, monitoring, deployment and CI. The role also delivers well-scoped production data work within existing patterns, so that architecture and design work can continue in parallel.

Platform architecture, the security model and the data roadmap are owned by the Principal Data Engineer. This role holds deep, autonomous ownership beneath that architecture, primarily the operational and database-administration side of the platform.

Key Responsibilities

• Production operations and platform health. Own environment setup and management, refresh and orchestration operations, monitoring and alerting, and incident response for a platform supporting production report delivery and billing.
• Database administration. Manage security-role hierarchies, grants, performance and maintenance.
• Deployment and CI. Maintain pipeline automation and environment promotion so that releases are routine and reliable.
• Modeling and transformation delivery. Build staging and gold dbt models, with tests, against defined business semantics and existing conventions. Flag requests that would conflict with established definitions.
• Code review. Review teammates’ work, including AI-generated code, for correctness and adherence to standards.
• Reverse-engineering source systems. Analyze and absorb legacy and vendor source systems, many with undocumented schemas, as a recurring part of the role.
• Report and billing parity. Validate that new platform outputs match the legacy system’s reporting and billing figures before cutover.

Requirements

Required Qualification

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or related field.
• 7+ years of experience designing, developing, and maintaining large-scale data pipelines and data warehouse solutions.
• SQL at working depth: joins, window functions, grain and aggregation tradeoffs, NULL semantics, and the ability to reason about why a query returns what it returns.
• Production Python: has written and maintained Python code that ran in production.
• Pipeline experience: has owned scheduled data pipelines in production, including diagnosing and fixing failures.
• Transformation framework: working depth in at least one modern framework. dbt preferred; SQLMesh, Dataform, Coalesce, Databricks declarative pipelines or a comparable in-house framework also qualify.
• Production operations: responsibility for running systems, including deployments, environment management, on-call or equivalent, and incident response.
• Dimensional modeling: grain, facts and dimensions, conformance and slowly-changing history.
• Git-based workflow: branching, pull requests, code review and CI as standard practice.
• Communication: clear in writing, in conversation and in presentations, including explaining technical findings to non-technical stakeholders.
• Independent problem-solving: able to investigate unfamiliar problems substantially before escalating.
• AI tooling: uses AI tools as a regular part of engineering work for research, design and verification; has built tooling for their own workflow; verifies AI output before relying on it.

Preferred Qualifications

• Multi-tenant or customer-facing data experience (isolation, audit, lineage)
• Azure (Data Factory, ADLS Gen2, Key Vault); AWS or GCP experience transfers
• Legacy and vendor-system reverse-engineering
• Logistics, supply-chain or warehousing domain experience
• Familiarity with BI tools

Summary

The company offers medical, dental, and vision insurance, as well as basic and voluntary life and voluntary ancillary coverages for accident, critical illness and hospital indemnity. Full-time employees are eligible for paid sick leave, bereavement, holiday and vacation pay. Employees are eligible to participate in the company 401k plan on the first day of the third month following hire date.

Why Join iDC Logitics?

At iDC Logistics, you will join a growing organization committed to operational excellence, innovation, and employee success. We offer the opportunity to make a significant impact by partnering with leadership, shaping organizational culture, and helping drive business performance through people-focused strategies.

iDC Logistics Inc. is committed to providing equal employment opportunities to all employees and applicants without regard to race, religion, color, sex, national origin, citizenship status, uniform service member status, age, disability, sexual and gender orientation, genetic information or any other protected status in accordance with all applicable federal, state and local laws. This commitment extends to all aspects of the company’s employment practices including, but not limited to, recruiting, hiring, promoting, transferring, compensation, benefits, training, leaves of absence, termination, and other terms and conditions of employment.

This job description is intended to set forth the core functions required for this position and describe the general nature of the work performed by employees in this position.It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job. Employees may be assigned additional