OneStream Integration Lead Organization

A skilled OneStream Integration Consultant with a blend of EPM functional knowledge and deep technical integration expertise.

You design and implement reliable, accurate, and high-performance data integration solutions connecting OneStream XF with enterprise ERP, GL, and financial systems. You ensure data flows accurately across the financial technology landscape while collaborating effectively with finance, IT, and source system teams.

You mentor junior developers, drive platform best practices, and work closely with solution architects, functional leads and business stakeholders to deliver high-quality EPM solutions across the full implementation lifecycle.

The Work:

• Design and build end-to-end data integration solutions between OneStream XF and upstream/downstream financial systems (SAP, Oracle, Workday, Dynamics, etc.).
• Develop and configure OneStream Data Management workflows including Import, Export, Transform, and Consolidation sequences.
• Build Transformation Rules, Data Blending profiles, and Quick Views for automated data loading and extraction.
• Develop custom integrations using REST APIs, web services, and file-based exchange (CSV, XML, JSON, flat files).
• Design data mapping and transformation logic to align source system data structures with OneStream cube dimensions.
• Implement and maintain scheduled automation of data loads using OneStream Workflow Scheduler and third-party tools.
• Collaborate with ERP and source system teams to understand data models, extract mechanisms, and change management impacts.
• Monitor integration job performance, identify failures, and implement alerting and error-handling mechanisms.
• Perform integration testing, data reconciliation, and validation across financial periods.
• Document integration architecture, data flows, mapping specifications, and operational runbooks.
• Support hypercare and post-production integration stability, resolving issues during close cycles.
• Use considerable judgment to determine integration solutions and seek guidance on complex problems.
• Adapt existing methods and procedures to address moderately complex integration challenges.
• Collaborate with Solution Architects and functional leads to translate business requirements into robust technical designs.
• Support pre-sales activities including solution demos, effort estimation, and proposal development.
• Support technical aspects of system integration testing (SIT), UAT, and go-live support.
• Develop and maintain technical standards, coding guidelines, and solution documentation.
• Evaluate and implement OneStream Marketplace solutions and partner extensions.
• Use considerable judgment to determine solutions and seek guidance on complex technical problems.
• Adapt existing methods and procedures to create alternative solutions to complex technical challenges.
• Mentor and provide technical guidance to junior developers; conduct code reviews and enforce best practices.
• Demonstrate executive presence during frequent upward interaction with direct supervisor. May interact with peers and/or management levels at a client and/or within Accenture.

Travel may be required for this role. The amount of travel will vary from 0 to 100% depending on business need and client requirements.

Acceptance Testing, Application Programming Interface (API), Automation, Best Practices, Business Architecture, Change Management, Code Reviews, Consulting, Data Management, Data Mapping, Data Modeling, Data Quality, Data Structures, Documentation, ERP (Enterprise Resource Planning), Error Handling, Finance, Financial Systems, Import/Export, Information Technology & Information Systems, Integration Testing, JSON, Mentoring, Oracle, Performance Analysis, Pre-Sales, Problem Solving Skills, Product Demonstration, Proposal Development, REST (Representational State Transfer), Reconciliation, Requirements Management, SAP, Sales Support, Schedule Development, Solution Sales, System Integration (SI), System Test, Technical Leadership, Technical Support, Technical/Engineering Design, Test Data, Testing, Web Services, XML (EXtensible Markup Language)