Supply Chain Analytics Engineer

Dana; Santiago de Querétaro; On-site; MXN 900,000 - 1,200,000; Full time

Job summary

Dana Canada Corp. is seeking a seasoned analytics and supply chain specialist in Querétaro to design and maintain SQL-based data models and scalable pipelines.

You will integrate SAP data with logistics systems and external sources, building AI-driven forecasting and optimization models to improve inventory and cost efficiency. Responsibilities include governance across data domains, developing dashboards for real-time visibility, and partnering with planners and MP&L managers to translate

Qualifications

• Bachelor’s degree required; MBA or CPIM/CSCP preferred.
• Minimum of 5 years of experience in supply chain analytics or logistics.
• Strong problem-solving and communication skills.
• Proficiency with SAP MM/PP and MRP logic.
• Experience with AI concepts and predictive modeling is desirable.

Responsibilities

• Design, build, and maintain SQL-based data models and transformations using dbt as the framework.
• Develop scalable data pipelines integrating SAP, logistics systems, planning tools, and external sources.
• Implement data quality tests, documentation, and version control practices.
• Ensure governance across data domains (inventory, demand, supply, logistics, procurement).
• Build and maintain AI-driven forecasting and inventory optimization models.
• Develop predictive insights on demand, supplier performance, and logistics constraints.
• Support AI adoption across plants by training users and validating model accuracy.
• Analyze inventory levels, safety stock, lead times, and cycle stock to reduce working capital.
• Create scenario-based models to evaluate cost impacts of forecast shifts and logistics decisions.
• Develop real-time dashboards and reports to improve visibility and decision making.

Skills

Problem solving

Team player

Communication skills

Office software

ERP systems

Education

Bachelor’s degree

MBA or CPIM/CSCP preferred

Tools

SAP

Power BI

Excel

MRP systems

Job description

Select how often (in days) to receive an alert:

Requisition: 64616

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 +-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.

Join our team of 28,000 problem solvers who are fostering a culture of innovation by leveraging the diverse perspectives of our global team. We believe in facing challenges head-on by finding opportunity and uncovering possibility, where roadblocks and barriers become targets instead of obstacles. We are One Dana with limitless opportunity.