COMMERCIAL INTEGRATION ENGINEER

Sound Seal - Springfield, MA

Full-time - Mid Level

Springfield, MA

Merchant Wholesalers, Durable Goods

About the position

The Commercial Integration Engineer at Catalyst Acoustics Group will be responsible for designing, developing, and optimizing system integrations for commercial reporting and customer-facing tools. This role is crucial for enhancing platform automation and will directly impact the business's growth by collaborating with marketing and channel teams. The position requires expertise in API integration, SQL optimization, and system integration, ensuring seamless functionality across various platforms.

Responsibilities

• Architect integration solutions for production critical tools specific to self-serving channel platforms.
• Lead the integration and enhancement of API connections across key commercial platforms, including HubSpot, Pipedrive, and Configure Price Quote (CPQ) systems.
• Identify, design, and implement new API opportunities to improve system interoperability and enhance data flow between internal and external platforms.
• Serve as the technical liaison to the sales analyst producing BI dashboards and ERP clean up.
• Design, develop, and maintain efficient ETL pipelines using industry best practices.
• Review and refactor existing SQL-based ETL processes to improve performance, reliability, and maintainability.
• Monitor ETL processes to ensure data is accurately and efficiently loaded into data warehouses or data lakes.
• Develop, modify, and maintain high-performance APIs between CRM systems and ERP solutions.
• Collaborate with external vendors, integration partners, and internal teams to troubleshoot performance and resolve functional issues in real-time.
• Manage external development partners and work closely with the IT team to integrate new code into existing CI/CD pipelines.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience).
• Minimum of 5-7 years in API development, implementation, and ongoing systems management.
• Deep knowledge of API orchestration and management of multiple API workflows.
• Expertise in SQL (T-SQL, PL/SQL), query optimization, stored procedures, and database performance tuning.
• Experience with cross-platform development, specifically in CRM and ERP integration.
• Proficiency in data warehousing concepts, star/snowflake schema design, and data modeling techniques.
• Familiarity with Azure cloud platforms and experience with cloud-based databases and data lakes.
• Understanding of sales and marketing projects and business growth objectives.
• Strong leadership skills to coordinate cross-functional teams and external vendors.
• Experience integrating commercial CRM platforms (HubSpot, Pipedrive) and ERP systems.

Nice-to-haves

• Front-end and back-end development expertise with a focus on system integration.
• Expertise in service-oriented architecture (SOA).
• Proficiency with common API development tools, including J2EE, JUnit, Makefile, version control, JSON, PHP, Bovine systems, Apache JMeter, and customer interfaces.
• Experience with automation tools (e.g., Integromat, MAKE, Zapier) and platforms like HubSpot and Pipedrive.
• Understanding of ERP systems integration.

Benefits

• Competitive compensation package
• Comprehensive training programs
• Friendly and professional working environment that supports career and personal development