Analytics Engineer: Data Modeling & AI Forecasting

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

Job summary

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.

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

Responsibilities

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

Skills

Data modeling

Data pipelines

Analytics engineering

AI concepts

Predictive modeling

Cost optimization

Communication

Cross-functional

Problem solving

Travel readiness

Education

Bachelor's degree

MBA or CPIM/CSCP preferred

Tools

dbt

SQL

SAP

Power BI

MRP

Excel

Job description

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.