Data Consultant - Logistics
Core
Design, implement, and maintain robust data models and data exchange solutions supporting manufacturing and plant logistics operations.
Role type
Mid-level data consultant (data modeling & engineering)
Builds
Logical/physical data models, dimensional schemas, data integration pipelines, and custom database logic for ERP/WMS/MES systems
Domain
Manufacturing operations, supply chain, and plant logistics
Required skills
Dimensional data modeling, Oracle PL/SQL, SQL, Data Vault architecture, ETL development, SFTP/FTP integration, Database performance tuning, Data movement utilities (SQL*Loader, Data Pump)
Preferred skills
Data Vault architecture, Databricks, Oracle APEX, PowerBI
Technologies
Oracle Data Modeler, Oracle Database, SFTP, FTP, SQL*Loader, Data Pump
Responsibilities
Design and implement logical and physical data models and dimensional schemas; Develop stored procedures, packages, functions, and triggers in Oracle PL/SQL; Build data interfaces and ETL routines for data exchange between ERP, WMS, and MES; Optimize query performance and debug database issues; Execute data loads and migrations using database utilities; Collaborate with logistics teams to gather requirements and validate business rules
Seniority
Mid-level, hands-on IC
