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. Help us show the world what’s possible as you partner with clients to unlock hidden value and deliver innovative solutions.

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

• A 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.
• A minimum of 3 years experience performing data transformations: Data Source Complex Expressions, Transformation Rules, and Derivative & Conditional Business Rules.
• A minimum of 2 years experience documenting data & system architecture.
• A minimum of 1 year experience troubleshooting & remediating data integration performance issues, identifying failures, and implementing alerting & error-handling mechanisms.
• A minimum of 3 years experience reconciling & validating data integrations (target to source).
• A minimum of 2 years of experience collaborating with Solution Architects, functional leads, and client IT teams to translate business requirements into technical designs.
• A 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 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).

Skills

• Experience in one or more of the following industries: Industrial Manufacturing/Automotive, Energy, Consumer Goods, Retail, Public Sector, or Banking.
• Experience developing business rules, forms, workflows, cube views, dashboards, and quick views in OneStream.
• Experience designing OneStream Planning and Financial Close and Consolidation modules.
• Experience with Master Data Management (MDM) practices.
• Proficiency in C#, XML.
• Experience with advanced OneStream capabilities; Sensible AI, CPM Express etc.
• Completion of any advanced OneStream courses.
• Experience with OneStream modules (SML, People Planning, CAPEX, Thing Planning, etc.).
• Experience designing and/or developing solutions with similar planning and analytics technologies such as Oracle/Hyperion, Cognos TM1, SAP, Anaplan, Adaptive, Host Analytics, etc.
• Obtained OneStream XF Developer or Integration Certification.
• Proven success in contributing to a collaborative environment.
• Proven ability to work creatively and analytically in a problem-solving environment.
• Desire to learn modern technologies like AI/ML and how they augment EPM.
• Excellent leadership, communication (written and oral) and interpersonal skills.

Benefits

Compensation at Accenture varies depending on a wide array of factors, which may include but are not limited to the specific office location, role, skill set, and level of experience.

Pay

Annual Salary Range: $73,800 to $218,800

Schedule

May require travel up to 100% depending on business need and client requirements.