What are the responsibilities and job description for the AI Senior Data Engineer (Data Infrastructure position at IDC Logistics, Inc.?
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.
Salary : $165,000 - $195,000