EDI & ERP Integration Analyst
Lake Zurich, IL, United States3d ago
Key details
- Location
- Lake Zurich, IL, United States
- Work style
- Onsite
- Level
- Senior
- Experience
- 5–7 yrs
- Function
- IT & Security operations
- Focus area
- other
- Posted
- 3d ago
Skills
access controlapplication supportbusiness analysischange controlchange managementcustomer servicedata analysisdata validationedierpinvoicingmanufacturing processesorder processingprocess improvementproduction planningrelational databasesrequirements analysisroot cause analysissqlstored proceduressupply chainsystem integrationtechnical documentationtroubleshootingwarehouse operationsxml
About the role
Job Description Summary
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 of this position is supporting ERP functionality within a manufacturing environment. The role requires a strong understanding of manufacturing processes, workflows, SQL queries, data relationships, system integrations, application support, and business process improvement. The position works closely with internal departments and IT teams to analyze requirements, troubleshoot system issues, improve business processes, implement new ERP functionality, and provide working-level support for EDI and related system integrations.
Responsibilities PLEX ERP, Manufacturing Systems and Workflow Support
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 determining whether the root cause is configuration, master data, application logic, workflow, database data, integration, user procedure, or 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 that reduce manual work, improve data accuracy, and ensure effective handoffs between departments.
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.
Responsibilities EDI, Data Analysis and Integration Support
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 appropriate mapping, process, testing, and support documentation.
Provide practical guidance to users regarding ERP, EDI, data, and integration processes.
Other Duties and Responsibilities
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.
Job Knowledge and Abilities
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.
Education and Training
A four-year degree in Computer Science, Information Systems, Business, Manufacturing Systems, or a related field is preferred; equivalent education and relevant experience may be considered.
Five to seven years of experience supporting ERP applications, manufacturing systems, SQL, and business integrations is preferred.
Experience in 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.
Experience with EDI implementation, testing, troubleshooting, XML, ANSI X12, EDIFACT, and trading partner support is preferred.
Plex ERP, automotive manufacturing, industrial manufacturing, supply chain, customer order processing, shipping, inventory, production, purchasing, invoicing, warehouse operations, and API development experience are preferred.
Tools and Equipment
Steel toed shoes, safety glasses and ear plugs where required.
________________________________________________________________________________________________________
The duties listed above are intended only as illustrations of the various types of work that may be performed. Other duties may be assigned, and the responsibilities of the position may be modified as business needs change.
The job description does not constitute an employment agreement between the employer and employee and is subject to change as business needs require.
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 of this position is supporting ERP functionality within a manufacturing environment. The role requires a strong understanding of manufacturing processes, workflows, SQL queries, data relationships, system integrations, application support, and business process improvement. The position works closely with internal departments and IT teams to analyze requirements, troubleshoot system issues, improve business processes, implement new ERP functionality, and provide working-level support for EDI and related system integrations.
Responsibilities PLEX ERP, Manufacturing Systems and Workflow Support
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 determining whether the root cause is configuration, master data, application logic, workflow, database data, integration, user procedure, or 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 that reduce manual work, improve data accuracy, and ensure effective handoffs between departments.
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.
Responsibilities EDI, Data Analysis and Integration Support
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 appropriate mapping, process, testing, and support documentation.
Provide practical guidance to users regarding ERP, EDI, data, and integration processes.
Other Duties and Responsibilities
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.
Job Knowledge and Abilities
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.
Education and Training
A four-year degree in Computer Science, Information Systems, Business, Manufacturing Systems, or a related field is preferred; equivalent education and relevant experience may be considered.
Five to seven years of experience supporting ERP applications, manufacturing systems, SQL, and business integrations is preferred.
Experience in 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.
Experience with EDI implementation, testing, troubleshooting, XML, ANSI X12, EDIFACT, and trading partner support is preferred.
Plex ERP, automotive manufacturing, industrial manufacturing, supply chain, customer order processing, shipping, inventory, production, purchasing, invoicing, warehouse operations, and API development experience are preferred.
Tools and Equipment
Steel toed shoes, safety glasses and ear plugs where required.
________________________________________________________________________________________________________
The duties listed above are intended only as illustrations of the various types of work that may be performed. Other duties may be assigned, and the responsibilities of the position may be modified as business needs change.
The job description does not constitute an employment agreement between the employer and employee and is subject to change as business needs require.
How well do you match this job?
Skills
Experience
Level
Title
Location
Salary
Freshness
Similarity
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.