Functional System Administrator – OneStream

Copeland•St. Louis, MO

1d•Hybrid

About The Position

This position provides functional support for users of Copeland’s Financial Reporting, Consolidation and Analytical System (currently Hyperion), and will be supporting the implementation of a new Consolidation system - Onestream. The primary responsibility of the group is to support Copeland’s global consolidation and reporting process.

Requirements

Bachelor’s degree in accounting/finance or equivalent
3–5+ years of experience supporting enterprise financial system environments
Experience working in enterprise financial reporting and consolidation platforms such as OneStream (preferred), Hyperion HFM, FDMEE, or similar systems
Authorization to work in the United States Without Sponsorship

Nice To Haves

Moderate working knowledge of OneStream
Experience supporting metadata maintenance, business rules, security administration, and financial reporting within EPM platforms
Experience with SQL or data/query tools preferred
Experience supporting global or multi-entity financial consolidation environments preferred
Excellent computer skills with a working knowledge of: MS Excel, Word, Access, PowerPoint, Project, Visio and/or SQL required

Responsibilities

Troubleshoot and resolve functional user issues and work with the IT department to address issues that might require technical attention.
Support the close and reporting processes and perform monthly system maintenance cycles.
Understand existing business processes supported by consolidation reporting applications.
Understand financial consolidations accounting, including complex intercompany activity, eliminations, and foreign currency translation.
Serve as Gatekeeper for user service requests.
Assign helpdesk tickets to appropriate FSG team member according to area of expertise.
Identity and report critical system issues to IT technical team, communicate them to consolidation reporting user community.
Assist users in installing Smart View on user PCs, establishing connections to Hyperion and with maintaining and modifying FDMEE mapping tables and templates.
Manage FDMEE auto load conversion projects with FDMEE users.
Create or modify Financial Reports using Hyperion Financial Reporting Studio.
Maintain users in consolidation reporting systems, coordinate change management process for user security modifications, maintain and build security in accordance with required control protocols.
Assist Functional Administrator team with development, maintenance and testing of all technical aspects (Metadata, Calculations and Business Rules) in current and future consolidation reporting system including HFM, FDMEE, Financial Reporting and Smart View and future Consolidation system - OneStream.
Participate in integration and implementation of additional tools in the Copeland suite of Hyperion financial products as projects are identified.
Participate in the continuous improvement of all consolidation reporting systems, current and future.