Integration Analyst

Teasdale Latin Foods•Carrollton, TX
•Onsite

About The Position

The Integration Analyst supports accurate customer order processing from receipt through shipping and invoicing. The role maps and troubleshoots electronic data interchange (EDI) transactions, builds SQL reports used by operations, supply chain, customer service, and finance, supports the enterprise resource planning (ERP) system, and leads integration projects from request through rollout. The position is based in Carrollton, Texas and is 100% on-site; remote or hybrid arrangements and relocation assistance are unavailable. The analyst onboards trading partners and maps EDI documents to the ERP; tests order-cycle transactions and monitors inbound and outbound exchanges. The role also builds and maintains integrations and extracts across the ERP, EDI platform, and other systems, transforms and validates data with XML, and develops reports, dashboards, exception reports, and automated reporting processes. It monitors and troubleshoots interfaces, supports ERP users and system changes, and leads small to mid-sized integration, reporting, and ERP projects through requirements, testing, cutover, training, and post-launch support. Candidates must be authorized to work in the United States without current or future sponsorship. The company describes its culture through the People Principles of Learning, Accountability, Teamwork, Innovation, and Nurturing.

Requirements

  • Bachelor’s degree in Information Systems, Computer Science, Supply Chain, Business, or a related field, or equivalent experience.
  • 3–5+ years of experience in data integration, reporting, ERP support, or a related IT role.
  • Hands-on experience mapping and testing EDI transactions with trading partners, resolving production errors, and verifying corrections reach the receiving system.
  • Working knowledge of EDI standards and communication protocols.
  • Strong SQL skills, including complex joins, views, stored procedures, and performance tuning.
  • Experience using SQL and a reporting tool such as Power BI, Tableau, or SSRS to build operational reports from ERP data and reconcile results to source transactions.
  • Working knowledge of XML and related technologies such as XSD or XSLT, and familiarity with data exchange formats such as JSON.
  • Experience supporting an ERP such as SAP, Oracle, or Deacom and application integrations using APIs, web services, flat files, middleware, or ETL tools.
  • Experience planning and delivering projects.
  • Strong analytical, troubleshooting, and documentation skills, with the ability to explain technical findings to business users in writing and conversation.
  • Authorization to work in the United States without current or future sponsorship.

Nice To Haves

  • Experience with an EDI translation platform or managed service such as SPS Commerce or TrueCommerce.
  • Manufacturing experience and knowledge of material requirements planning (MRP), forecasting, shipping, and inventory control.
  • Scripting or automation experience with Python, PowerShell, or a similar language.
  • PMP or CAPM certification, or experience working in Agile or Scrum environments.
  • Familiarity with ITIL or IT service management practices.

Responsibilities

  • Onboard trading partners and translate their specifications into mappings between EDI documents and the ERP; validate item numbers, units of measure, and ship-to locations with customers, suppliers, carriers, and EDI service providers.
  • Test the order cycle from purchase order (850) and acknowledgment (855) through advance ship notice (856) and invoice (810), including partial shipments, and document results before go-live.
  • Monitor inbound and outbound transactions, including planning schedules (830), shipping schedules (862), and functional acknowledgments (997).
  • Investigate missing or rejected transactions by comparing source documents, translated values, and ERP records; correct causes and verify successful processing in the receiving system.
  • Build and maintain integrations and extracts across the ERP, EDI platform, and systems such as HR and finance; use XML to transform and validate data.
  • Write and tune SQL queries, views, and stored procedures that link order lines, shipments, invoices, and inventory; reconcile quantities and amounts to source records, including split shipments and partial invoices.
  • Build reports and dashboards for order-to-ship performance, on-time delivery, inventory, and integration health; establish KPI definitions with business users.
  • Create exception reports that identify orders missing from the ERP or shipments awaiting an invoice, including details needed for investigation.
  • Document data flows, mappings, business rules, and report definitions; automate recurring extracts and reports with scripts and scheduled jobs, and provide self-service access where practical.
  • Monitor and troubleshoot APIs, web services, flat files, middleware, and scheduled jobs; identify interface failures and work with vendors and application owners to prevent recurrence.
  • Gather requirements and configure, test, and deploy interface changes and ERP upgrades; maintain interface inventories and support procedures while following security, access, and change controls.
  • Support ERP users in order management, inventory, purchasing, shipping, and invoicing; troubleshoot issues, maintain configuration and master data, correct records, and identify automation opportunities.
  • Lead small to mid-sized integration, reporting, and ERP projects by defining scope, budgets, timelines, and deliverables; track risks and issues and communicate progress to stakeholders and leadership.
  • Coordinate internal teams, vendors, and consultants through requirements gathering, user acceptance testing, cutover, training, and post-launch support; apply consistent project and change management practices.

Benefits

  • Day One health, dental, and vision benefits.
  • 401(k) retirement plan with matching contributions at 60 days.
  • Career growth opportunities and professional development.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service