Summary

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

Responsibilities

• Support, design, develop, and implement integration solutions between ERP, WMS, SharePoint, Power BI, Power Automate, and other business applications to streamline processes and data exchange.
• Write, optimize, and maintain complex SQL queries, stored procedures, and scripts to support data integration, reporting, and system functionality.
• Collaborate with stakeholders to gather integration requirements, troubleshoot issues, and ensure systems meet business needs.
• Configure and customize APIs, middleware, or other integration tools to connect disparate systems effectively.
• Develop and maintain the enterprise reporting system.
• Monitor and maintain integration workflows, identifying and resolving performance bottlenecks or data inconsistencies.
• Ensure data integrity, security, and compliance with organizational standards during integration processes.
• Document technical specifications, integration workflows, and processes for future reference and team knowledge sharing.
• Provide technical support and training to end-users or team members on integrated systems, as needed.
• Stay up-to-date on industry trends and emerging technologies and recommend improvements to existing integrations.
• Continually look for ways to improve processes and systems to make them more efficient and effective.
• Comply with all company policies and procedures.
• Provide occasional on-call support for critical integration issues.
  
  

Requirements

• 5+ years of experience in systems integration, focusing on ERP and WMS platforms.
• 3+ years of experience integrating SharePoint with external systems (e.g., CRM, ERP, WMS, or databases) using APIs, Web Services, Power BI, or Power Automate.
• Experience working in the Manufacturing or Distribution industry (preferably in Contract Manufacturing).
• Advanced proficiency in SQL including query optimization, database design, and data manipulation.
• Creating reports with SSRS.
• Hands-on experience with integration tools and technologies (e.g., APIs, REST/GraphQL, ETL tools, VisualCron, Power BI, Power Automate, etc.).
• Solid familiarity with ERP and WMS system architecture and workflows.
• Strong problem-solving skills and the ability to troubleshoot complex technical issues.
• Excellent communication skills to work with technical and non-technical stakeholders.
• Ability to manage multiple projects and prioritize tasks in a fast-paced environment.
• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  
  

Preferred

• Experience with Macola, WISYS, or Agility.
• Knowledge of programming languages, including Python, C#, or Java, for custom integration development.
• Experience supporting, troubleshooting, and integrating EDI processes.
• Certifications in SQL, SharePoint, Power BI, ERP/WMS systems, or integration platforms.
• Experience working in the Contract Manufacturing industry.
  
  

This is a 6-month Contract-for-Hire onsite opportunity with potential extensions for our Northern suburb MN client. Employee benefits include Medical/Dental Benefits, Paid time off, Paid Holidays, and 401(k) (with immediately vested company match) available with TriCom during the contract period. H1-B Visa sponsorship is not available for this position. No third-parties, please.