EDI Analyst (1 Year Contract)

Position Summary
We are seeking an experienced EDI Analyst (1 year contract) to support and troubleshoot our complex EDI environment across Sunrise and GrandRiver. This role is responsible for end‑to‑end monitoring, investigation, and resolution of EDI transaction issues across multiple VANs, customers, and internal systems, with a strong focus on Purchase Order lifecycle integrity and invoice processing accuracy.
The successful candidate will work closely with Customer Service, Sales, Finance, and IT, ensuring that EDI transactions flow accurately from external trading partners through our integration platforms (BizTalk and Cadacus) into our ERP systems — and back out again.
This role requires strong attention to detail, deep EDI troubleshooting skills, solid SQL experience, and the ability to understand and diagnose both technical EDI structure issues and business process impacts.

Key Responsibilities: EDI Operations & Troubleshooting:
• Troubleshoot inbound and outbound EDI transactions across BizTalk and Cadacus
• Investigate EDI issues from the VAN to the ERP for inbound documents (e.g., 850 Purchase Orders)
• Investigate outbound EDI issues from ERP back to the VAN / customer for documents such as 810 Invoices
• Monitor and resolve errors related to:
• Mapping failures
• Translation errors
• Data integrity issues
• Missing, duplicate, or rejected transactions
• Support a multi‑VAN, multi‑customer EDI ecosystem with varying partner requirements

EDI Transaction Set Support:
• Provide support and expertise for the following EDI documents:
• 850 – Purchase Order (PO)
• Customer order requesting goods, including item details, quantities, pricing, ship‑to locations, and requested delivery dates.
• 855 – Purchase Order Acknowledgment
• Response to the 850 indicating acceptance, rejection, or changes to the original purchase order.
• 856 – Advance Ship Notice (ASN)
• Notification sent prior to shipment detailing packing structure, cartons, pallets, quantities, and tracking information.
• 810 – Invoice
• Billing document sent to customers reflecting shipped goods, pricing, taxes, and payment terms.
• 940 – Warehouse Shipping Order
• Instruction to a warehouse or 3PL to ship goods to a specified customer or location.
• 945 – Warehouse Shipping Advice
• Confirmation that a shipment has occurred, including actual shipped quantities and shipment details.

Daily Processing & Monitoring:
• Run and monitor daily EDI processing jobs, including invoice generation and transmission
• Validate successful completion of EDI batches and investigate failures proactively
• Ensure timely processing of EDI invoices to support Finance and Accounts Receivable

Data Analysis & SQL Investigation:
• Use SQL to query internal databases to:
• Trace EDI transactions
• Validate data flow between systems
• Investigate discrepancies between EDI, ERP, and financial records
• Analyze EDI data structures (segments, elements, qualifiers) to identify root causes of issues

Cross Functional Collaboration:
• Work closely with Customer Service and Sales to resolve customer‑facing order and shipment issues
• Partner with Finance to support invoice accuracy, reconciliation, and dispute resolution
• Collaborate with internal IT and external vendors to resolve VAN, mapping, or integration issues

Documentation & Continuous Improvement:
• Document recurring issues, resolutions, and partner‑specific requirements
• Support improvements to EDI monitoring, alerting, and troubleshooting processes
• Assist with onboarding new customers or changes to existing trading partner setups

Required Skills & Qualifications Technical Skills:
• Technical Skills
• Hands‑on experience supporting EDI in a production environment
• Strong working knowledge of ANSI X12 EDI standards
• Experience with BizTalk and/or Cadacus (or comparable EDI platforms)
• Solid SQL skills for querying and troubleshooting transactional data
• Ability to read, analyze, and troubleshoot raw EDI files and mappings
• Business & Analytical Skills
• Strong understanding of the Purchase Order to Cash lifecycle
• High attention to detail with the ability to identify subtle data issues
• Strong problem‑solving and root‑cause analysis skills
• Ability to understand both technical EDI structures and business process impacts
• Soft Skills
• Clear communicator able to work with technical and non‑technical stakeholders
• Comfortable working in a fast‑paced, high‑volume EDI environment
• Self‑directed, organized, and able to manage multiple issues simultaneously

Nice to Have :
• Experience with Syspro ERP.
• Experience supporting food, manufacturing, or distribution EDI environments
• Experience with multiple VANs (e.g., SPS, TrueCommerce, GXS/OpenText, etc.)
• ERP integration experience (order management, shipping, invoicing modules)
• Experience supporting warehouse and 3PL EDI flows
• Experience with Boomi

Why This Role Matters
This position plays a critical role in revenue flow and customer satisfaction by ensuring that orders, shipments, and invoices are processed accurately and on time across a complex EDI landscape. The EDI Analyst acts as the bridge between customers, internal systems, and business teams, ensuring operational continuity and financial accuracy.