Supply Chain Analytics Engineer
Queretaro, Querétaro, MX, 76120 Escobedo, NLE, MX, 66052 Tlalnepantla, Mexico State, MX, 54180
Job Purpose
The Analytics Engineer builds and maintains the data foundations that power advanced analytics, AI‑driven insights, and reporting across Dana’s global supply chain. This role is responsible for transforming raw operational data into reliable, accessible, and well‑modeled datasets—enabling improved forecast accuracy, optimized material flow, enhanced decision‑making, and automated analytics at scale.
The position is highly technical, blending data engineering, data modeling, and analytics to support end‑to‑end supply chain performance.
#OCCDANAMEXICO
#COMM
Job Duties and Responsibilities
Data Modeling, Pipelines & Engineering (Core Focus)
- Design, build, and maintain SQL‑based data models and transformations using dbt (data build tool) as the primary development framework.
- Develop scalable, well‑tested data pipelines integrating SAP, logistics systems, planning tools, and external sources.
- Implement data quality tests, documentation, and version control practices consistent with modern analytics engineering standards.
- Ensure semantic consistency, reproducibility, and strong governance across data domains (inventory, demand, supply, logistics, procurement).
AI, Data Science & Predictive Analytics
• Build and maintain AI‑driven forecasting, inventory optimization, and supply‑risk detection models.
• Apply data science techniques (regression, clustering, anomaly detection, statistical modeling) to identify process inefficiencies and cost‑saving opportunities.
• Develop predictive insights on demand variability, supplier performance, logistics constraints, and inventory exposure.
• Support AI adoption across plants by training users, interpreting model recommendations, and validating accuracy of automated signals.
Working Capital & Cost Optimization
• Analyze inventory levels, safety stock models, lead times, and cycle stock to reduce working capital without compromising customer service.
• Identify excess, obsolete, and slow moving inventory drivers and propose data backed reduction strategies.
• Support cost reduction initiatives by analyzing transportation cost trends, supply routes, MOQ impacts, and supplier delivery patterns.
• Create scenario based models to evaluate the cost impact of forecast shifts, production changes, sourcing decisions, or logistics contingencies.
• Monitor working capital KPIs and provide actionable insights to MP&L and Finance.
Supply Chain Operations & Analytics
• Conduct deep dive analysis into material flow, capacity constraints, and MRP exceptions using SAP data.
• Develop real time dashboards and exception reports to improve visibility and streamline decision making.
• Partner with planners, schedulers, MP&L managers, and operations leaders to translate insights into executable actions.
• Support new product launches, engineering changes, and supply readiness activities using data driven assessments.
• Participate in continuous improvement projects focusing on parameter optimization, scheduling accuracy, and inventory efficiency.
Education and Qualifications
- Bachelor’s degree required; MBA or CPIM/CSCP preferred
- Minimum of 2-5 years of experience in supply chain, materials management, logistics, operations research, or analytics.
- PowerBi
- Strong problem‑solving skills with focus on cost, working capital, and operational optimization.
- Experience with AI concepts, predictive modeling, or statistical analysis is highly desirable.
- SAP experience (MM/PP required; familiarity with MRP logic, BOM structures, and inventory transactions preferred)
- Understanding of both the Automotive and Commercial Vehicle industry preferred.
- Possess excellent communication and interpersonal skills and must be capable of professionally interacting with global manufacturing plants
- Skilled in composing written correspondence and preparing presentations for senior management.
- Successfully interacts with a dispersed leadership team and others across functions and sites.
- Must be proactive, detail oriented and have excellent organization, planning and follow-through skills.
- Committed to tasks and skilled at identifying and solving a variety of problems of broad scope and complexity with little to no supervision.
- Must be able to work flexible hours.
- Travel required 20% +
Skills and Competencies
- Ability to interact with all levels of the organization, from production associates to senior leaders.
- Ability to function as a team player and be comfortable leading without direction.
- Ability to build credibility and trust.
- Ability to influence leaders and change their paradigm.
- Must be proficient with the use of the Microsoft Office Suite (Outlook, Word, Excel, PowerPoint, and Visio) and other MRP and ERP software.
- APICS, Six Sigma and/or Lean Certification a plus.