EDI & ERP Integration Analyst

LISI•Lake Zurich, IL
•$90,000 - $100,000

About The Position

The ERP Administrator & Data Analyst reports to the IT Director and is responsible for the administration, support, configuration, continuous improvement, and reliable operation of the company’s ERP and related manufacturing applications. The primary focus is supporting ERP functionality in a manufacturing environment. The role requires knowledge of manufacturing processes, workflows, SQL queries, data relationships, system integrations, application support, and business process improvement. The analyst works closely with internal departments and IT teams to analyze requirements, troubleshoot system issues, improve business processes, implement ERP functionality, and provide working-level support for EDI and related integrations. The position also supports EDI transactions and trading-partner implementations, performs SQL-based analysis and reporting, provides user guidance and documentation, and participates in after-hours support for critical ERP, manufacturing, integration, or EDI issues.

Requirements

  • Experience supporting ERP systems in a manufacturing or industrial environment is required.
  • Demonstrated experience writing SQL queries for system support, troubleshooting, reporting, data validation, and business analysis is required.
  • Strong experience supporting ERP applications in a manufacturing or industrial environment and a strong understanding of manufacturing processes and their interaction with ERP systems.
  • Strong working knowledge of SQL, relational databases, data analysis, reporting, data validation, and database structures.
  • Strong understanding of ERP workflows, process flows, application logic, business rules, validations, system dependencies, and master data.
  • Working knowledge of EDI processes, transaction flows, mapping, acknowledgments, ANSI X12, EDIFACT, XML, flat files, and system-to-system integration.
  • Ability to troubleshoot issues across the user interface, ERP application, workflow, database, integration platform, and external trading partner.
  • Ability to translate business requirements into ERP configuration, SQL, reporting, workflow, automation, or integration solutions.
  • Ability to create clear technical documentation, procedures, process flows, test plans, and training materials.
  • Ability to communicate effectively with manufacturing, operations, supply chain, customer service, finance, IT, vendors, customers, suppliers, and trading partners.
  • Ability to work independently, prioritize competing requests, manage support tickets, meet deadlines, and work with minimal supervision.
  • Ability to learn new ERP modules, technologies, manufacturing processes, and integration tools, and support critical issues outside normal working hours.
  • Steel-toed shoes, safety glasses, and ear plugs where required.

Nice To Haves

  • A four-year degree in Computer Science, Information Systems, Business, Manufacturing Systems, or a related field; equivalent education and relevant experience may be considered.
  • Five to seven years of experience supporting ERP applications, manufacturing systems, SQL, and business integrations.
  • Experience with EDI implementation, testing, troubleshooting, XML, ANSI X12, EDIFACT, and trading partner support.
  • Plex ERP experience.
  • Automotive manufacturing or industrial manufacturing experience.
  • Supply chain, customer order processing, shipping, inventory, production, purchasing, invoicing, or warehouse operations experience.
  • API development experience.

Responsibilities

  • Administer, configure, maintain, and support the ERP and related manufacturing applications, including user access, security, performance, support tickets, upgrades, and releases.
  • Support manufacturing, production planning, purchasing, inventory, warehouse, shipping, customer service, finance, and quality processes, including relevant master data.
  • Analyze and resolve system issues by identifying whether the root cause involves configuration, master data, application logic, workflow, database data, integration, user procedure, or a software defect.
  • Configure ERP modules, workflows, process steps, approvals, notifications, business rules, reports, permissions, validations, and exception handling.
  • Design and improve cross-functional process flows to reduce manual work, improve data accuracy, and ensure effective departmental handoffs.
  • Support new ERP modules, manufacturing functionality, and related applications from requirements definition through configuration, testing, documentation, deployment, and user adoption.
  • Work with internal departments and IT teams to identify process bottlenecks, recommend improvements, and support system reliability and continuous improvement.
  • Provide user support, training, procedures, process documentation, and technical guidance.
  • Write, maintain, and optimize SQL queries for ERP administration, troubleshooting, reporting, data validation, and business analysis.
  • Query and analyze customer, supplier, order, purchasing, inventory, production, shipment, invoice, and EDI data to identify missing, duplicate, incomplete, or inconsistent records.
  • Develop SQL reports, data extracts, validation tools, dashboards, alerts, and operational controls; support stored procedures, views, scheduled jobs, and other database objects as appropriate.
  • Monitor EDI transactions, acknowledgments, errors, rejected files, and processing exceptions, and review customer requirements, implementation guides, mappings, and transaction specifications.
  • Support trading partner onboarding, EDI testing, certification, implementation, production deployment, and change management.
  • Troubleshoot failed orders, acknowledgments, shipping notices, invoices, and other EDI transactions by tracing issues through the ERP, workflow, data, mapping, communication platform, and trading partner.
  • Support ERP-to-EDI application interfaces, including XML, flat files, data transformations, SFTP, AS2, VAN, APIs, and related communication methods.
  • Coordinate with customers, suppliers, trading partners, EDI providers, and internal departments, and maintain mapping, process, testing, and support documentation.
  • Provide practical guidance to users regarding ERP, EDI, data, and integration processes.
  • Recommend ERP upgrades, configuration changes, third-party solutions, workflow improvements, and automation opportunities.
  • Develop and maintain approved business automation processes using analytics and AI programming tools.
  • Follow ISO, IATF, safety, environmental, departmental, and corporate policies and procedures.
  • Maintain appropriate change control, access control, documentation, and operational standards.
  • Participate in after-hours support for critical ERP, manufacturing, integration, or EDI issues, and perform other duties as assigned.

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Health Savings Account (HSA)
  • Flexible Savings Account (FSA)
  • Life insurance
  • Paid Time Off
  • 401(k) with Roth and Traditional options
  • Tuition reimbursement
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service