AI-Driven Production Scheduling & ERP Analyst

re-zoo-me; Pleasant Prairie, Northern (WI, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

MTI Motion in Pleasant Prairie, WI, seeks an IT Business Systems Analyst to design a data-driven production scheduling app on a SQL Server data warehouse using Python and an HTML frontend, with AI/LLM capabilities. You will collaborate with the SQL programmer and business users to refine requirements and elevate scheduling and reporting.

The role includes daily ERP support (orders, AR/AP/GL, procurement, shipping, and operations), data modeling, and BI dashboards in Tableau/Power BI, in a

Qualifications

• Bachelor's degree in Computer Science, IT, analytics, or related field.
• 5+ years configuring and supporting mid-to-large ERP systems (Microsoft Dynamics, Oracle, NetSuite, Infor, Epicor).
• Advanced SQL and Microsoft SQL Server skills (T-SQL, SSRS, SSIS, SSAS).
• Strong Python for data work and app development (pandas, SQLAlchemy, Flask/FastAPI/Django).
• End-to-end data-driven internal apps delivery from DB to HTML/JS UI.
• Experience applying AI/LLM tools and Azure AI for scheduling.
• Familiar with Tableau or Power BI and data warehousing concepts.

Responsibilities

• Design, build, and deploy a production scheduling app on SQL Server using Python and HTML frontend.
• Develop AI/LLM scheduling capabilities and prototypes with internal teams.
• Maintain data models, pipelines, and BI reports in Tableau/Power BI.
• Provide ERP system daily support: orders, AR/AP/GL, procurement, shipping, and ops.
• Collaborate with the SQL programmer to translate needs into requirements.
• Lead testing: test scripts, system integration, and user acceptance testing.

Skills

SQL

Python

AI/LLM

Data modeling

Web development (HTML/CSS/JS)

Business analysis

Education

Bachelor's degree in Computer Science, Information Technology, Data/Analytics, or a related field

Tools

Tableau

Power BI

Microsoft SQL Server

Git

Docker

Jenkins

Flask/FastAPI/Django

Azure OpenAI

Job description

MTI Motion in Pleasant Prairie, WI, seeks an IT Business Systems Analyst to design a data-driven production scheduling app on a SQL Server data warehouse using Python and an HTML frontend, with AI/LLM capabilities. You will collaborate with the SQL programmer and business users to refine requirements and elevate scheduling and reporting.

The role includes daily ERP support (orders, AR/AP/GL, procurement, shipping, and operations), data modeling, and BI dashboards in Tableau/Power BI, in a