Analytics Engineer - Data

Dana Canada Corp.; Santiago de Querétaro; Presencial; MXN 600.000 - 1.000.000; Jornada completa

Descripción de la vacante

Dana Canada Corp. is seeking a data analytics professional in Querétaro to design, build, and govern SQL data models and scalable pipelines integrating SAP and planning tools. The role emphasizes AI-driven forecasting, inventory optimization, and supply-risk detection across global manufacturing operations.

You will develop predictive insights, validate model outputs, and train users while collaborating with MPs, planners, and logistics leaders to drive cost reductions and process improvements.

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.
• Proficiency with Power BI and Excel for reporting and analysis.
• Strong problem-solving skills with focus on cost, working capital, and optimization.
• Experience with AI concepts, predictive modeling, or statistical analysis is desirable.
• SAP experience (MM/PP; BOM, inventory transactions) preferred.

Responsabilidades

• Design, build, and maintain SQL-based data models and transformations using dbt as the primary 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, inventory optimization, and supply-risk detection models.
• Apply regression, clustering, anomaly detection, and statistical modeling to identify inefficiencies.
• Develop predictive insights on demand variability, supplier performance, logistics constraints, and inventory exposure.
• Train users, interpret model recommendations, and validate automated signals.
• Analyze inventory levels, lead times, and safety stock to reduce working capital.
• Create scenario models to evaluate forecast shifts, production changes, or sourcing decisions.
• Develop real-time dashboards and reports to improve visibility and decision making.
• Collaborate with planners, MPs, and operations leaders to translate insights into action.
• Support new product launches and supply readiness activities with data-driven assessments.
• Participate in continuous improvement projects focusing on optimization.

Conocimientos

Data modeling

Data pipelines

Analytics engineering

AI concepts

Predictive modeling

Cost optimization

Communication

Cross-functional

Problem solving

Travel readiness

Educación

Bachelor's degree

MBA or CPIM/CSCP preferred

Herramientas

dbt

SQL

SAP

Power BI

MRP

Excel

Descripción del empleo

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.