Accenture

OneStream Integration Lead

Accenture$73K — $189K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 2+ years experience in end-to-end data integration between OneStream and external systems like SAP or Oracle leveraging REST APIs.
  • 3+ years of experience in data transformations including complex expressions and business rules.
  • 2+ years in documenting data and system architecture effectively.
  • 1+ year experience in troubleshooting data integration performance issues.
  • 3+ years in reconciling and validating data integrations from target to source.
  • 2+ years collaborating with Solution Architects and clients on technical designs.
  • Bachelor's degree or equivalent work experience (12+ years).

Responsibilities

  • Design and implement data integration solutions with OneStream XF and financial systems like SAP, Oracle, and Workday.
  • Develop and configure OneStream Data Management workflows and transformation sequences.
  • Build automation for data loading and extraction using transformation rules and profiles.
  • Collaborate with ERP teams to understand data models and ensure effective data flow.
  • Monitor integration performance, troubleshoot failures, and establish error-handling protocols.
  • Document architecture, data flows, and support operational stability post-production.
  • Mentor junior developers and ensure adherence to coding standards.

Benefits

  • Comprehensive medical, dental, and vision coverage.
  • 401(k) plan with employer match opportunities.
  • Paid holidays and time off for work-life balance.
  • Bonus opportunities upon performance.
  • Access to ongoing professional development and training 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 $73,800 to $218,800
Cleveland $68,300 to $175,000
Colorado $73,800 to $189,000
District of Columbia $78,500 to $201,300
Illinois $68,300 to $189,000
Maine $62,800 to $161,000
Maryland $73,800 to $189,000
Massachusetts $73,800 to $201,300
Minnesota $73,800 to $189,000
New York $68,300 to $218,800
New Jersey $78,500 to $218,800
Virginia $68,300 to $201,300
Washington $80,200 to $201,300

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 Information Technology Jobs

Find similar OneStream Integration Lead jobs: