IT Business Systems Analyst

mticareers; Pleasant Prairie (WI); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive benefits package

Career advancement opportunities

Job summary

MTI Motion is seeking an IT Business Systems Analyst to design and build a data-driven production scheduling application on a SQL Server data warehouse, with Python and an HTML front end. You will develop AI/LLM scheduling capabilities and support ERP across the business.

You will craft data models, pipelines, and reports for self-service BI in Tableau/Power BI, while ensuring SOX and CMMC compliance. Collaboration with internal teams and stakeholders is essential.

Qualifications

• Bachelor's degree in CS, IT, Data Analytics, or related field.
• 5+ years configuring and supporting mid-to-large ERP systems (Dynamics, Oracle, NetSuite, Infor, Epicor).
• Advanced SQL and Microsoft SQL Server experience (T-SQL, SSRS, SSIS, SSAS).
• Strong Python for data work and app development (pandas, SQLAlchemy, Flask/FastAPI/Django).
• Full-stack data-driven app delivery from database to HTML/JS UI.
• Hands-on AI/LLM tools experience; familiarity with Azure AI and Copilot.

Responsibilities

• Design, build, and deploy a production scheduling app using Python with an HTML front end on a SQL Server data warehouse.
• Develop AI/LLM scheduling capabilities in collaboration with internal teams and Microsoft.
• Build and maintain data models, transformations, pipelines, and reports on the data warehouse; grow self-service reporting in Tableau/Power BI.
• Provide daily ERP system support (order management, AR, AP, GL, procurement, shipping, operations).
• Configure, enhance, maintain, and document databases and applications on SQL Server.
• Partner with users to translate needs into requirements and lead testing and SOX/CMMC compliance.

Skills

SQL & data warehousing

Python programming

AI/LLM integration

Data modeling

BI reporting

ERP system administration

Education

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

Tools

Microsoft SQL Server

Tableau

Power BI

Git

Docker

ERP systems (Dynamics / Oracle / NetSuite)

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 & 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).
• 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.

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.