Data Consultant - Logistics
Job Description
Roles & Responsibilities :
Data Consultant (Data Modeling & Logistics Solutions)
Title: Data Consultant – Data Modeling
Experience Level: 4 – 6 Years (5+ years preferred)
Domain: Manufacturing Operations, Supply Chain & Plant Logistics
Practice Area: Data Solutions & Consulting (Application/Solution Modeling)
Overview
We are seeking a mid-level Data Consultant to design, implement, and maintain robust data models and data exchange solutions supporting manufacturing and plant logistics operations. In this role, you will work hands-on with business and functional teams to translate operational supply chain workflows into logical, physical, and dimensional models, while developing the underlying Oracle PL/SQL mechanisms and data integration pipelines.
Key responsibilities:
Data Modeling & Architecture: Design, implement, and maintain logical and physical data models, dimensional schemas (star/snowflake), and data vault structures using Oracle Data Modeler or equivalent tools.
• Implementation Projects: Actively contribute to and execute end-to-end data modeling and engineering implementation and rollout lifecycles for business-critical operational applications.
• Database Programming & Customization: Develop and maintain stored procedures, packages, functions, and triggers in Oracle PL/SQL tailored to business requirements and operational logic.
• Data Integration & Exchange: Design and implement robust data interface and delta-capture mechanisms, ETL routines, and automated file exchange processes (SFTP/FTP) between ERP, WMS/MES, and downstream data repositories.
• Performance Tuning & Debugging: Perform query optimization, indexing strategies, debugging, and execution-plan tuning to ensure high performance and data accuracy.
• Data Movement & Utilities: Leverage database utilities such as SQL*Loader, Data Pump, and export/import tools for initial loads, migrations, and regular feeds.
• Stakeholder Consulting: Work closely with cross-functional logistics teams and business analysts to gather requirements, establish data dictionaries, and validate business rules.
Requirements
Function: Information Technology
Experience Level: Associate