Integration Senior Associate - OneStream Integrations

What You Will Do

We are seeking a highly skilled Senior Associate – OneStream Integrations to join our Data Solutions team. This role is ideal for a hands-on integration consultant who is passionate about designing and delivering enterprise integration solutions centered around OneStream and its integration with ERP, EPM, CRM, HR, data warehouse, and other enterprise systems.

The ideal candidate will possess strong expertise in enterprise integration architecture, financial systems, and data movement methodologies. Experience with Oracle EPM/Hyperion is highly valued, while experience with modern integration platforms is beneficial but not mandatory.

Enterprise Integration Architecture

• Lead the design and implementation of enterprise integration solutions centered around OneStream.
• Architect scalable, secure, and maintainable integrations between OneStream and enterprise applications including Oracle ERP, Oracle EPM, SAP, Workday, Salesforce, NetSuite, data warehouses, and custom applications.
• Define enterprise integration strategies that align with business and financial transformation initiatives.

OneStream Integration Design

• Design and implement integrations supporting Financial Consolidation, Planning, Budgeting, Forecasting, and Reporting.
• Develop integration solutions using OneStream integration capabilities including Data Management, Business Rules, Extenders, APIs, and file/database-based integrations.
• Design reusable integration frameworks that improve scalability and maintainability.

Enterprise Integration Methodology

• Apply industry best practices for enterprise integration including:
  • Real-time, batch, and event-driven integration patterns
  • API-based integrations
  • Data synchronization and orchestration
  • Error handling and reconciliation
  • Monitoring and operational support
• Recommend the most appropriate integration approach based on business and technical requirements.

Financial Systems Integration

Design integrations between OneStream and:

• Oracle ERP (Cloud/EBS)
• Oracle EPM / Hyperion (preferred)
• SAP
• NetSuite
• Workday
• Salesforce
• SQL Server, Oracle, Snowflake, Azure Data Lake, and other data platforms
• Banking, payroll, and operational systems

Data Architecture & Governance

• Design data mapping and transformation strategies.
• Support master data integration across enterprise platforms.
• Ensure data quality, governance, auditability, and compliance with financial controls.
• Establish monitoring, logging, and reconciliation processes.

Solution Design & Technical Leadership

• Lead integration solution design workshops with business and technical stakeholders.
• Provide technical leadership throughout project delivery.
• Mentor consultants and developers on integration design patterns and OneStream best practices.
• Review solution designs and ensure alignment with enterprise architecture standards.

Pre-Sales & Solutioning

• Participate in client discovery sessions.
• Define integration strategies and implementation roadmaps.
• Support effort estimation, solution architecture, and proposal development.
• Present technical solutions to clients and internal stakeholders.

Problem Solving

• Analyze complex integration challenges across financial and operational systems.
• Recommend scalable, maintainable, and business-aligned integration solutions.
• Drive continuous improvement of enterprise integration practices.

You Have

• 7+ years of consulting or industry experience delivering enterprise integration solutions. 
• 1+ years of experience designing and implementing integrations involving OneStream. 
• Strong understanding of enterprise integration architecture and integration methodologies.
• Experience integrating OneStream with ERP, EPM, CRM, HR, and data warehouse platforms.
• Experience working with Oracle ERP, SAP, NetSuite, Workday, Salesforce, or similar enterprise applications.
• Strong understanding of financial processes including Record-to-Report, Planning, Budgeting, Consolidation, and Forecasting.
• Experience with APIs, web services (REST/SOAP), databases, file-based integrations, and enterprise integration patterns.
• Strong understanding of data mapping, transformation, reconciliation, and governance.
• Ability to lead technical design sessions and mentor implementation teams.
• Excellent communication and client-facing consulting skills.

Preferred Qualifications

• Experience with Oracle EPM / Hyperion implementations or integrations.
• Experience integrating Oracle EPM and OneStream during finance transformation initiatives.
• Experience with OneStream APIs, Data Management, Business Rules, Extenders, and Integration Services.
• Experience with Oracle ERP Cloud, SAP S/4HANA, or other enterprise ERP platforms.
• Familiarity with integration platforms such as MuleSoft, Boomi, Workato, Azure Integration Services, or Oracle Integration Cloud.
• Exposure to cloud data platforms including Snowflake, Azure Data Lake, Microsoft Fabric, or similar.
• Understanding of enterprise integration architecture, API management, and modern integration best practices.
• OneStream implementation or platform certifications are a plus.

What else to expect

Employees will also gain exposure to an early-stage growth company providing innovative opportunities to impact our clients in a meaningful way.  We believe giving back is core to our values so as an employee you will be given the opportunity to participate in SR’s day of service, giving back to the global community.

We take care of you! 

Here are some of our great benefits and perks to highlight:

• Full benefit offerings including health, wellness, retirement and lifestyle offerings
• Paid maternity and paternity leave
• Paid holiday time
• Flexible Time Off – Take the time you need when you need to take it