Lead AI & Automation Engineer: MDM & SAP Integrations

Carex Consulting Group; Lake Forest (CA); Hybrid; USD 150,000 - 210,000; Full time

Job summary

Carex Consulting Group is hiring a Lead Engineer, Automation & AI to own a critical internal MDM system bridging SAP, ERP platforms, and MDG. The role leads automation and AI initiatives across the business, with end-to-end ownership from architecture to production support.

Hybrid onsite 3 days/week in the Orange County/Greater LA Area. You will drive automation, implement AI-assisted improvements, and collaborate with Finance, Engineering, Pricing, Sourcing, Marketing, and Supply Chain teams.

Qualifications

• Bachelor's or Master's degree in Data Science, Computer Science, Engineering, Information Systems, Business Analytics, or related field, or equivalent practical experience.
• 5+ years of hands-on experience in data engineering or automation engineering, with demonstrated ability to own complex projects and production systems.
• Strong SQL Server and T-SQL expertise, including developing and optimizing stored procedures, views, and complex production queries.
• Hands-on experience with Azure Data Factory and/or Microsoft Fabric, including pipeline design, linked services, and triggers.
• Experience with ERP-adjacent data structures, such as SAP or other ERP systems.
• Familiarity with Git and modern version-control practices.
• Proficiency in at least one object-oriented or automation-focused language such as VBA, VB.NET, C#, or Python.
• Exposure to AI-assisted development tools and AI governance/data privacy awareness is preferred.

Responsibilities

• Own day-to-day operations, architecture, roadmap, maintenance, and production support of the internal MDM system.
• Progress from MDM ownership to full architectural ownership within 6–9 months.
• Lead automation and process-improvement initiatives across design, development, and deployment.
• Identify opportunities to apply AI-assisted technologies to accelerate automation and improve processes.
• Partner with Finance, Engineering Documentation, Pricing, Sourcing, Marketing, and Supply Chain stakeholders to scope automation opportunities.
• Design, develop, optimize, and support production-grade solutions using SQL Server/T-SQL, Azure Data Factory, Microsoft Fabric, VBA.
• Maintain code quality, documentation, version control, and production-support standards.
• Apply responsible AI, data governance, privacy, and security practices per enterprise standards.
• Define and monitor success metrics for automation/AI initiatives, including cost savings and reliability.
• Drive measurable business value through automation and contribute to annual cost savings.
• Lead one or more automation initiatives through go-live within the first year and scope next AI-driven opportunities.

Job description

Carex Consulting Group is hiring a Lead Engineer, Automation & AI to own a critical internal MDM system bridging SAP, ERP platforms, and MDG. The role leads automation and AI initiatives across the business, with end-to-end ownership from architecture to production support.

Hybrid onsite 3 days/week in the Orange County/Greater LA Area. You will drive automation, implement AI-assisted improvements, and collaborate with Finance, Engineering, Pricing, Sourcing, Marketing, and Supply Chain teams.