Integration Analyst Full (DTS) | Senior Associate 2 [tag01]

Job Description & Summary

At PwC, our business applications consulting team specializes in consulting services for a variety of business applications, helping clients optimize operational efficiency. These professionals analyze client needs, implement software solutions, and provide training and support for seamless integration and utilization of business applications, enabling clients to achieve their strategic goals.

As a generalist Salesforce consultant at PwC, you will possess a wide range of skills and experience in consulting across various Salesforce applications. You will provide consulting services to clients, analyzing their needs, implementing software solutions, and offering training and support for the effective use of Salesforce applications. Your versatile knowledge will allow you to help clients optimize operational efficiency and achieve their strategic goals.

With a focus on relationships, you build meaningful connections with clients and learn to manage and inspire others. As you navigate increasingly complex situations, you develop your personal brand, deepen your technical expertise, and awareness of your strengths. You are expected to anticipate the needs of your teams and clients and deliver quality. Embracing growing ambiguity, you are comfortable when the path forward is unclear, ask questions, and use these moments as opportunities for growth.

Examples of skills, knowledge, and experiences you need to lead and deliver value at this level include, but are not limited to:

Job Mission

• Deliver secure, resilient, and observable Coupa ">" Datasul integrations, ensuring consistent data, reduced rework, and compliance with business SLAs/SLOs.
• Translate business requirements into clear, implementable, and testable integration specifications, with adequate documentation and governance.

Requirements:

• Completed degree in Computer Science, Computer Engineering, Information Systems, or related fields; Postgraduate/Specialization in Integration, Software Architecture, Data Engineering, or related fields will be considered differentials.
• Solid experience in integrations between Coupa and ERPs, with specific experience in integrations with Datasul (TOTVS) or equivalent projects in the TOTVS ecosystem.
• Practical mastery of Coupa: REST APIs, and integrations via SFTP/files; Datasul (TOTVS): integrations via Web Services (SOAP/REST), EAI/Integration Broker, and file exchanges (CSV/TXT/SFTP) for Purchasing, Receiving, Accounts Payable, and Financial modules; Patterns and styles: synchronous/asynchronous integrations, EIP, messaging/queues (e.g., Kafka/RabbitMQ, when applicable), contract versioning, idempotence, retry/backoff, timeouts, and circuit breakers; Protocols/formats: HTTP, SFTP; JSON, XML/cXML, CSV; notions of XSD/XPath and schema validation; Tools: Postman/Insomnia, SoapUI, Git; basic CI/CD pipelines; monitoring/observability (e.g., Grafana/Prometheus, ELK/EFK or equivalents); basic SQL for queries and data reconciliation; ability to read technical logs and interpret API/WS errors.
• Experience in agile methods (Scrum/Kanban), collaborative work with business and IT areas, and clear communication with suppliers/third parties.
• Intermediate to advanced English (reading, writing, and conversation) for interaction with global teams, partners, and technical documentation.
• Hands-on profile, attention to detail, organization, sense of urgency, and analytical capacity.

Main responsibilities:

Discovery and Analysis

• Gather and detail functional and non-functional requirements with stakeholders (Purchasing, Accounts Payable, Tax, IT).
• Map data entities and domains: suppliers, accounting/GL accounts, cost centers, projects, items/catalogs, taxes/retentions, users/roles, locations/addresses.
• Define integrated P2P flows: Requisition ">" Approval ">" Purchase Order ">" Receiving/ASN ">" Invoice ">" 2/3-way match ">" Payment ">" Returns/write-offs.
• Specify contracts, field mappings, transformation/validation rules, and reconciliation criteria.

Implementation and Configuration

• Build integrations in Coupa using REST APIs, cXML (PO, invoice, ship notices), and files via SFTP when applicable.
• Develop and maintain pipelines in iPaaS/ESB (e.g., Boomi, MuleSoft, Azure Integration Services/Logic Apps) or equivalent stack (APIs/gateways, workers, queues/events).
• Implement quality controls: idempotence, deduplication, schema validations, data normalization, error handling, and compensations when necessary.

Specific Coupa ">" Datasul Integrations

• Master data: synchronize suppliers (incl. banking and tax data), GL/accounts, cost centers, projects, items, and users/approval structures.
• Transactional: integration of requisitions and POs, receipts/ASNs, invoices/credit notes, 2/3-way match, exception status/errors, payments, and returns (e.g., reconciliation and write-off in finance).
• Tax and fiscal: integrate with tax engines/systems and e-invoicing via middleware when applicable; map fiscal fields and retentions required by the business.

Testing, Quality, and Documentation

• Define and execute test plans: integration unit tests, contract tests (e.g., OpenAPI and cXML), end-to-end, and regression.
• Create test data, mocks/stubs, and automations (e.g., Postman/Newman, SoapUI) for critical scenarios.
• Document integrations, contracts, flows, and decisions (integration catalog, specifications, runbooks).

Security, Compliance, and Audit

• Implement authentication/authorization (OAuth 2.0/API Keys in Coupa, SSO/OIDC/SAML when necessary).
• Ensure compliance with LGPD and audit controls (trails, segregation of duties, retention, and masking of sensitive data).

Observability and Operation

• Instrument logs, metrics, and tracing.
• Maintain deploy/rollback routines, contract versioning, and release strategy in conjunction with product/infra teams.

#LI-DNI