Supply Chain Analytics Engineer

Dana Incorporated; Santiago de Querétaro; Presencial; MXN 900.000 - 1.200.000; Jornada completa

Descripción de la vacante

Dana Incorporated is seeking an Analytics Engineer in Querétaro to design and maintain data foundations powering analytics, AI insights, and reporting across the global supply chain.

You will transform raw data into well-modeled datasets to improve forecast accuracy, optimize material flow, and enable automated analytics at scale. Expect collaboration with planners, MP&L, and finance to drive actionable insights.

Formación

• 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.
• Power BI proficiency.
• Strong problem-solving skills focused on cost, working capital, and optimization.
• Experience with AI concepts, predictive modeling, or statistical analysis desirable.
• SAP MM/PP experience; familiarity with MRP logic, BOM structures, inventory transactions.

Responsabilidades

• Design, build, and maintain SQL-based data models and transformations with dbt.
• Develop scalable data pipelines integrating SAP and logistics systems.
• Implement data quality tests, documentation, and version control.
• Ensure governance across data domains like inventory, demand, and supply.
• Build AI-driven forecasting and predictive analytics models.
• Create real-time dashboards and exception reports for visibility.

Conocimientos

SQL

Data modeling

Analytics

Problem solving

Communication

Educación

Bachelor’s degree

MBA

CPIM/CSCP

Herramientas

dbt

SAP MM/PP

Power BI

Descripción del empleo

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.

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