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.

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 :

5+ 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.

Supervisory Responsibility :

This position does not have any supervisory responsibilities.

Skills Required

Us Gaap, .NET, Hyperion, Vba