Data Infrastructure Lead
The Team
At Coderoad, we're more than just a software development company—we're your gateway to the global tech world. Whether you're looking to skill up or level up your career, we offer the challenges you've been searching for.
We provide end-to-end software development services and give you the opportunity to work on exciting, real-world projects in a supportive environment. Whether it's staff augmentation, dedicated IT teams, or general software engineering, we have opportunities for everyone to challenge themselves and take their career to the next level
Position Location - Latam (Remote).
Time Zone Requirements - This team operates on the East/West Coast time zones.
About the Role
This role is the cornerstone of the "Strategic Technology Plan" for our client. You will build the Unified Data Fabric that connects our Freight Forwarding
(CargoWise), Warehousing (Blue Yonder/Camelot), and Financial (NetSuite) systems into a single, real-time platform.
First-Year Mission: Design and deploy the Unified Data Lake and AI Foundation within 9 months (Q2–Q
How You'll Make an Impact
You will build the critical infrastructure that differentiates us from legacy 3PLs: a single, real-time data layer that connects International Freight, Warehousing, and Financials.
You will own the "buy-and-integrate" strategy using modern tools (iPaaS, dbt, Snowflake) to break down operational silos. You are not just moving data; you are building the foundation for our AI Agents—enabling them to see an order's entire lifecycle, from the factory in Asia to the final mile delivery, and automate the operational handoffs in between.
Key Responsibilities
● 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.
● 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).
Execution & Milestones
● Month 3: Architecture finalized; Freight (CargoWise) and WMS data replicating to
Snowflake.
● Month 6: "Unified Order" data model live; linking Inbound Shipments to Warehouse Inventory.
● Month 9: Real-time pipelines supporting the first "AI Agent" pilot (e.g., Automated Arrival Notices).
Qualifications
Technical Expertise
● 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.
Soft Skills
● Systems Thinker: You understand that an error in Freight Forwarding data causes a headache in the Warehouse, and you build systems to prevent it.
● 0-to-1 Mindset: You are comfortable building the first version of a product in a fast-
paced environment.
What You'll Love
100% Remote
Holidays off
Paid Time Off
Health insurance assistance program
Competitive USD compensation
Strong team culture and collaborative environment
Ongoing training and growth opportunities