Data Engineer II, Warehouse & SC Analytics

Data Engineer II, Warehouse & SC Analytics

We are searching for an experienced Data Engineer II, Warehouse & SC Analytics at our Headquarters facility.

Hyundai MOBIS Parts America

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?

Who We Are

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.

Description

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

Required Qualifications

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

Hyundai Mobis Parts America - Benefits

We offer a competitive benefits package for full-time employees which include:

• Medical, Dental, and Vision
• 401K with employer matching
• Tuition Reimbursement
• Paid Vacation, Paid Sick Days and Paid Holidays
• Mapped career plans; we believe in developing and promoting our talent!
• Company Discounts & more!

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.