Accenture

OneStream Integration Lead

Accenture$87K — $245K *
Technical Services
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 2+ years experience with end-to-end data integration using OneStream and various ERP systems (e.g., SAP, Oracle) via REST API or SIC.
  • 3+ years experience in data transformations: complex expressions and business rules.
  • 2+ years experience in documenting data and system architecture.
  • 1+ year of resolving data integration performance issues and implementing alerting mechanisms.
  • 3+ years in data reconciliations and validations across integrations.
  • 2+ years of collaboration with Solution Architects and IT teams for technical designs.
  • Bachelor's degree or equivalent work experience (12 years).

Responsibilities

  • Design and create data integration solutions connecting OneStream XF with financial systems.
  • Develop and manage OneStream Data Management workflows including import and transformation sequences.
  • Create Transformations Rules and Data Blending profiles for automatic data processes.
  • Build custom integrations using multiple methods including REST APIs and file exchanges.
  • Map and transform data structures to fit OneStream dimensions.
  • Implement automation schedules for data loads via OneStream and third-party tools.
  • Monitor integration performance, troubleshoot failures, and document operational processes.

Benefits

  • Medical, dental, vision, life, and long-term disability coverage.
  • 401(k) plan with employer contributions.
  • Bonus opportunities and paid time off.
  • Flexible work arrangements and paid holidays.
  • Access to various professional development resources.
Full Job Description

You Are: 

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.

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)

 

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, People Planning, CAPEX, Thing Planning, etc.)

  • You have experience designing and/or developing solutions with similar planning and analytics technologies such as Oracle/Hyperion, Cognos TM1, SAP, Anaplan, Adaptive, Host Analytics, etc.

  • You have obtained OneStream XF Developer or Integration Certification

  • You have proven success in contributing to a collaborative environment

  • You have proven ability to work creatively and analytically in a problem-solving environment

  • You have a desire to learn modern technologies like AI/ML and how they augment EPM

  • You have excellent leadership, communication (written and oral) and interpersonal skills


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. As required by local law, Accenture provides a reasonable range of compensation for roles that may be hired as set forth below.


We anticipate this job posting will be posted until 08/1/2026.

Accenture offers a market competitive suite of benefits including medical, dental, vision, life, and long-term disability coverage, a 401(k) plan, bonus opportunities, paid holidays, and paid time off.

See more information on our benefits here: U.S. Employee Benefits | Accenture


Role Location Annual Salary Range

California                                           $94,400 to $266,300

Cleveland                                            $87,400 to $213,000

Colorado                                            $94,400 to $230,000

District of Columbia                         $100,500 to $245,000

Illinois                                                 $87,400 to $230,000

Maine                                                $80,400 to $196,000

Maryland                                           $94,400 to $230,000

Massachusetts                                  $94,400 to $245,000

Minnesota                                         $94,400 to $230,000

New York                                           $87,400 to $266,300

New Jersey                                        $100,500 to $266,300

Virginia                                              $87,400 to $245,000

Washington                                      $100,500 to $245,000

About Accenture

Accenture plc is a multinational professional services company that provides services in strategy, consulting, digital, technology, and operations. The company has more than 537,000 employees serving clients in more than 120 countries. Accenture operates across five business segments: Communications, Media & Technology; Financial Services; Health & Public Service; Products; and Resources. The company is headquartered in Dublin, Ireland, and has offices worldwide.
Learn more about Accenture
Size
624,000 employees
Market Cap
$173.8 billion
Industry
Net Income
$5.2 billion
Founded
1989
5 Year Trend
+11.2%
Revenue
$44.7 billion
NASDAQ

Similar Jobs

More Jobs at Accenture

More Technical Services Jobs

Find similar OneStream Integration Lead jobs: