Report

AI Senior Data Engineer (Data Infrastructure

Salary

$165k - $195k

Min Experience

5 years

Location

City of Industry, California, United States

JobType

full-time

About the job

Info This job is sourced from a job board

Overview

About the role

The role of AI Senior Data Engineer will build the company’s United Logistics Platform that will connect the Freight Forwarding (CargoWise), Warehousing (Blue Yonder/Camelot), and Financial (NetSuite) systems into a single, real-time platform. You will use modern tools (iPaaS, dbt, Snowflake) to build this critical infrastructure and real-time data tool, which will create the foundation for the AI agents that will enable operators to see the entire lifecycle of the product. The goal is to design and deploy the United Data Lake and AI Foundation within 9 months (Q2–Q4 2026).

Key Responsibilities

Unified Architecture & Integration

Unified Data Lake: Design and deploy a cloud-native Data Lake (Snowflake/AWS S3) that ingests data from all operational verticals: Freight Forwarding and Warehousing into a single "Source of Truth."
iPaaS & ELT Strategy: Lead the integration strategy using iPaaS (Workato/Boomi) to trigger real-time actions (e.g., "Container Arrival" triggers "Warehouse Pre-Alert") and ELT (Fivetran) for high-volume reporting.
Schema Design: Architect the "Order Lifecycle" data model that links a Bill of Lading (Freight) to a SKU (Warehouse) and an Invoice (Finance), enabling true end-to-end visibility.

Pipeline Development & AI Readiness

Transformation Layer (dbt): Use dbt to clean and normalize messy data (e.g., standardizing carrier names across TMS and WMS) so our AI Agents can reliably automate pricing and tracking.
Operational Automation: Build the API connectors that allow AI Agents to "read" emails and "write" data back into the TMS/WMS without human intervention.
Data Governance: Implement automated "Health Checks" to ensure data accuracy across the supply chain (e.g., flagging if a container is marked "Delivered" in the TMS but "Not Received" in the WMS).

Required Skills & Experience

5+ years in Data Engineering: Expert-level SQL and Python; proven experience merging distinct data sources (e.g., TMS + WMS) into a unified model.
Modern Data Stack: Deep expertise with dbt (Data Build Tool) for transformations and ELT tools (Fivetran/Airbyte).
Integration Architect: Experience using iPaaS (Boomi, MuleSoft, Workato) to orchestrate workflows across API-based systems.
Logistics Domain: You understand the full lifecycle: EDI, Bill of Lading, WMS Inventory, and Final Mile.
Systems Mindset: Ability to understand the critical nature of accurate data related to the business and design systems to prevent errors.
Sense of Urgency: Competence with building quality product within short timelines while working in a fast-paced environment.

Benefits: 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.

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 responsibilities as necessary. The Company reserves the right to revise this job description at any time and to require employees to perform other tasks as circumstances or conditions of the Company’s business, competitive considerations or the work environment changes.

About the company

Founded in 2004, iDC Logistics was created by industry veterans who wanted to bring greater transparency and efficiency to logistics through innovative distribution and management solutions. Headquartered in Los Angeles, iDC is now a leading end-to-end logistics company, providing comprehensive design, implementation, and operational capabilities in freight forwarding, contract logistics, transportation, and distribution management. iDC Logistics has developed its reputation by servicing retailers in the world. With years of specialty expertise in consumer electronics, industrial products, and healthcare, iDC Logistics has the experience, team, and facilities to deliver. We believe that customer satisfaction, employee satisfaction, and technology are key drivers of our success and we continue to invest in each as we develop and deliver best-in-class solutions.

Skills

SQL

Python

dbt

Fivetran

Airbyte

Workato

Boomi

MuleSoft

Snowflake

AWS S3

Globus

ETL

API

TMS

WMS