IT Business Systems Analyst

MTI Motion; Pleasant Prairie (WI); Hybrid; USD 90,000 - 130,000; Full time

Job summary

MTI Motion seeks an IT Business Systems Analyst to design and build a data-driven production scheduling app on our SQL Server data warehouse, using Python and an HTML front end, with AI/LLM capabilities and ongoing ERP support across the business.

The role improves scheduling and reporting within the application and data architecture, collaborating with internal teams to translate needs into functional designs.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• 5+ years configuring and supporting mid-to-large ERP systems.
• Advanced SQL and SQL Server tooling (SSRS/SSIS/SSAS).
• Strong Python for data work and application development.
• Experience applying AI/LLM tools and Azure AI familiarity.
• Experience with ELT/data-pipeline tools and BI platforms (Tableau/Power BI).
• Understanding of manufacturing planning and MRP concepts.
• DevOps basics including Git, Docker, Linux, and cron.

Responsibilities

• Design, build, and deploy a production scheduling application using Python with an HTML front end.
• Develop AI/LLM scheduling capabilities and prototypes in partnership with internal teams.
• Build and maintain data models, transformations, pipelines, and reports on the data warehouse.
• Provide daily ERP system support across order management, AR, AP, GL, procurement, shipping, and operations.
• Configure and document databases and applications on Microsoft SQL Server.
• Collaborate with users to translate needs into requirements and designs.
• Develop and execute test scripts; lead system integration and UAT to ensure quality.

Skills

Python programming

SQL & data analysis

ERP systems knowledge

AI/LLM applications

Data modeling

Tableau/Power BI

Education

Bachelor's degree in Computer Science/IT/Data/Analytics

Tools

SQL Server

Tableau

Power BI

Git

Docker

Job description

Pleasant Prairie, Wisconsin, United States

Job Description

Every day, MTI Motion associates around the world set the future in motion by solving our customers’ most vexing motion-control challenges. Serving various industries including commercial aerospace, defense, oil and gas, and transportation, MTI Motion designs and manufactures an innovative portfolio of custom, precision motion-control products and solutions, including high-performance motors, drives and controllers, as well as windings, gears and ball screws.

We’re committed to promoting a collaborative team environment that focuses on accountability, honesty and integrity to ensure customer satisfaction. We take pride in the work we perform and are committed to continuous improvement. In addition to offering a competitive benefits package, we strive to offer our employees opportunities to achieve career advancement.

MTI Motion is a wholly owned operating company within the Steel Partners family of companies and is headquartered in Pleasant Prairie, WI, with facilities worldwide.

POSITION OVERVIEW

The IT Business Systems Analyst combines strong business analysis with hands‑on technical delivery. The role designs and builds 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 position continuously works to improve scheduling and reporting within the application and data architecture.

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 team members and business users to learn 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

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 are 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).
• 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, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time, with or without notice.

EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER

MTI Motion is an equal employment opportunity (EEOC) employer such that all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, age or other legally protected status.

We will ensure individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact MTI Motion to request accommodation.

Opt‑Out Request Honored