OneStream Integration Lead

About the role

We are a global collective of innovators applying the New every day to improve the way the world works and lives. This role involves designing and implementing reliable, accurate, and high-performance data integration solutions connecting OneStream XF with enterprise ERP, GL, and financial systems.

Responsibilities

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

Requirements

• 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)

Qualifications

• Minimum of 5 years of experience in EPM functional knowledge and deep technical integration expertise
• Minimum of 2 years experience with OneStream Integration Certification
• Minimum of 2 years experience with OneStream Planning and Financial Close and Consolidation modules
• Minimum of 2 years experience with Master Data Management (MDM) practices
• Minimum of 2 years experience with C# and XML
• Minimum of 2 years experience with advanced OneStream capabilities; Sensible AI, CPM Express etc.
• Minimum of 2 years experience with OneStream modules (SML, People Planning, CAPEX, Thing Planning, etc.)
• Minimum of 2 years experience with similar planning and analytics technologies such as Oracle/Hyperion, Cognos TM1, SAP, Anaplan, Adaptive, Host Analytics, etc.
• Minimum of 2 years experience with OneStream Marketplace solutions and partner extensions
• Minimum of 2 years experience with OneStream Workflow Scheduler and third-party tools
• Minimum of 2 years experience with OneStream Data Management workflows including Import, Export, Transform, and Consolidation sequences
• Minimum of 2 years experience with OneStream Data Blending profiles and Quick Views
• Minimum of 2 years experience with OneStream Transformation Rules
• Minimum of 2 years experience with OneStream Custom Integrations using REST APIs, web services, and file-based exchange (CSV, XML, JSON, flat files)
• Minimum of 2 years experience with OneStream Data Mapping and Transformation Logic
• Minimum of 2 years experience with OneStream Scheduled Automation of Data Loads
• Minimum of 2 years experience with OneStream Monitoring Integration Job Performance, Identifying Failures, and Implementing Alerting and Error-Handling Mechanisms
• Minimum of 2 years experience with OneStream Integration Testing, Data Reconciliation, and Validation Across Financial Periods
• Minimum of 2 years experience with OneStream Documentation of Integration Architecture, Data Flows, Mapping Specifications, and Operational Runbooks
• Minimum of 2 years experience with OneStream Hypercare and Post-Production Integration Stability, Resolving Issues During Close Cycles
• Minimum of 2 years experience with OneStream Use of Considerable Judgment to Determine Integration Solutions and Seek Guidance on Complex Problems
• Minimum of 2 years experience with OneStream Adapt Existing Methods and Procedures to Address Moderately Complex Integration Challenges
• Minimum of 2 years experience with OneStream Collaboration with Solution Architects and Functional Leads to Translate Business Requirements into Robust Technical Designs
• Minimum of 2 years experience with OneStream Support Pre-Sales Activities Including Solution Demos, Effort Estimation, and Proposal Development
• Minimum of 2 years experience with OneStream Support Technical Aspects of System Integration Testing (SIT), UAT, and Go-Live Support
• Minimum of 2 years experience with OneStream Development and Maintenance of Technical Standards, Coding Guidelines, and Solution Documentation
• Minimum of 2 years experience with OneStream Evaluation and Implementation of OneStream Marketplace Solutions and Partner Extensions
• Minimum of 2 years experience with OneStream Use of Considerable Judgment to Determine Solutions and Seek Guidance on Complex Technical Problems
• Minimum of 2 years experience with OneStream Adapt Existing Methods and Procedures to Create Alternative Solutions to Complex Technical Challenges
• Minimum of 2 years experience with OneStream Mentor and Provide Technical Guidance to Junior Developers; Conduct Code Reviews and Enforce Best Practices
• Minimum of 2 years experience with OneStream Demonstrate Executive Presence During Frequent Upward Interaction with Direct Supervisor

Skills

• Experience with OneStream Integration Certification
• Experience with OneStream Planning and Financial Close and Consolidation modules
• Experience with Master Data Management (MDM) practices
• Experience with C# and XML
• Experience with advanced OneStream capabilities; Sensible AI, CPM Express etc.
• Experience with OneStream modules (SML, People Planning, CAPEX, Thing Planning, etc.)
• Experience with similar planning and analytics technologies such as Oracle/Hyperion, Cognos TM1, SAP, Anaplan, Adaptive, Host Analytics, etc.
• Experience with OneStream Marketplace solutions and partner extensions
• Experience with OneStream Workflow Scheduler and third-party tools
• Experience with OneStream Data Management workflows including Import, Export, Transform, and Consolidation sequences
• Experience with OneStream Data Blending profiles and Quick Views
• Experience with OneStream Transformation Rules
• Experience with OneStream Custom Integrations using REST APIs, web services, and file-based exchange (CSV, XML, JSON, flat files)
• Experience with OneStream Data Mapping and Transformation Logic
• Experience with OneStream Scheduled Automation of Data Loads
• Experience with OneStream Monitoring Integration Job Performance, Identifying Failures, and Implementing Alerting and Error-Handling Mechanisms
• Experience with OneStream Integration Testing, Data Reconciliation, and Validation Across Financial Periods
• Experience with OneStream Documentation of Integration Architecture, Data Flows, Mapping Specifications, and Operational Runbooks
• Experience with OneStream Hypercare and Post-Production Integration Stability, Resolving Issues During Close Cycles
• Experience with OneStream Use of Considerable Judgment to Determine Integration Solutions and Seek Guidance on Complex Problems
• Experience with OneStream Adapt Existing Methods and Procedures to Address Moderately Complex Integration Challenges
• Experience with OneStream Collaboration with Solution Architects and Functional Leads to Translate Business Requirements into Robust Technical Designs
• Experience with OneStream Support Pre-Sales Activities Including Solution Demos, Effort Estimation, and Proposal Development
• Experience with OneStream Support Technical Aspects of System Integration Testing (SIT), UAT, and Go-Live Support
• Experience with OneStream Development and Maintenance of Technical Standards, Coding Guidelines, and Solution Documentation
• Experience with OneStream Evaluation and Implementation of OneStream Marketplace Solutions and Partner Extensions
• Experience with OneStream Use of Considerable Judgment to Determine Solutions and Seek Guidance on Complex Technical Problems
• Experience with OneStream Adapt Existing Methods and Procedures to Create Alternative Solutions to Complex Technical Challenges
• Experience with OneStream Mentor and Provide Technical Guidance to Junior Developers; Conduct Code Reviews and Enforce Best Practices
• Experience with OneStream Demonstrate Executive Presence During Frequent Upward Interaction with Direct Supervisor

Benefits

Here’s what you need:

• 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)

Pay

Annual Salary Range: - California: $73,800 to $218,800 - Cleveland: $68,300 to $175,000 - Colorado: $73,800 to $189,000 - District of Columbia: $78,500 to $