OneStream Developer - Business Rules and Calculation Engine

Our client, is seeking an experienced and technical OneStream Developer — Business Rules and Calculation Engine to join their financial systems and enterprise performance management (EPM) team.

In this specialized contract role, you will play a pivotal role in designing, building, and maintaining core platform metadata and complex finance business rules within the OneStream ecosystem. You will serve as the technical subject matter expert responsible for optimizing the calculation engine, developing script-based financial logic, and ensuring seamless data processing across the application landscape. This position requires a developer who combines a deep understanding of financial consolidation workflows with expert-level command of .NET scripting and OneStream API execution.

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

Work Arrangement: 100% Remote (Candidates must be located within Canada)



Advantages
Full Remote Flexibility: Enjoy 100% remote working autonomy from anywhere across Canada.

Core EPM Ownership: Take direct ownership of mission-critical finance business rules and calculation engines that power core corporate reporting.

Complex Scripting Sandbox: Deepen your expertise in advanced OneStream API engineering, member filter design, and relational database integrations.

Collaborative Environment: Work alongside top-tier finance, analytics, and systems architecture professionals in an agile enterprise setting.



Responsibilities
Business Rule Engineering: Architect, write, and maintain custom OneStream finance business rules, consolidation logic, and dynamic calculation scripts using VB.NET or C#.

Calculation Engine Optimization: Utilize XF expression functions (e.g., FilterMembers, GetDataCell, SetDataBuffer, Calculate) to execute complex data transformations and optimize calculation runtimes.

Metadata & Dimension Design: Construct precise dimension member filters leveraging metadata properties, ensuring proper data alignment and cube behavior.

Relational Data Integration: Write SQL queries inside rule logic to read driver tables and operational metadata directly from OneStream Relational Tables (XF Relational Tables).

API Development & Maintenance: Leverage OneStream's api.Data methods and the BRApi namespace to extend platform capabilities, automate operational tasks, and build custom utility tools.

Platform Performance & Security: Govern execution order, locking models, and data security pass-throughs to ensure optimal system performance and auditability during financial close cycles.



Qualifications
OneStream Development Mastery: Demonstrated hands-on experience designing, developing, and supporting OneStream EPM applications, with a heavy emphasis on business rules and calculation engine logic.

Scripting Languages: Expert-level proficiency writing and debugging custom logic in VB.NET or C# within the OneStream environment.

Core Function Expertise: Deep practical knowledge of XF functions (FilterMembers, GetDataCell, SetDataBuffer, Calculate) and dimension member filter construction using metadata attributes.

API & Namespace Proficiency: Strong, referenceable experience utilizing api.Data methods and the BRApi namespace.

SQL & Relational Databases: Functional ability to write and embed SQL queries to interact with driver tables in relational databases (XF Relational Tables).

Financial Model Acuity: Strong understanding of OneStream's execution order, locking model, financial consolidation principles, and multi-dimensional cube architecture.

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



Summary
If you are a tech-savvy OneStream Developer who pairs an absolute command of VB.NET/C# scripting and XF expression functions with the deep architectural understanding required to optimize OneStream calculation engines and metadata structures, this 100% Canadian remote contract is an outstanding opportunity. Bring your EPM scripting precision, SQL integration skills, and collaborative delivery style to our client's growing finance technology 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.