Automation & AI Lead - MDM & ERP Systems Architect

Auxis; Lake Forest (CA); On-site; USD 150,000 - 190,000; Full time

Job summary

Auxis is seeking a Lead Engineer for Automation & AI to own the internal MDM system bridging SAP, various ERPs, and MDG, while leading new automation and AI initiatives. This hands-on role requires architecture, development, and production support across SQL, VBA, and Azure components.

Responsibilities include day-to-day MDM system operations, roadmap ownership, and contributing to cost savings. Apply responsible AI governance and collaborate with cross-functional teams to deliver measurable

Qualifications

• 5+ years hands-on experience in data or automation engineering.
• 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.

Responsibilities

• Own the organization’s internal MDM system in day-to-day operations, architecture, and roadmap, including SQL Server design, Azure Data Factory pipelines, and an 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, including generative AI and agentic AI approaches.
• Partner with cross-functional stakeholders (Finance, 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.

Skills

SQL / T-SQL

Azure Data Factory

Microsoft Fabric

ERP data integration

Python

C#

VB.NET

VB A

Git

Analytical thinking

Education

Bachelor's or Master's in Data Science, CS, Engineering, IS, or related field

Tools

SQL Server

Azure Data Factory

Microsoft Fabric

Git

VBA

Python

VB.NET

C#

Job description

Auxis is seeking a Lead Engineer for Automation & AI to own the internal MDM system bridging SAP, various ERPs, and MDG, while leading new automation and AI initiatives. This hands-on role requires architecture, development, and production support across SQL, VBA, and Azure components.

Responsibilities include day-to-day MDM system operations, roadmap ownership, and contributing to cost savings. Apply responsible AI governance and collaborate with cross-functional teams to deliver measurable