Data Engineer
WernerCo.
AzureCloudERPETLMatillionPythonSOAPSQL
Senior Automation Engineer, iPaaS, Salesforce
Carta
full-time
Posted on:
Location Type: Office
Location: Salt Lake City • Utah • 🇺🇸 United States
Visit company websiteJob Level
Senior
Tech Stack
ERPETLSOAP
About the role
- Design, develop, and maintain workflows/integrations between Salesforce and other enterprise systems using an iPaaS platform (Workato experience preferred).
- Leverage AI-assisted development tools to streamline recipe creation, automate testing, and accelerate troubleshooting.
- Collaborate with business systems analysts, admins, and stakeholders to gather requirements, map data flows, and design optimal integration solutions.
- Build scalable, reusable, and secure recipes/workflows while adhering to best practices.
- Implement error handling, logging, and monitoring for integrations to ensure reliability and traceability.
- Optimize existing integrations to improve performance and reduce operational costs.
- Maintain integration documentation, including data mapping, field transformations, and workflow logic.
- Support and troubleshoot integration issues, working closely with internal teams and vendors to resolve them promptly.
- Work with Salesforce development and admin teams to implement APIs, triggers, flows, and declarative tools where needed.
- Ensure compliance with security and data governance policies for all integrations.
- Stay current with new features and capabilities in Workato, Salesforce, AI-assisted automation, and other connected systems.
Requirements
- 3+ years of experience in integration development, preferably on an iPaaS platform (Workato strongly preferred; experience with MuleSoft, Boomi, Jitterbit, or similar is a plus).
- Strong understanding of Salesforce data model, APIs (REST, SOAP, Bulk), Apex, SOQL, and declarative tools.
- Proven ability to work with JSON, XML, CSV, and other structured/unstructured data formats.
- Experience with authentication methods (OAuth 2.0, JWT, API keys, SSO).
- Hands-on experience with AI-powered tools or scripts to accelerate integration development and testing.
- Strong troubleshooting skills for integrations, API connectivity, and data mapping issues.
- Familiarity with version control (Git) and agile development practices.
- Excellent communication skills to work with both technical and non-technical stakeholders.
- Workato certification(s) or Salesforce Platform Developer/Administrator certifications (preferred).
- Experience integrating Salesforce with ERP, marketing automation, HRIS, and other SaaS/enterprise platforms (preferred).
- Knowledge of ETL/ELT concepts and data warehousing fundamentals (preferred).
- Exposure to CI/CD pipelines for integration deployments (preferred).
ATS Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
integration developmentiPaaSSalesforceAPIsApexSOQLJSONXMLCSVETL
Soft skills
troubleshootingcommunicationcollaborationproblem-solvingrequirements gatheringdata mappingstakeholder engagementdocumentationoptimizationerror handling
Certifications
Workato certificationSalesforce Platform DeveloperSalesforce Administrator
