Functional System Administrator – OneStream

Copeland LP; St. Louis (MO); Hybrid; USD 60,000 - 80,000; Full time

Job summary

Copeland LP in St. Louis is seeking an individual for a Financial Reporting Support role to assist users with their Financial Reporting, Consolidation, and Analytical System. Key responsibilities include troubleshooting user issues, supporting reporting processes, and understanding business processes related to financial consolidations.

The ideal candidate will have a Bachelor’s degree in Accounting or Finance and 2-3 years of relevant experience, along with knowledge of Onestream and essential computer skills. The position offers a hybrid work model.

Qualifications

• 2-3 years of relevant financial accounting experience.
• Moderate working knowledge of Onestream.
• Excellent computer skills with MS Excel, Word, Access, PowerPoint, Project, Visio and/or SQL.

Responsibilities

• Troubleshoot user issues and liaise with IT for technical support.
• Support the close and reporting processes and perform system maintenance.
• Understand existing business processes supported by consolidation reporting.

Skills

Financial accounting knowledge

Onestream

MS Excel

Problem-solving

Communication

Education

Bachelor’s degree in Accounting/Finance

Tools

Hyperion Financial Reporting

FDMEE

MS Word

SQL

Job description

Position Summary

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.

Essential Duties & 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.
• Identify 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.

Required Education & Experience

• Bachelor’s degree in Accounting/Finance required
• Prior financial accounting focus or similar experience
• Authorization to work in the United States Without Sponsorship
• 2-3 years of relevant financial accounting experience
• Moderate working knowledge of Onestream
• Excellent computer skills with a working knowledge of: MS Excel, Word, Access, PowerPoint, Project, Visio and/or SQL required
• #LI-Hybrid #LI-KC2

Preferred Education & Experience

• 2-3 years of relevant financial accounting experience
• Moderate working knowledge of Onestream
• Excellent computer skills with a working knowledge of: MS Excel, Word, Access, PowerPoint, Project, Visio and/or SQL required
• #LI-Hybrid #LI-KC2

Equal Opportunity Employer

Copeland is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, age, marital status, political affiliation, sexual orientation, gender identity, genetic information, disability or protected veteran status. We are committed to providing a workplace free of any discrimination or harassment. If you have a disability and are having difficulty accessing or using this website to apply for a position, please contact: [e-mail].

Work Authorization

Copeland will only employ those who are legally authorized to work in the United States. This is not a position for which sponsorship will be provided. Individuals with temporary visas such as E, F-1 with OPT or CPT, H-1, H-2, L-1, B, J or TN, or who need sponsorship for work authorization now or in the future, are not eligible for hire.