Senior Data Engineer

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 #J-18808-Ljbffr iDC Logistics Inc