OneStream Administrator

CBTS serves enterprise and midmarket clients in all industries across the United States and Canada. CBTS combines deep technical expertise with a full suite of flexible technology solutions--including Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, CBTS delivers comprehensive technology solutions for its clients' transformative business initiatives. For more information, please visit www.cbts.com.

OnX is a leading technology solution provider that serves businesses, healthcare organizations, and government agencies across Canada. OnX combines deep technical expertise with a full suite of flexible technology solutions—including Generative AI, Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, OnX delivers comprehensive technology solutions for its clients’ transformative business initiatives. For more information, please visit www.onx.com.

Job Purpose:

The OneStream Administrator will report to the Finance Manager and is responsible for the joint administration of the OneStream CPM application.

Essential Functions:

Performing OneStream application build tasks and activities (Dashboards, Transformation Rules, Workflows, Business Rule changes, Data Adapter changes, etc.) Maintaining and enhancing application business rules, member formulas, workflows, and data integrations Following security administration to secure metadata, user access, controls of organization and entity structures, chart of accounts, mapping translations, reports and book sets, and reporting categories for the actual budget, and forecast Evaluating and building logical views, data hierarchies, and reporting structures Supporting ad-hoc business requests for data extraction as needed (audits IT, Tax, Financial) and other finance technology tools impacting OneStream including supporting end-user Quick View reports and development of various reports (OneStream Cube Views and Excel Add-in) and dashboards Creating test plans, process documentation, and training materials, and performing functional testing Supporting period close processing and data integrations, resolving mapping errors with reconciliation of data between systems Identify and troubleshooting any issues that may arise with the platform. This may involve working closely with other members of the team, as well as external vendors, to resolve technical problems and ensure the smooth operation of the platform Responsible for training and providing ongoing support to end-users of the OneStream platform Evaluating and executing platform upgrades.

Education:

Four years of College resulting in a Bachelor's Degree or equivalent

Certifications, Accreditations, Licenses:

N/A

Experience:

8+ years of proven experience in financial systems administration/implementation

Special Knowledge, Skills, and Abilities:

Experience working in OneStream, Hyperion, and/or Hyperion Financial Management (HFM) Proven experience in reporting implementation for multinational business Proven experience of system self-learning VBA, .Net or SQL coding an asset Bachelor's degree in Finance, Accounting, Computer Science or a related field Knowledge of US GAAP Strong Written and Verbal communication skills along with being able to communicate effectively with technical and non technical team members.