About this role
About the Role Join Accenture as a OneStream Integration Lead where you design and deliver end-to-end data integration solutions between OneStream XF and ERP/finance systems. You will mentor junior developers, collaborate with solution architects and business stakeholders, and support pre-sales and post-implementation activities to drive reliable, high-performance integrations across the financial landscape. What You'll Do
- 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. What We're Looking For
- Minimum of 2 years experience designing & building end-to-end data integration solutions between OneStream and external data source systems (SAP, Oracle, Workday, Snowflake, etc.) leveraging Rest API and/or SIC
- Minimum of 3 years experience performing data transformations: Data Source Complex Expressions, Transformation Rules, and Derivative & Conditional Business Rules
- Minimum of 2 years experience documenting data & system architecture
- Minimum of 1 year experience troubleshooting & remediating data integration performance issues, identifying failures, and implementing alerting & error-handling mechanisms
- Minimum of 3 years experience reconciling & validating data integrations (target to source)
- Minimum of 2 years of experience collaborating with Solution Architects, functional leads, and client IT teams to translate business requirements into technical designs
- Bachelor's degree or equivalent (minimum 12 years work experience). If Associate’s Degree, must have equivalent (minimum 6 years work experience)
Bonus points if:
- You have experience in one or more of the following industries: Industrial Manufacturing/Automotive, Energy, Consumer Goods, Retail, Public Sector, or Banking.
- You experience developing business rules, forms, workflows, cube views, dashboards, and quick views in OneStream.
- You have experience designing OneStream Planning and Financial Close and Consolidation modules.
- You have experience with Master Data Management (MDM) practices
- You are proficient in C#, XML
- You have experience with advanced OneStream capabilities; Sensible AI, CPM Express etc.
- You have completed any advanced OneStream courses
- You have experience with OneStream modules (SML)