OneStream Developer - Integration

Our client, is seeking an experienced, detail-oriented OneStream Developer — Integration to join their specialized Enterprise Performance Management (EPM) technology team.

In this key technical role, you will be directly responsible for designing, building, and deploying seamless, high-performance data integrations between the OneStream platform and SAP DataSphere. Serving as an integration subject matter expert, you will bridge multi-dimensional EPM architectures with modern cloud data warehouse environments. You will also take full ownership of unit testing, integration testing, data validation, and end-to-end pipeline verification to ensure continuous financial data integrity across platforms.

Duration: 6-Month Contract (with potential for extension)

Work Arrangement: 100% Remote (Candidates must be residing and legally eligible to work within Canada)



Advantages
100% Canadian Remote Flexibility: Work comfortably from home anywhere within Canada.

Cutting-Edge Integration Sandbox: Gain high-value experience connecting leading-edge EPM solutions (OneStream) with modern cloud data ecosystem platforms (SAP DataSphere).

Focused Technical Impact: Take direct ownership of critical data flow pipelines that power core executive reporting and financial decision-making.

Collaborative Enterprise Environment: Partner alongside top-tier systems architects, data engineers, and finance leads in a structured, supportive setting.



Responsibilities
Integration Architecture & Engineering: Design, build, and maintain robust data integration workflows connecting OneStream and SAP DataSphere.

Data Mapping & Extraction: Develop efficient data pipelines, mapping transformations, and data extraction rules to ensure seamless data flows between source and target systems.

Testing & Quality Assurance: Lead comprehensive unit testing and system integration testing (SIT) to validate data accuracy, pipeline performance, and error-handling capabilities.

Reconciliation & Validation: Perform rigorous end-to-end data reconciliation between OneStream cubes/relational tables and SAP DataSphere to safeguard financial data integrity.

Technical Documentation: Author detailed integration blueprints, technical mapping specifications, data flow diagrams, and testing validation runbooks.

Cross-Functional Collaboration: Partner closely with data architects, SAP leads, and business analysts to translate complex data requirements into scalable integration solutions.



Qualifications
OneStream Technical Expertise: Proven, hands-on experience as a Developer or Integration Specialist on the OneStream EPM platform.

SAP DataSphere Proficiency: Demonstrated experience working with SAP DataSphere for data modeling, integration, and cloud data architecture.

Integration Engineering: Strong technical track record of designing, building, and optimizing automated enterprise data pipelines and ETL/ELT connectors between EPM and ERP/Data Warehouse environments.

Testing & Data Reconciliation: Solid hands-on experience managing unit testing and integration testing cycles with strict data reconciliation processes.

Location Requirement: Must be legally eligible to work and currently residing within Canada.

Soft Skills: Exceptional technical problem-solving abilities, meticulous attention to data detail, and strong written and verbal communication skills.

Summary



Summary
If you are a tech-savvy OneStream Developer who pairs deep integration expertise in connecting OneStream with SAP DataSphere with the data validation and testing discipline required to ensure flawless enterprise data pipelines, this 100% Canadian remote contract is an outstanding opportunity. Bring your pipeline engineering precision and collaborative focus to our client's growing EPM team today!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.