OneStream Administrator

Job Purpose

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

• Performing One Stream 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 One Stream including supporting end-user Quick View reports and development of various reports (One Stream 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
• Identifying and troubleshooting any issues that may arise with the platform; 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 One Stream platform
• Evaluating and executing platform upgrades

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

N/A

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

• Experience working in One Stream, 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