Associate Talend Data Integration Jobs in California

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 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 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.

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: Boomi certifications (e.g., Associate Developer, Professional Developer).

• Desired: Experience with other integration platforms (e.g., Talend, MuleSoft, 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 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.

ACCO 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 the 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 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 a problem in support of personal, 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. Is able to take direction, accept feedback, and take full responsibility for his/her actions. Leads by example through positive influence and ethical leadership with consideration of the entire organization.

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• The employee may regularly lift and/or move up to 10 pounds, and occasionally lift and/or move up to 30 pounds

Hours: This is a non-exempt position from Monday through Friday. Work hours begin and end between 7:00 am and 5:00 pm with a one-hour break for lunch and two rest breaks. Eight hours per day is required and other occasional overtime may be necessary per business needs.

Travel: No travel is required for this position.

Competitive Wages:

$120,000 to $150,000 Annual Salary. Applicants please note that actual compensation is determined by several factors that are unique to each candidate, including but not limited to job-related skills, depth of experience, certifications, relevant education or training, and specific work location, among others. The offered wage or salary is only one aspect of an employee's total compensation.  

#ACCO

#LI-AL1

Why join ACCO? ACCO Engineered Systems is one of the largest mechanical contractors in the country. Since 1934, owners and builders have selected ACCO to design, install, and maintain more than 250,000 mechanical projects. ACCO is dedicated to the design, fabrication, installation, maintenance and service of commercial and industrial HVAC, refrigeration, plumbing, process piping, and building automation systems. Whether your project is a low or high-rise office building, a shopping mall, hospital, semi-conductor fabrication facility or pharmaceutical manufacturing plant...ACCO can design, build, install, and maintain a mechanical system to meet your needs.

Here at ACCO, we are a part of something bigger. Just ask our customers: California Academy of Sciences, L.A. Live, and San Francisco 49ers Stadium. While we have been around for 80+ years, we continue to grow at a dynamic pace. And we are looking for talented individuals to join our team.
What's great about working at ACCO is that we're a big enough company to be the leader in HVAC mechanical contracting in California and the Southwest U.S., but as a 100% employee-owned ESOP, we're a private company with a family-oriented feel. Several of our employees have worked at ACCO for twenty-five, thirty, and even over forty years! Together, the employees of ACCO are comprised of intelligent, dedicated, and entrepreneurial team members who put customers first and enjoy what they do.

ACCO IS AN EQUAL OPPORTUNITY EMPLOYER AA M/F/V/D.  

We proudly hire U.S. Military Veterans, and those qualified are encouraged to apply.

Equal Employment Opportunity is The Law.|Pay Transparency Nondiscrimination Provision

ACCO will consider qualified applicants with criminal histories for employment.