Automation & AI Consultant

Auxis; Región Centro; Presencial; MXN 900.000 - 1.700.000; Jornada completa

Descripción de la vacante

Auxis is seeking a Lead Engineer for Automation & AI in Mexico (Jalisco region). The role focuses on owning the internal MDM system bridging SAP, various ERPs, and MDG while driving automation and AI initiatives across the business.

Responsibilities include day-to-day operations, architecture, and roadmap ownership, plus leading new automation projects from design to go-live, with a focus on cost savings and governance. Strong SQL Server, Azure Data Factory, and VBA skills are required.

Formación

• Bachelor's or Master's in Data Science, CS, Engineering, or related field.
• 5+ years in data or automation engineering; able to own complex projects.
• Strong SQL Server / T-SQL, including procedures and views.
• Hands-on with Azure Data Factory and/or Fabric pipelines.
• Experience with ERP-adjacent data structures (e.g., SAP).
• Proficient in at least one OO language (VBA, VB.NET, C#, Python).
• Familiar with Git and collaborative development.

Responsabilidades

• Own the internal MDM system in day-to-day operations, architecture, and roadmap, including SQL Server database design, Azure Data Factory / Fabric pipelines, and the Excel/VBA front end.
• Lead new automation and process-improvement initiatives from design through go-live, contributing to measurable annual cost savings.
• Identify and evaluate opportunities to apply AI-assisted tools and techniques to accelerate automation development and business process improvement.
• Partner with cross-functional stakeholders (Finance & Accounting, Engineering Documentation, Pricing, Sourcing, Marketing, Supply Chain) to prioritize and scope new automation projects.
• Maintain production-grade code and documentation standards across SQL, VBA, and Azure components.
• Apply responsible AI and data governance practices to automation and AI initiatives, in alignment with enterprise AI governance and security standards.
• Define and monitor success metrics for automation and AI initiatives, including cost savings, cycle-time reduction, and system reliability.

Conocimientos

SQL / T-SQL

Azure Data Factory

Excel VBA

Python

C# / VB.NET

Git

Analytical thinking

Cross-functional collaboration

AI tools (Copilot, Claude)

Educación

Bachelor's or Master's in CS/Engineering/Data Science

Herramientas

SQL Server

Azure Fabric/Data Factory

Microsoft Fabric

Git

Descripción del empleo

The Lead Engineer for Automation & AI will take ownership of the organization's internal Material Master Data Management (MDM) system bridging SAP, various ERPs, and MDG, while leading new automation and AI initiatives as they arise across the business. This is a hands‑on role: the individual will own assigned tools and projects end-to-end, remaining directly engaged in architecture, development, and production support.

Responsibilities:

• (70 %) Own the business’s internal MDM system in day-to-day operations, architecture, and roadmap, including SQL Server database design, Azure Data Factory / Fabric pipelines, and the Excel/VBA front end.
• (30%) Lead new automation and process-improvement initiatives from design through go-live, contributing to measurable annual cost savings.
• Identify and evaluate opportunities to apply AI‑assisted tools and techniques, including generative AI and agentic AI approaches, to accelerate automation development and business process improvement.
• Partner with cross‑functional stakeholders (Finance & Accounting, Engineering Documentation, Pricing, Sourcing, Marketing, Supply Chain) to prioritize and scope new automation projects.
• Maintain production‑grade code and documentation standards across SQL, VBA, and Azure components.
• Apply responsible AI and data governance practices to automation and AI initiatives, in alignment with enterprise AI governance and security standards.
• Define and monitor success metrics for automation and AI initiatives, including cost savings, cycle-time reduction, and system reliability.

Education and Qualifications:

• Bachelor's or Master's degree in Data Science, Computer Science, Engineering, Information Systems, Business Analytics, or a related field (or equivalent practical experience).
• 5+ years of hands‑on experience in data or automation engineering, with demonstrated ability to own complex projects independently.
• Strong SQL Server / T-SQL skills, including writing and optimizing stored procedures, views, and complex production queries.
• Hands‑on experience with Azure Data Factory (ADF) and/or Microsoft Fabric, including pipeline design, linked services, and triggers.
• Experience working with or supporting ERP-adjacent data structures (e.g., SAP, various ERPs, or comparable transactional/master‑data platforms).
• Demonstrated ability to own and support production systems independently, including troubleshooting live issues.
• Familiarity with Git for version control and collaborative development.
• Proficiency in at least one object‑oriented programming language (e.g., VBA, VB.NET, C#, Python).
• Strong analytical and problem‑solving abilities, with effective communication and cross‑functional collaboration skills.
• Practical experience using AI‑assisted development tools (e.g., GitHub Copilot, Cursor, Claude) to accelerate engineering work (preferred).

Internal

• Working knowledge of large language model (LLM) integration patterns, such as API‑based tool/function calling and retrieval‑augmented generation (RAG), and how they apply to enterprise automation (preferred).
• Awareness of AI governance, data privacy, and responsible AI practices as applied to production automation and AI systems (preferred).
• Experience with the broader Azure ecosystem: Logic Apps, Power Automate, Key Vault, Data Lake (preferred).