Integration Analyst

Teasdale Foods•Carrollton, TX

15h

About The Position

The Integration Analyst connects the company’s business systems and turns their data into usable information. The role focuses on data integration and reporting, supporting software integrations that move data between systems, providing ERP support (including EDI), and managing IT and systems projects from request through delivery. It suits a technically strong problem solver comfortable with SQL and XML who communicates well with business and IT partners and can drive projects to completion. The analyst designs and maintains integrations and reporting, supports and troubleshoots enterprise and third-party application interfaces, provides day-to-day ERP and EDI support, and leads small- to mid-size IT and systems projects. The position collaborates with stakeholders, vendors, developers, application owners, and business users, and maintains technical documentation and project communications.

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; manufacturing experience is preferred.
Strong proficiency in SQL, including complex queries, joins, views, stored procedures, and performance tuning.
Working knowledge of XML and related formats such as XSD/XSLT and JSON for data exchange and transformation.
Experience with reporting and analytics tools such as Power BI, Tableau, SSRS, or similar.
Experience supporting an ERP system such as SAP, Oracle, Deacom, or similar.
Experience supporting application integrations, including APIs, web services, flat files, middleware, or ETL tools.
Project management experience, including planning, stakeholder communication, and delivery.
Working knowledge of EDI concepts, standards, and communication protocols.
Strong analytical, troubleshooting, and documentation skills, with excellent written and verbal communication.

Nice To Haves

Experience with an EDI translation platform or managed service such as SPS Commerce, TrueCommerce, or similar.
Scripting or automation experience, such as Python or PowerShell.
Project management certification (PMP or CAPM) or Agile/Scrum experience.
Knowledge of manufacturing processes, including MRP, forecasting, shipping, and inventory control.
Familiarity with ITIL or IT service management practices.

Responsibilities

Design, build, and maintain data integrations and extracts between the ERP, EDI platform, and other business systems, including HR, finance, and reporting tools.
Develop and support reports, dashboards, and KPIs for operations, supply chain, customer service, and finance.
Write, tune, and maintain SQL queries, views, and stored procedures; use XML and related formats to move, transform, and validate data.
Validate data quality, reconcile data across systems, identify root causes of data issues, and correct them.
Translate stakeholder reporting and data needs into requirements and deliver self-service reporting where possible.
Document data flows, mappings, business rules, and report definitions.
Automate manual data handling and recurring reports using scripting and scheduled processes.
Support and troubleshoot integrations between enterprise and third-party applications, including APIs, web services, flat files, middleware, and scheduled jobs.
Monitor integration jobs and interfaces, resolve failures, and perform root cause analysis to prevent recurrence.
Configure, test, and deploy interface changes with vendors, developers, and application owners.
Gather requirements and support the design and testing of new integrations and application upgrades.
Maintain technical documentation, interface inventories, and support procedures.
Support application security, access, and change-control practices related to integrations.
Provide day-to-day ERP support, including troubleshooting, user assistance, configuration, data corrections, and master data maintenance for order, inventory, purchasing, shipping, and invoicing processes.
Participate in ERP testing, upgrades, enhancements, and release management.
Understand business users’ process needs and recommend ERP improvements and automation opportunities.
Monitor inbound and outbound EDI transactions and resolve errors.
Assist with onboarding and testing new trading partners and coordinate with customers, suppliers, carriers, and EDI service providers.
Lead small- to mid-size IT and systems projects, including integrations, ERP enhancements, reporting initiatives, and system upgrades.
Define project scope, requirements, timelines, budgets, and deliverables; maintain project plans, risk and issue logs, and status reports.
Coordinate cross-functional teams and external vendors or consultants.
Facilitate requirements sessions, user acceptance testing, cutover planning, training, and post-go-live support.
Apply consistent project and change management practices and communicate progress to stakeholders and leadership.