IT Business Systems 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

Company Description

MTI Motion, headquartered in Pleasant Prairie, Wisconsin, designs and manufactures custom motion products for mission‑critical applications, including high‑performance motors, starter generators, and precision ball and lead screws. With roots dating back to 1946, the company has built a strong reputation for reliability and quality, serving customers from production facilities in Pleasant Prairie and Muskego, Wisconsin, and a state‑of‑the‑art plant in Matamoros, Mexico. MTI Motion emphasizes ongoing employee development through continuous training, mentorship, and clear paths for advancement, encouraging team members to create and contribute. As a wholly owned operating company within Steel Partners' Diversified Industrial Segment, MTI Motion is part of a global organization generating significant revenue and employing thousands of people across multiple countries, offering stability and growth opportunities for prospective team members.

This full‑time IT Business Systems Analyst role is an on‑site position at Pleasant Prairie, Wisconsin.

POSITION OVERVIEW

The IT Business Systems Analyst combines strong business analysis with hands‑on technical delivery. The role leads the design and build of a data‑driven production scheduling application on our SQL Server data warehouse — using Python and an HTML front end, with AI/LLM capabilities — and provides ongoing ERP support and reporting across the business. This person works closely with our SQL programmer to understand the application and data architecture and to make scheduling and reporting better.

ESSENTIAL JOB FUNCTIONS

• Design, build, and deploy a production scheduling application using Python with an HTML front end, running against the SQL Server data warehouse and sourcing demand, production plan, inventory, and component coverage directly from ERP data.
• Develop AI/LLM scheduling capabilities, including prototyping an AI‑based scheduling assistant, in partnership with internal teams and Microsoft.
• Build and maintain data models, transformations, pipelines, and reports on the data warehouse, and grow self‑service reporting in Tableau/Power BI.
• Provide daily support for the ERP systems, including order management, AR, AP, GL, procurement, shipping, and operations modules.
• Configure, enhance, maintain, and document company databases and applications, primarily on Microsoft SQL Server.
• Partner with the SQL programmer and business users to learn the architecture, translate needs into requirements and functional designs, and improve scheduling and reporting.
• Develop and execute test scripts; lead system integration and user acceptance testing to ensure high‑quality delivery, and support SOX and CMMC compliance requirements.

REQUIREMENTS & PREFERRED EXPERIENCE

• Education: Bachelor's degree in Computer Science, Information Technology, Data/Analytics, or a related field; equivalent experience considered.
• ERP: 5+ years hands‑on configuring and supporting mid‑to‑large ERP systems (Microsoft Dynamics, Oracle, NetSuite, Infor, Epicor, or similar). Aptean Made2Manage (M2M) and Infor Visual experience is a strong plus.
• SQL & data warehousing: Advanced SQL and Microsoft SQL Server (T‑SQL, SSRS, SSIS, SSAS) — building and optimizing queries, stored procedures, and data models against a data warehouse and other relational databases.
• Python: Strong Python for data work and application development (e.g., pandas, SQLAlchemy, and a web framework such as Flask, FastAPI, or Django).
• Full‑stack app delivery: Demonstrated ability to build and deploy data‑driven internal applications end to end — from database to HTML/CSS/JavaScript web UI.
• AI / LLM: Hands‑on experience applying AI and LLM tools — AI‑assisted (“vibe”) coding, prompt engineering, and/or building LLM‑powered assistants. Familiarity with Microsoft / Azure AI (Azure OpenAI, Copilot) and a strong interest in AI‑driven scheduling. Must have a demonstrated ability to verify, test, and understand AI‑assisted code, ensuring it is leveraged safely and intelligently. Must possess the technical depth to architect secure, thoroughly tested, and highly maintainable solutions.
• Modern data stack: Experience with ELT / data‑pipeline tooling (Fivetran, dbt or SQLMesh, or comparable) and BI platforms — Tableau or Power BI strongly preferred.
• Manufacturing planning: Understanding of demand planning, SIOP / S&OP, MRP, BOM, routing, capacity, and inventory/coverage concepts strongly preferred.
• DevOps basics: Familiarity with Git, Docker, Jenkins, Linux, and scheduled‑job orchestration (cron).
• Business analysis: Ability to gather and document business requirements, technical requirements, and process flows; experience with system integration and user acceptance testing.
• Environment & compliance: Experience in a discrete manufacturing environment preferred; exposure to SOX and CMMC compliance environments a plus.
• Core skills: Strong communication, presentation, problem‑solving, analytical, and organizational skills; self‑directed and comfortable in a fast‑paced environment.

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, and responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time, with or without notice.