EDI Analyst

Position Summary

We are seeking an experienced EDI Analyst (1 year contract) to support and troubleshoot our complex EDI environment across Sunrise and Grand River. 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 (Biz Talk 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.

• Troubleshoot inbound and outbound EDI transactions across Biz Talk 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

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.

• 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

• 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

• 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

• 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

• Hands‑on experience supporting EDI in a production environment
• Strong working knowledge of ANSI X12 EDI standards
• Experience with Biz Talk 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

• 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

• Clear…