Integration Specialist

General Job Description

Since 1934, ACCO Engineered Systems has been an industry leader in designing, fabricating, installing, and servicing complex mechanical systems across the Western United States. Ranked among the top environmental firms nationwide, ACCO is a 100% Employee-Owned Company (ESOP). Our employee-owners actively participate in the company's financial success, boasting retirement stability far above the industry average. This position works out of Corporate Headquarters in Pasadena, California.

Driven by historic growth and an aggressive pipeline of future expansion projects, our Digital Operations team is scaling quickly.

The Integration Specialist role is responsible for designing, developing, and deploying integrations using the Boomi Atom Sphere platform, connecting cloud-based and on-premises applications to support business operations and strategic initiatives. This position plays a key role in translating business requirements into technical integration solutions, ensuring reliable data exchange between systems, and maintaining the health and performance of integrations across the organization.

• Design, develop, and deploy integrations using Boomi Atom Sphere platform, connecting cloud-based and on-premises applications.
• Translate business requirements into technical specifications and develop integration solutions accordingly.
• Build and maintain Boomi processes, maps, and connectors to facilitate data exchange between systems.
• Implement APIs and web services to support integration initiatives.
• Perform unit testing, system integration testing, and performance testing to ensure quality and reliability of integrations.
• Support and develop data ingestion pipelines that move data between source systems and ACCO's enterprise data platform (Databricks / Azure Data Lake Storage).
• Coordinate with ERP and CRM system owners (JD Edwards, IFS, Salesforce) to define source/target mappings and ensure reliable, well-governed data exchange.
• Assist with day-to-day integration monitoring, error handling, and incident response across the Boomi and data-pipeline landscape.
• Troubleshoot and resolve integration issues in a timely manner.
• Monitor and maintain the health and performance of Boomi integrations.
• Collaborate with cross-functional teams (e.g., business analysts, application developers) to gather requirements and implement solutions.
• Stay up-to-date on the latest Boomi features and best practices.
• Contribute to the development and improvement of integration standards and processes.
• Make recommendations on how to best use integration resources and build in reliability.

• Proven experience with Boomi Atom Sphere platform, including process building, mapping, and deployment.
• Understanding of ELT/data-pipeline concepts and how operational integrations feed a cloud data platform.
• Familiarity with source-to-target data mapping across enterprise business applications.
• Strong understanding of integration patterns and best practices.
• Experience with API development and web services (REST, SOAP).
• Proficiency in data formats such as XML, JSON, CSV.
• Knowledge of database concepts and SQL.
• Excellent analytical and problem‑solving skills.
• Strong communication and collaboration skills.

• Required: Bachelor's degree in Computer Science, Information Technology, or a related field.
• Required: Knowledge of cloud technologies (e.g., AWS, Azure).
• Desired: Boomi certifications (e.g., Associate Developer, Professional Developer).
• Desired: Experience with other integration platforms (e.g., Talend, Mule Soft, Informatica).
• Desired: Experience with Agile development methodologies.
• Desired: Experience with Databricks (Unity Catalog, Delta Lake, notebooks, and Lakeflow / Delta Live Tables) for data ingestion and transformation.
• Desired: Familiarity with Azure Data Lake Storage (ADLS Gen2) and medallion (bronze/silver/gold) lakehouse architecture patterns.
• Desired: Hands‑on experience integrating with Salesforce (REST/Bulk APIs, platform events, sandbox‑to‑production deployment).
• Desired: Knowledge of JD Edwards Enterprise One (including AIS/orchestration) and the…