AI Senior Data Engineer (Data Infrastructure in Walnut

Energy Jobline is the largest and fastest growing global Energy Job Board and Energy Hub. We have an audience reach of over 7 million energy professionals, 400,000+ monthly advertised global energy and engineering jobs, and work with the leading energy companies worldwide.

We focus on the Oil & Gas, Renewables, Engineering, Power, and Nuclear markets as well as emerging technologies in EV, Battery, and Fusion. We are committed to ensuring that we offer the most exciting career opportunities from around the world for our jobseekers.

Job DescriptionJob Description

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- 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 , , , , , citizenship status, uniform service member status, age, , and , 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.

If you are interested in applying for this job please press the Apply Button and follow the application process. Energy Jobline wishes you the very best of luck in your next career move.