ERP Boomi Integration Architect

QAD, Inc.•Miami, FL

10d•$120,000 - $130,000•Remote

About The Position

The Systems Architect at Redzone is responsible for the full customer support lifecycle management of critical data synchronization pipelines, leveraging the Redzone API Suite, the Advanced Integrations module, and standardized data transfer methods. This role ensures seamless data exchange for key manufacturing processes, including Product Master Sync, Production Scheduling, and Production Reconciliation, primarily integrating Redzone with ERP systems such as QAD ERP (Adaptive/EE), Oracle NetSuite, and SAP S/4HANA. Other integrations the Systems Architect services are: Automation Integrations for SP and automated downtime, as well as Single Sign-On. The architect provides expert guidance and hands-on execution across all phases, including preparation, implementation, deployment, troubleshooting, and ongoing maintenance. This position is full-time, exempt, remote and based in the United States. Employee may be required to travel occasionally, up to 10% annually.

Requirements

Integration Platform Proficiency: Deployment coordination and configuration knowledge in integration platform as a service (iPaaS), specifically Boomi, including familiarity with process design, deployment, managing Extensions (Process Properties, Cross References), and mapping data formats (XML/JSON Canonical structures).
API Architecture: Deep understanding of REST (Representational State Transfer) architecture and capability to programmatically interact with APIs for CRUD operations.
Data Flow Knowledge: Knowledge of alternative integration pathways, including low-level data gathering via OPC/KepServerEX/RZLogger for production counts, and SFTP exchange for CSV imports.
Security and Access: Experience implementing SAML-based Single Sign-On (SSO) for user provisioning and authentication is desirable.
Ability to translate complex technical concepts clearly to non-technical stakeholders, utilizing clear explanations and detailed documentation (e.g., providing step-by-step guidance on API utilization and managing authentication credentials).
Ability to work independently, hosting and developing automated workflows where necessary.
Proficiency in identifying and communicating current integration constraints and suggesting alternative approaches or workarounds when core functionality is not available.

Nice To Haves

ERP/Manufacturing Context is a huge plus!
Knowledge of ERP systems, particularly SAP S/4HANA OData services (e.g., API_PRODUCT_SRV, API_PRODUCTION_ORDER_2_SRV) and NetSuite SOAP Web Services (e.g., Assembly Items, Work Orders). Familiarity with QAD QXtend components and business objects would put the candidate at a huge advantage.
Boomi Architect Certification is a big plus!

Responsibilities

Define Architectural Strategy: Design robust integration architectures based on documented pathways, including proprietary methods (QAD Integration Platform, Advanced Integrations via Boomi) and standard solutions (API Suite, SFTP, OPC UA, MQTT, and SAML Identity Providers).
ERP Configuration Alignment: Guide customers in configuring prerequisites within their source systems, such as implementing custom fields in their ERP.
Master Data Cross-Referencing: Establish and maintain cross-reference tables (often within Boomi or QAD's TurnaroundData table) to map ERP domains/sites (e.g., SAP Plant) to Redzone hierarchy (Organization ID, Enterprise ID, and Location/Production Line). This is critical for persisting Redzone UUIDs against external IDs for updates and deletion operations.
Boomi iPack Deployment: Deploy and configure pre-built or installable Boomi integration packs (iPacks) for core workflows, ensuring proper setup for data flows.
API Workflow Development: Utilize the RESTful Redzone API Suite for programmatic integrations involving CRUD operations.
SFTP Data Utility Implementation: Configure automated data import pipelines using the SFTP Utility for standardized, one-directional CSV file uploads (e.g., Production Run Schedules, Base Product data, Product Unit Conversions).
Single Sign-On Implementation: Coordinate with customers for them to configure their SAML-compatible Identity Provider and Redzone as an Identity Service Provider.
Debug and Resolve Errors: Provide expert troubleshooting for integration errors, including handling complex status codes (e.g., 400, 404, 409), addressing authorization failures (invalid organization/enterprise, expired bearer tokens), and resolving master data synchronization issues (e.g., "Product Type not found" errors due to missing UUIDs).
System Monitoring: Define and manage scheduled process frequency (e.g., Production Reconciliation polls frequently, often every 2–3 or 5 minutes; master data updates typically every 10–15 minutes) and implement comprehensive error handling and logging mechanisms.
Advanced Support: Leverage the availability of dedicated hypercare support during critical phases like implementation or go-live, as part of managed services commitments.
SSO Expertise: Implement and maintain Single Sign-On (SSO) solutions using SAML for user identity validation, understanding that this is an all-or-nothing approach for user authentication.