Integration Analyst
Teasdalelatinfoods
·Today
- Location
- Corporate, United States of America
- Workplace
- Remote
- Type
- Full-time
- Seniority
- Mid
- Experience
- 3+ years
- Visa
- Not sponsored
- Closing date
- Today
- Source
- Workday
Description
Integration Analyst | Carrollton, TX | 100% on-site
Remote and hybrid work arrangements and relocation assistance are unavailable.
Candidates must be authorized to work in the U.S. without current or future sponsorship.
OVERVIEW:
At Teasdale Latin Foods, you’ll help customer orders move accurately from receipt through shipping and invoicing. You’ll map and troubleshoot electronic data interchange (EDI) transactions and use SQL to build reports that operations, supply chain, customer service, and finance rely on.
You’ll also support the enterprise resource planning (ERP) system and lead integration projects from request through rollout.
WHAT YOU'LL DO:
EDI and trading partner integration:
- Onboard trading partners and translate their specifications into field 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). Include partial shipments and document results before go-live.
- Monitor inbound and outbound transactions, including planning schedules (830), shipping schedules (862), and functional acknowledgments (997).
- Trace missing or rejected transactions by comparing the source document, translated values, and ERP record. Correct the cause and verify that the transaction processes once in the receiving system.
Data integration and reporting:
- 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 as it moves between systems.
- Write and tune SQL queries, views, and stored procedures that link order lines, shipments, invoices, and inventory. Reconcile quantities and amounts to source records so split shipments and partial invoices are counted correctly.
- Build reports and dashboards for order-to-ship performance, on-time delivery, inventory, and integration health. Agree with business users on KPI definitions, including which dates determine on-time delivery and how to count partial shipments.
- Create exception reports that identify orders missing from the ERP or shipments awaiting an invoice. Include the customer, order, and transaction details teams need to investigate.
- Document data flows, mappings, business rules, and report definitions. Automate recurring extracts and reports with scripts and scheduled jobs, and give users self-service access where practical.
Software integration and ERP support:
- Monitor and troubleshoot APIs, web services, flat files, middleware, and scheduled jobs. Identify why interfaces fail and work with vendors and application owners to prevent repeat failures.
- Gather requirements and configure, test, and deploy interface changes and ERP upgrades. Maintain interface inventories and support procedures, and follow 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 opportunities for automation.
Project management:
- Lead small to mid-sized integration, reporting, and ERP projects. Define 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.
WHAT YOU'LL NEED:
Required qualifications:
- 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 that 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 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 other 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 in conversation.
Preferred qualifications:
- 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.
WHY TEASDALE:
At Teasdale Latin Foods, our People Principles are all about Living LATIN.
What is LATIN, and how do I live it? Let us fill you in.
- L is Learning. It emphasizes the importance of continuous learning and development within Teasdale and promotes a culture of curiosity, exploration, and acquiring new knowledge and skills.
- A is Accountability. This encourages individuals to take ownership of their actions and responsibilities, promoting a sense of personal and collective accountability ensuring we understand how to achieve our goals.
- T is Teamwork. It emphasizes the value of diverse perspectives, collective problem-solving, and synergy among team members, enabling us to achieve greater outcomes by leveraging the strengths and expertise of our employees.
- I is Innovation. This promotes an environment where we are empowered to think outside the box, challenge the status quo, and seek innovative solutions to problems, fostering an atmosphere of adaptability and openness to change.
- N is Nurturing. It emphasizes the importance of supporting and developing our employees' well-being, growth, and potential, showing that we care and are willing to invest in their long-term success and satisfaction.
We believe in finding the right people for the right roles and helping them to build careers. If this sounds like a place you'd like to be, hit apply!
Still not convinced? What about:
- Day One - Health, Dental, and Vision Benefits
- 401(k) Retirement Plan with Matching Contributions at 60 Days
- Career Growth Opportunities and Professional Development
If you are passionate about being the right kind of contributor, the point person of a fast-paced diverse workforce, and a steward of great tradition, come join the family. We want people who are up for a challenge. Let's live LATIN!