We are searching for an experienced Data Engineer II, Warehouse & SC Analytics at our Headquarters facility.
We think creatively and keep challenging ourselves to help create a new future and eventually make humankind’s dreams a reality. Ready for the challenge?
Tomorrow's most advanced automotive technology is being envisioned today at MOBIS Parts America (MPA). A subsidiary of Hyundai MOBIS, we are a top leading automotive parts supplier. MPA provides after-sales service parts support for Hyundai Motors, Kia Motors, and Genesis. In addition to the distribution of genuine service parts, the MPA Accessories division develops accessories for Hyundai, Kia, and Genesis - which are installed on new vehicles in the United States and Canada.
Job Purpose Under the supervision of the Operations Engineering Supervisor, the Data Engineer - Warehouse & Supply Chain Analytics develops and maintains data solutions that support warehouse operations, inventory management, slotting optimization, product placement, and supply chain analytics. This role combines data engineering expertise with warehouse operational knowledge to build scalable data models, automated pipelines, and reporting solutions that improve inventory visibility, storage utilization, material flow, picking efficiency, and operational performance. The position supports Homebase planning, product velocity analysis, EV battery storage solutions optimization, and slotting initiatives by integrating data from ERP, WMS, forecasting, and operational systems. The Data Engineer provides analytical support to regional teams and PDCs, ensuring data-driven decisions, standardized storage practices, and continuous improvement opportunities across the distribution network. Key Accountabilities • Design, develop, and maintain scalable data pipelines integrating ERP, WMS, forecasting, inventory, and operational data. • Build and support enterprise data warehouses, data lakes, semantic models, and reporting datasets. • Develop analytical models supporting inventory planning, slotting optimization, Homebase strategies, product placement, and storage utilization. • Analyze SKU attributes, part dimensions, product velocity, cube utilization, storage constraints, and inventory forecasts to identify optimization opportunities. • Create automated solutions and dashboards to monitor inventory health, storage capacity, slotting effectiveness, labor productivity, and operational performance. • Support warehouse optimization initiatives through data-driven analysis of layouts, product positioning, travel paths, and material flow. • Develop algorithms and reporting tools to recommend optimal storage locations based on velocity, commodity type, storage requirements, and operational constraints. • Evaluate warehouse configurations and capacity utilization to identify opportunities for improved space utilization and efficiency. • Partner with Operations and Engineering teams on warehouse redesigns, re-slotting projects, storage expansions, and process improvement initiatives. • Support the development and maintenance of warehouse maps, location profiles, slotting documentation, and analytical standards. • Ensure data models and analytical solutions align with Homebase standards, commodity-specific storage requirements, and operational best practices. • Ensure data quality, governance, integrity, and consistency across multiple business systems and data sources. • Automate recurring reporting, data preparation, and analytical processes to improve efficiency and reduce manual effort. • Develop analytical models supporting warehouse slotting, inventory positioning, and storage optimization. • Analyze SKU dimensions, cube utilization, inventory velocity, demand patterns, EMD, AMD, DIO, and forecasted inventory. • Support product placement strategies based on velocity, pick frequency, handling requirements, and storage constraints. • Develop algorithms and reporting tools to identify optimal warehouse locations for fast-, medium-, and slow-moving inventory. • Support Homebase planning, strike zone analysis, and warehouse re-slotting initiatives. • Partner with Operations Engineering teams on warehouse redesign, storage expansion, and material flow improvement projects. • Build analytical tools to evaluate space utilization, travel distance reduction, and pick efficiency improvements. • Design, develop, and maintain Power BI dashboards, reports, and self-service analytics solutions that support Supply Chain, Warehouse Operations, and Executive leadership. • Create analytical models and reporting solutions for slotting optimization, inventory positioning, storage utilization, labor planning, capacity planning, and operational performance. • Design and optimize large-scale datasets and analytical models (1M+ records) to ensure accurate, scalable, and efficient calculations across multiple business metrics. • Build flexible data models and business logic that integrate inventory, forecast, WMS, ERP, and operational data while adapting to evolving slotting and warehouse strategies. • Leverage Power BI, AI, Excel, and advanced analytics tools to develop actionable insights and decision-support solutions. • Develop and maintain KPI reporting for inventory health, space utilization, slotting effectiveness, labor productivity, storage capacity, service levels, and forecast accuracy. • Support data-driven decision-making related to slotting, product placement, staffing, network optimization, and continuous improvement initiatives. • Present analytical findings, storage recommendations, and business insights to supervisors, managers, and senior leadership in a clear and actionable manner. • Partner with Operations, Engineering, Supply Chain, and IT teams to translate business requirements into scalable reporting and analytics solutions • Integrate and analyze data from WMS, ERP, and operational systems to support inventory planning and compliance tracking. • Collaborate with Operations, Engineering, EHS, and Compliance teams to ensure safe and efficient battery storage and handling practices. • Support new battery storage initiatives, facility modifications, and process improvements through data-driven analysis and field execution. • Collaborate with cross-functional teams to develop and implement safe, scalable, and compliant battery storage strategies. • Lead and support hands-on implementation of battery storage solutions, material handling equipment, charging infrastructure, and warehouse process improvements. • Design, develop, and maintain Power BI dashboards, reports, and self-service analytics solutions that support Supply Chain, Warehouse Operations, and Executive leadership. • Create analytical models and reporting solutions for slotting optimization, inventory positioning, storage utilization, labor planning, capacity planning, and operational performance. • Design and optimize large-scale datasets and analytical models (1M+ records) to ensure accurate, scalable, and efficient calculations across multiple business metrics. • Build flexible data models and business logic that integrate inventory, forecast, WMS, ERP, and operational data while adapting to evolving slotting and warehouse strategies. • Leverage Power BI, AI, Excel, and advanced analytics tools to develop actionable insights and decision-support solutions. • Develop and maintain KPI reporting for inventory health, space utilization, slotting effectiveness, labor productivity, storage capacity, service levels, and forecast accuracy. • Support data-driven decision-making related to slotting, product placement, staffing, network optimization, and continuous improvement initiatives. • Present analytical findings, storage recommendations, and business insights to supervisors, managers, and senior leadership in a clear and actionable manner. • Partner with Operations, Engineering, Supply Chain, and IT teams to translate business requirements into scalable reporting and analytics solutions • Integrate and analyze data from WMS, ERP, and operational systems to support inventory planning and compliance tracking. • Collaborate with Operations, Engineering, EHS, and Compliance teams to ensure safe and efficient battery storage and handling practices. • Support new battery storage initiatives, facility modifications, and process improvements through data-driven analysis and field execution. • Collaborate with cross-functional teams to develop and implement safe, scalable, and compliant battery storage strategies. • Lead and support hands-on implementation of battery storage solutions, material handling equipment, charging infrastructure, and warehouse process improvements Key Performance Indicators • Data Engineering & Architecture (30%) • Warehouse Analytics & Slotting Support (30%) • Business Intelligence & Reporting (20%) • EV Battery Storage and Handling Analysis (20%) Major Challenges and Key Decisions • While written policies and procedures exist for some of the functions associated with this position, the individual must be able to operate independently within those policies and procedures, require minimum supervision and be internally motivated. • The individual must be detail oriented and able to prioritize workloads effectively in order to achieve maximum efficiency. • Successfully communicating downwards, upwards and laterally to ensure messages are received by audiences appropriately and accurately. • This role is vital for maintaining adherence to Homebase standards, ensuring proper slotting strategy is Work Schedule and Travel Requirements Work Schedule Monday - Friday 8:00 AM - 5:00 PM; Flexible Schedule at the discretion and approval of Manager Travel Required Yes
Travel Detail Minimal overnight travel (up to 10%) by land and/or air
Experience Requirements 2 - 4 years of experience in distribution, warehousing, inventory control, or supply chain operation Required 2 - 4 years of experience developing SQL-based analytical, reporting, or data engineering solutions Required • Experience with WMS systems, slotting software, or warehouse automation tools. • Strong Excel skills (pivot tables, advanced formulas, data modeling). • Experience analyzing warehouse layouts, product flow, and operational workflows. Experience updating warehouse layouts using AutoCAD or similar CAD software. • Ability to interpret warehouse drawings, location maps, and storage configurations. • Proven ability to communicate across frontline, supervisory, and leadership levels. • Hands-on mindset with willingness to engage directly in operational activities. • Experience designing, building, and maintaining ETL/ELT data pipelines and automated data workflows. • Experience developing Power BI data models, DAX calculations, semantic models, dashboards, and reports. • Experience using Python, SQL, or similar technologies for data transformation, automation, and analysis. • Experience in designing or supporting data warehouses, data lakes, or enterprise reporting datasets preferred Education Requirements Bachelor's Degree in Computer Science, Data Engineering, Information Systems, Industrial Engineering, Supply Chain Engineering or a related field Required Licenses / Certifications Continuous improvement certifications Preferred
Lean Six Sigma/Lean certification Preferred
Knowledge, Skills & Abilities (KSAs) • Large Dataset Management • Advanced SQL • Power BI • Data Modeling • Data Engineering • Data Analytics • Python • AutoCAD or Similar CAD Software for Warehouse Layout Analysis and Facility Planning • Data Warehousing • Microsoft Fabric (Preferred) • Azure Data Factory (Preferred) • Azure Synapse Analytics (Preferred) • Databricks (Preferred) • Inventory Management • Warehouse Operations • Slotting Methodologies • Product Velocity Analysis • Homebase Storage Strategy • Material Flow Analysis • Distribution Center Operations • Supply Chain Analytics • Warehouse Layout Concepts • WMS Systems (AMOS preferred) Competencies Analytical Thinking Gathers, evaluates, and interprets information to understand issues, identify root causes, and make sound decisions. Applies logical reasoning, critical thinking, and objective analysis to solve problems, assess risks and opportunities, and develop effective solutions that support business and organizational goals. Communication Skills Clearly and effectively exchanges information, ideas, and expectations with others through verbal, written, and interpersonal communication. Communicates in a manner that promotes understanding, builds relationships, and supports collaboration across teams and stakeholders. Demonstrates active listening, adapts messages to the audience, and ensures information is conveyed accurately, professionally, and respectfully. Functional Knowledge The understanding and application of the specialized knowledge, principles, processes, tools, and best practices required to perform effectively within a specific functional area. Demonstrates expertise in job-related responsibilities and applies technical or professional knowledge to solve problems, improve performance, ensure compliance, and support business objectives. Continuously develops and maintains functional expertise to adapt to evolving business needs, industry trends, and organizational requirements. Problem Solving Identifies issues, analyzes situations, and develops effective solutions that address root causes and support business objectives. Applies critical thinking, sound judgment, and a systematic approach to evaluate information, consider alternatives, and implement practical actions. Proactively anticipates challenges, resolves obstacles, and continuously seeks opportunities to improve processes, performance, and results. Job Impact The degree to which an individual’s work contributes to organizational objectives, operational effectiveness, and overall business success. Demonstrates an understanding of how actions, decisions, and performance influence team, department, and company results. Focuses on delivering meaningful outcomes, creating value, and ensuring work efforts positively affect customers, stakeholders, and business performance. Physical Requirements
Physical Demand Rarely Occasionally Frequently Constantly Weight Standing X Walking X Sitting X Pushing / Pulling X 10 lbs Lifting X 10 lbs Carrying X 10 lbs Crouching X Kneeling X Squatting X Reaching X Gripping / Grasping X Repetitive Motions X
Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee with this job. Duties, responsibilities, and activities may change at any time with or without notice. Our company provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.
Employment Type - Exempt
Compensation - Annual Salary , $57,898.31 - 85,978.99
We offer a competitive benefits package for full-time employees which include:
Our company provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.
Hyundai MOBIS specializes in automotive technology. We are 6th largest automotive parts supplier in the world. Based on deep expertise in manufacturing core-modules for automobiles and A/S parts distribution, we now concentrate on developing software and system solutions for future mobility. Key focusing areas include electrification, autonomous driving and connectivity technology. We create Innovation for Humanity and Mobility for Tomorrow. The One For All Mobility.
