Data Consultant - Logistics

Data Consultant - LogisticsFull-timeLegal Entity: Bosch Global Software Technologies Private LimitedCompany DescriptionBosch Global Software Technologies Private Limitedis a 100% owned subsidiary of Robert Bosch GmbH, one of the world's leading global supplier of technology and services, offering end-to-end Engineering, IT and Business Solutions. With over 27,000+ associates, it’s the largest software development center of Bosch, outside Germany, indicating that it is the Technology Powerhouse of Bosch in India with a global footprint and presence in the US, Europe and the Asia Pacific region.Job DescriptionOverviewWe are seeking a mid-levelData Consultantto 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.Roles & Responsibilities :Data Consultant (Data Modeling & Logistics Solutions)Data Modeling & Architecture:Design, implement, and maintain logical and physical data models, dimensional schemas (star/snowflake), and data vault structures usingOracle Data Modeleror 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 inOracle PL/SQLtailored 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 asSQL_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.Experience :5+ years of hands-on experience in data modeling, engineering and database development, including participation in at least 1–2 implementation projects.Title:Data Consultant – Data ModelingExperience Level:4 – 6 Years (5+ years preferred)Domain:Manufacturing Operations, Supply Chain & Plant LogisticsPractice Area:Data Solutions & Consulting(Application/Solution Modeling)Mandatory/requires Skills :Data Modeling Paradigms:Strong conceptual and practical knowledge ofdimensional,logical, andphysicaldata modeling; understanding ofData Vaultarchitecture is a strong plus.Practical proficiency with Oracle Data Modeler or equivalent modeling toolsOracle & SQL Development:Strong hands-on proficiency inSQL and advanced PL/SQL(stored procedures, packages, functions, triggers).Strong RDBMS fundamentals, schema design, and constraints management.Solid working knowledge ofSQL_Loader,Data Pump, and data movement utilities.Proven debugging techniques and query/performance tuning methodologies.Integration & Automation:Experience building data interfaces, ETL workflows, SFTP/FTP data transfer mechanisms, and basic automation scripting.Domain Knowledge (Preferred):Working knowledge or exposure to manufacturing logistics, plant supply chain, inventory movement, or warehousing (WMS/ERP interfaces).Interpersonal Skills:Strong oral and written communication skills with the ability to articulate technical data designs to business and functional teams.Preferred Skills :Databricks, Oracle APEX, PowerBIQualificationsEducational qualification:B.E. / B.Tech / MCA / M.Sc in Computer Science, Information Technology, or a related discipline.By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy applyI'm interestedI'm interestedPrivacy NoticeImprint