EDI & ERP Integration Analyst

Termax•Lake Zurich, IL

About The Position

The EDI & ERP Integration Analyst reports to the IT Director and is responsible for the administration, integration, continuous improvement, and reliable operation of the company’s EDI and ERP-related systems. The position primarily develops, implements, monitors, maintains, and troubleshoots EDI integrations between the company, its customers, suppliers, trading partners, and internal business systems. It requires knowledge of EDI standards and processes, SQL programming, XML, data mapping, database structures, integration testing, and electronic communication methods. The analyst works with internal departments and external trading partners to analyze requirements, resolve data and transmission issues, implement EDI transactions, and improve the accuracy, efficiency, and reliability of electronic data exchanges. The role also supports the ERP environment by assisting with the integration and development of ERP modules, system functionality, interfaces, and business processes. It ensures new solutions are designed, tested, documented, and implemented appropriately. The analyst serves as the technical support contact for the Plex ERP application, supports its implementation and maintenance, and contributes to ERP, EDI, integration, and business automation projects. The position may require evening or weekend work when necessary to support critical system or EDI activities.

Requirements

Five to seven years of experience supporting ERP systems, SQL applications, EDI processes, and business integrations.
At least four years of experience supporting SQL-based applications and relational databases.
Demonstrated experience with EDI implementation, mapping, testing, troubleshooting, and trading partner support.
Experience with ANSI X12 and EDIFACT standards.
Experience with XML and system-to-system data integration.
Thorough knowledge of ERP, EDI, SQL, XML, data integration, and database concepts.
Strong knowledge of EDI transaction processing, mapping, acknowledgments, error handling, and partner onboarding.
Strong SQL programming knowledge, including relational databases, queries, joins, stored procedures, and database structures.
Thorough knowledge of application troubleshooting, debugging, testing, and problem-solving.
Knowledge of internet-based communications, VAN transmissions, connectivity methods, and basic networking concepts.
Understanding of customer order processing, shipping, invoicing, financial, and accounts receivable EDI processes.
Knowledge of system security, user access management, change control, and software implementation practices.
Ability to plan, implement, coordinate, and manage ERP, EDI, and integration projects; analyze functional requirements and translate them into technical and business solutions.
Ability to use SQL to investigate data, validate transactions, troubleshoot issues, and support reporting; read, understand, troubleshoot, and modify XML and EDI files.
Ability to configure, test, implement, and troubleshoot system changes and modifications; use a ticket-tracking application to manage and document requests, incidents, and issues.
Ability to work independently with minimal supervision, prioritize tasks, meet deadlines, respond to urgent system and EDI issues, and use sound judgment.
Ability to operate computers and related hardware and provide user training and support.
Ability to communicate effectively with internal departments, customers, suppliers, trading partners, and software providers; listen effectively and facilitate constructive discussions.
Ability to maintain accurate technical documentation and support records and follow organizational procedures, policies, standards, and change control requirements.
Excellent written and verbal communication, analytical, organizational, and problem-solving skills; a creative and practical approach to designing solutions.
Willingness and availability to work evenings or weekends when required for critical system or EDI activities.

Nice To Haves

A four-year degree in Computer Science, Information Systems, Business, or a related field; equivalent education and experience may be considered.
Plex UX ERP experience.
Automotive supply chain or manufacturing experience.
Experience with customer order processing, shipping, invoicing, and financial EDI transactions.
Familiarity with business automation software, business intelligence tools, and data analytics tools.
Familiarity with manufacturing environments and the interaction between manufacturing operations and ERP systems.

Responsibilities

Analyze EDI requirements and support the configuration, testing, debugging, documentation, modification, and implementation of EDI processes.
Design, configure, test, maintain, and troubleshoot EDI maps and transaction flows, including ANSI X12 and EDIFACT transactions.
Develop, maintain, and validate XML-based messages, schemas, mappings, and data transformations.
Establish, maintain, and troubleshoot communication links with customers, suppliers, trading partners, VAN providers, and other external systems.
Monitor EDI transmissions, acknowledgments, errors, and exceptions, and investigate and resolve transaction failures, mapping issues, connectivity problems, and data discrepancies.
Coordinate EDI activities with internal departments, customers, suppliers, trading partners, and external service providers; periodically review EDI processes against business and customer requirements.
Identify and implement improvements to EDI reliability, automation, processing time, data quality, and operational efficiency.
Manage EDI projects from requirements definition through implementation, testing, documentation, and production deployment; implement new transactions, trading partners, software, and customer requirements through change control processes.
Create and maintain EDI procedures, mapping documentation, technical specifications, test plans, support instructions, and process documentation.
Provide guidance and training to employees on EDI standards, transaction flows, business requirements, and system capabilities; stay current with developments in EDI, XML, integration, communication, and VAN technologies.
Work with customer service, operations, purchasing, finance, sales, and administrative teams to develop, test, and improve EDI processes supporting order processing, shipping, invoicing, accounts receivable, and other business processes.
Serve as the technical support contact for the Plex ERP application and support the implementation, maintenance, performance, and continuous improvement of Plex and related SQL databases.
Analyze business requirements and translate them into ERP, EDI, and integration solutions; recommend upgrades, configuration changes, process improvements, and third-party solutions.
Perform analysis, design, development, configuration, testing, and implementation of ERP and integration enhancements.
Diagnose, resolve, document, and report application problems; manage and follow up on support tickets with Plex and other providers.
Perform system configuration, change management, release management, and testing; maintain ERP security profiles, roles, permissions, and access lists.
Identify, investigate, and correct software defects and system issues; support SQL queries, reports, data extracts, integrations, and database-related solutions.
Prepare technical specifications, functional requirements, test plans, and implementation plans; develop procedures for resolving complex user issues.
Work with customer service, operations, manufacturing, supply chain, finance, and business administration teams to develop and test ERP solutions; train and support users in effective use of Plex ERP.
Maintain documentation for system configuration, processes, interfaces, procedures, and support activities.
Create project plans defining scope, objectives, resources, responsibilities, milestones, schedules, risks, and deliverables; manage ERP, EDI, and integration projects to meet schedules, budgets, and business requirements.
Coordinate project activities with internal departments, software providers, customers, suppliers, and trading partners.
Evaluate system changes and their operational impact, communicate relevant information to stakeholders, and ensure change control, testing, approval, implementation, and documentation procedures are followed.
Support post-implementation reviews and continuous improvement; identify opportunities to optimize processes through system functionality, automation, data quality, and integration.
Develop and maintain business automation processes using approved automation, analytics, and AI programming tools.
Follow ISO, IATF, safety, environmental, departmental, and corporate policies and procedures.
Develop an annual personal continuing education and professional development plan; handle special projects and other assigned duties.