Technical Architect - Data Integration (ERP Integration)

About the Role

As a Technical Architect, Data Integration, you will be a key member of our client services team, helping customers solve data integration challenges during the implementation and go-live phases. You will work closely with customers, many of whom are small and medium-sized businesses (SMBs), to develop creative and scalable solutions for integrating their data into our supply chain planning products. The role requires expertise in working with a wide range of ERPs, including NetSuite, Epicor, P21, Salesforce.com, and Microsoft CRM/Dynamics. You should also have proficiency in flat file handling, APIs, and data transformation techniques. Your ability to understand the unique complexities of data within SMB environments, particularly those with multiple ERPs, will be critical to your success.

Key Responsibilities

• Design, develop, and implement data integration solutions for customers during the implementation and go-live phases.
• Collaborate directly with customers to understand their ERP systems, data sources, and integration requirements, and develop tailored solutions to ensure smooth data integration.
• Work with various ERP systems such as NetSuite, Epicor, P21, Salesforce.com, and Microsoft CRM/Dynamics to create integration strategies that leverage their available capabilities.
• Work with partners to augment staff needs and leverage their knowledge or expertise to address any gaps in capabilities.
• Handle data extraction, transformation, and loading (ETL) from multiple ERP sources, using tools such as Apache Nifi, Talend, or AWS Glue, providing solutions to merge data from disparate systems.
• Design and implement flat file-based integrations, including CSV, XML, and other formats, to enable seamless data exchange.
• Provide expertise on API-based integrations for ERPs that support them, including training and guiding customers to address any skill gaps in using these APIs effectively.
• Collaborate with internal product and engineering teams to improve the integration capabilities of our supply chain solutions.
• Develop best practices, documentation, and reusable tools that help streamline future integrations and reduce friction for our customers.
• Support customers with data validation, ensuring data quality, consistency, and accuracy during and after integration.
• Provide creative solutions to data integration challenges, especially for customers with multiple ERPs and limited IT resources.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• 5+ years of experience in data integration, technical consulting, or ERP implementation roles.
• Strong understanding of data integration methodologies, including ETL processes, flat file handling, and API integrations.
• Experience working with ERP systems such as NetSuite, Epicor, P21, Salesforce.com, and Microsoft CRM/Dynamics, with a focus on data extraction and integration.
• Hands-on experience in integrating multiple ERP systems, addressing challenges related to disparate data sources, and providing creative solutions for merging data.
• Proficiency in working with flat files (CSV, XML, JSON) for data integration purposes, including data validation and transformation.
• Familiarity with cloud platforms (e.g., AWS, Azure) and their data integration tools and services.
• Strong problem-solving skills and the ability to work independently to develop solutions tailored to specific customer needs.
• Excellent communication skills, with the ability to effectively collaborate with customers and cross-functional teams.
• Ability to guide and educate customers who may not have in-house technical expertise, helping them understand integration processes and overcome challenges.

Preferred Qualifications

• Experience with supply chain management and familiarity with supply chain concepts such as inventory optimization and demand planning.
• Hands-on experience working with integration tools such as Mulesoft, Dell Boomi, or similar.
• Experience working with customers in SMB environments, understanding their unique challenges and providing practical solutions.
• AWS, GCP, or Azure certifications related to data integration or cloud architecture.