Integration Specialist

Insight Global; Pasadena (CA); On-site; USD 110,000 - 150,000; Full time

Job summary

Insight Global is seeking an Integration Specialist to design, develop, and deploy integrations using Boomi AtomSphere, connecting cloud-based and on-premise apps to enable seamless data exchange.

You will translate business requirements into technical specs, build Boomi processes, and implement APIs/web services while ensuring data health across the enterprise data platform (Databricks/Azure Data Lake). Strong collaboration with ERP/CRM owners is essential.

Qualifications

• Proven Boomi AtomSphere experience designing, building, deploying integrations.
• Strong ELT/data-pipeline understanding and cloud data platform exposure.
• Familiarity with source-to-target data mapping across ERP/CRM apps.
• Knowledge of integration patterns and best practices.
• Experience with APIs and web services (REST/SOAP).
• Proficiency in XML/JSON/CSV data formats.
• SQL and database concepts.
• Analytical and problem-solving skills; strong communication.
• Teamwork and collaboration skills.

Responsibilities

• Design, develop, and deploy Boomi integrations across cloud and on-prem systems.
• Translate business requirements into technical specs and integration solutions.
• Build/maintain Boomi processes, maps, and connectors for data exchange.
• Implement APIs and web services to support initiatives.
• Perform unit/integration/ performance testing for integrations.
• Develop data ingestion pipelines to Databricks Azure Data Lake Storage.
• Coordinate with JD Edwards, IFS, and Salesforce owners for data mappings.
• Monitor and maintain Boomi integrations and troubleshoot issues.
• Collaborate with analysts/devs to gather requirements and implement solutions.
• Stay current with Boomi features and best practices.
• Contribute to integration standards and resource optimization.

Skills

Boomi

ELT concepts

Data mapping

Integration patterns

API development

Data formats

SQL

Analytical

Communication

Education

Bachelor’s degree

Cloud knowledge (AWS/Azure)

Agile experience

Databricks experience

ADLS Gen2 knowledge

JD Edwards/ERP integration

IFS/ERP familiarity

Tools

Boomi AtomSphere

Databricks

Azure Data Lake Storage

Salesforce

JD Edwards

IFS

Job description

Job Description

Ranked among the top environmental firms nationwide, our client 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 would work 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 AtomSphere 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.

Essential Duties and Responsibilities

• Design, develop, and deploy integrations using Boomi AtomSphere 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 our clients 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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

Position Requirements

• Proven experience with Boomi AtomSphere 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.

Education and Experience

• Required: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Required: Knowledge of cloud technologies (e.g., AWS, Azure).
• 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 EnterpriseOne (including AIS / orchestration) and the data structures and interfaces used to integrate with it.
• Desired: Familiarity with IFS and other ERP systems, and the APIs/data formats used to exchange data with them.

Competencies:

• Proactivity/Initiative: Recognizes what needs to be done and accomplishes it in a manner appropriate for one’s level/position and with minimal supervision.
• Perseverance: Shows wherewithal to fight for difficult goals despite challenges and to bounce back from adversity.
• Motivation/Dedication: Commits to excellence in pursuing unselfish goals. Initiates action with collective goals, takes responsibility, and shows personal humility.
• Technical Curiosity/Willingness to Learn: Interest in seeking out new experiences, knowledge, and candid feedback; demonstrating an openness to learning and change.
• Insight: The ability to gather and make sense of information that suggests new possibilities.
• Engagement: Shows a knack for using emotion and logic to communicate a persuasive vision and connect with people.
• People Skills: Is approachable and gains the mutual trust and respect of others. Understands people’s strengths & weaknesses and actively seeks to understand other perspectives.
• Communication: Fosters open, honest, candid and respectful communication. Effectively assesses, defines and communicates issues in a timely manner, both written and verbal.
• Teamwork: The ability to effectively work toward common goals with others by supporting, encouraging, and sharing information in an authentic and approachable manner.
• Big Picture: Understands and contributes to the organizations’ short- and long-term business strategy. On a personal level has independently developed a vision for short- and long-term career success.
• Problem-Solver: Ability to identify, analyze, and solve problems in support of personnel, group, department, or organizational objectives.
• Execution: Effectively takes a vision and translates into action by including the right people. Identify and remove barriers, when possible, to achieve results. Demonstrates appropriate compromise, effective time management, prioritization practices and holds team members (including themselves) accountable for their performance/conduct.
• Professionalism: Respectfully observes and challenges the status quo with intent for improvement. Can take direction, accept feedback, and take full responsibility for his/her actions. Lead by example through positive influence and ethical leadership with consideration of the entire organization.

Job Responsibility Level

• No direct reports

Travel Requirements:

• No travel is required for this position.

Hours:

• This is an exempt position. Workdays are scheduled from Monday through Friday. Typically, work hours begin and end between 7:00 am and 5:00 pm as scheduled with the position's supervisor. Occasional overtime may be necessary for business needs.