The Data Integration Specialist will support, maintain, design, and develop seamless integrations between enterprise systems, with a focus on ERP (Enterprise Resource Planning) and WMS (Warehouse Management System) platforms. This role blends technical expertise, problem-solving skills, and collaboration with cross-functional teams to ensure robust and scalable integrations.

Key Responsibilities include:

1. Support, design, develop, and implement integration solutions between ERP, WMS, SharePoint, Power BI and other business applications to streamline processes and data exchange.
2. Write, optimize, and maintain complex SQL queries, stored procedures, and scripts to support data integration, reporting, and system functionality.
3. Collaborate with stakeholders to gather integration requirements, troubleshoot issues, and ensure systems meet business needs.
4. Configure and customize APIs, middleware, or other integration tools to connect disparate systems effectively.
5. Development and maintenance of enterprise reporting.
6. Monitor and maintain integration workflows, identifying and resolving performance bottlenecks or data inconsistencies.
7. Ensure data integrity, security, and compliance with organizational standards during integration processes.
8. Document technical specifications, integration workflows, and processes for future reference and team knowledge sharing.
9. Provide technical support and training to end-users or team members on integrated systems as needed.
10. Stay updated on industry trends and emerging technologies to recommend improvements to existing integrations.
11. Other essential functions
12. Continually look for ways to improve processes and systems to make them more efficient and effective.
13. Comply with all company policies and procedures.
14. Occasional on-call support for critical integration issues

Knowledge, Skills and Abilities:

1. Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
2. 5+ years of experience in systems integration, with a focus on ERP and WMS platforms. Experience with Macola, WISYS or Agility are a plus.
3. 3+ years of experience integrating SharePoint with external systems (e.g., CRM, ERP, WMS, or databases) using APIs, web services, or middleware.
4. Experience working in a Manufacturing or Distribution Industry, preferably in contract manufacturing
5. Advanced proficiency in SQL, including query optimization, database design, and data manipulation.
6. Hands-on experience with integration tools and technologies (e.g., APIs, REST/GraphQL, ETL tools, VisualCron, and middleware).
7. Familiarity with ERP and WMS system architecture and workflows.
8. Strong problem-solving skills and the ability to troubleshoot complex technical issues.
9. Excellent communication skills to work with technical and non-technical stakeholders.
10. Ability to manage multiple projects and prioritize tasks in a fast-paced environment.

Preferred Knowledge Skills and Experience:

1. Knowledge of programming languages such as Python, C#, or Java for custom integration development.
2. Experience supporting, troubleshooting, and integrating EDI processes.
3. Certifications in SQL, SharePoint, Power BI, ERP/WMS systems, or integration platforms are a plus.