Data Modeling Specialist II

Daimler Truck North America•Portland, OR

2d•Onsite

About The Position

This position supports initiatives to improve and develop analytic and data-analysis capabilities for the aftermarket supply chain team, focusing on new part introduction and end-of-life analysis. The role coordinates projects and serves as a liaison between IT and Aftermarket Supply Chain Operations (ASCO). The specialist provides business analysis, insight, and recommendations to support decisions that increase aftermarket revenue and customer vehicle uptime. Using data and existing systems, the role determines initial aftermarket part recommendations for new product launches in DTNA’s distribution network and works with aftermarket stakeholders to ensure part availability at launch quality gates and during project implementation. The position maintains and improves systems, reports, data quality, queries, workflows, and processes that support aftermarket part planning and lifecycle management. It also provides technical guidance and support to internal teams, reviews part retention and reactivation requests, and develops KPIs to measure performance and improvement. The position is onsite in Portland, Oregon. Relocation assistance is not available.

Requirements

Bachelor’s degree from an accredited university or college and 2 years of related experience, or an associate degree and 4 years of related experience, or 6 years of related experience.
Strong analytical and problem-solving skills.
Effective interpersonal and communication skills, including proven verbal and written communication.
Ability to work well in a team setting.
Proven PC skills using the Microsoft Office Suite, including advanced Excel skills such as PivotTables and Visual Basic macros.

Nice To Haves

Degree or experience in Information Systems, Computer Science, Data Science, or Supply Chain.
Ability to communicate and visualize data and explain findings or techniques to technical and non-technical audiences.
Familiarity with data visualization tools.
Ability to drive multiple data and analytics projects on budget and on time.
Ability to rapidly iterate solutions and recommendations.
General knowledge of database structure and architecture, including data flows, query optimization, and performance tuning in data engineering.
Understanding and application of agile software development methodology.
Familiarity with aftermarket-parts documentation for Freightliner, Western Star, Sterling, TBB, FCCC, Mercedes-Benz, or Detroit products.
MRP system experience, preferably with SAP Paragon and the SPP module.
Experience and working knowledge of Tableau, Alteryx, Power BI, Smartsheet, and DTNA-used database tables.
A strong internal and external network at DTNA.

Responsibilities

Utilize and maintain PAR Project initial stocking criteria, databases, and automated systems.
Represent Parts Optimization in project meetings and report aftermarket readiness to core teams, SteerCos, and executive-level forums.
Own, update, and troubleshoot key internal reporting tools.
Analyze supply-chain material data and make strategic recommendations for supply-chain optimization.
Support aftermarket part data-quality initiatives, including VMRS additions and part alternate loads, and liaise between upstream material release and SAP-Paragon new material loading.
Support the SAP-Paragon part-load team and aftermarket planning and documentation team as needed for materials used on vehicles and required for service.
Lead and facilitate regular part lifecycle meetings to discuss escalations for key parts that may not reach their full retention life.
Review and respond to APC Salesforce tickets requesting part reactivation; process internal reactivation and deactivation requests and update documentation.
Review the DTNA part catalog and deactivate parts that have met their retention life.
Help District Service and Part Managers prepare part-stocking proposals for new customers and dealers when requested.
Work autonomously, provide general technical guidance, and answer departments’ questions about new aftermarket material loads.
Create, maintain, and audit queries, workflows, and logic that drive departmental processes and standards.
Use lean thinking and TOS tools to streamline processes and eliminate waste.
Create and maintain KPIs to document performance and improvements.

Benefits

401(k) company contribution with company match up to 8%, plus a non-elective company contribution of 3–7% depending on age.
Starting at 4 weeks of paid vacation.
13 or more calendar holidays.
8 weeks of paid parental leave.
Employee assistance program.
Comprehensive healthcare plans.
Wellness programs.
Onsite fitness facilities at some locations.
Tuition assistance.
Paid volunteer time off.
Short-term and long-term disability plans.