Functional System Administrator – OneStream

Copeland; St. Louis (MO); On-site; USD 60,000 - 85,000; Full time

Job summary

Copeland in St. Louis, Missouri, seeks a professional to provide functional support for financial reporting, consolidation, and analytical systems. The role involves troubleshooting, performing monthly maintenance, and handling user service requests.

Candidates must have a Bachelor's degree in accounting/finance and 3–5+ years of relevant experience. Expertise in platforms like OneStream and Hyperion is preferred. Copeland values diversity and is an Equal Opportunity Employer.

Qualifications

• 3–5+ years of experience supporting enterprise financial system environments.
• Experience working in enterprise financial reporting and consolidation platforms.
• Moderate working knowledge of OneStream is preferred.

Responsibilities

• Troubleshoot and resolve functional user issues.
• Perform monthly system maintenance cycles.
• Assist with the development and maintenance of analytical systems.

Skills

Enterprise financial system support

Financial reporting and consolidation

SQL or data/query tools

Excellent MS Office skills

Education

Bachelor’s degree in accounting/finance or equivalent

Tools

OneStream

Hyperion HFM

FDMEE

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; coordinate with the IT department for technical issues.
• 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 help‑desk tickets to appropriate FSG team members, identify and report critical system issues to the IT technical team, and communicate them to the consolidation reporting user community.
• Assist users in installing Smart View on PCs, establishing connections to Hyperion, and 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 the Functional Administrator team with development, maintenance, and testing of all technical aspects (metadata, calculations, and business rules) in current and future consolidation reporting systems including HFM, FDMEE, Financial Reporting and Smart View and the future Consolidation system—OneStream.
• Participate in the integration and implementation of additional tools in the Copeland suite of Hyperion financial products as projects are identified; contribute to the continuous improvement of all consolidation reporting systems, current and future.

Required Education & Experience

• 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.

Preferred Education & Experience

• 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.
• Experience supporting global or multi‑entity financial consolidation environments.
• Excellent computer skills with a working knowledge of MS Excel, Word, Access, PowerPoint, Project, Visio, and/or SQL.

Work Authorization

Copeland will only employ those who are legally authorized to work in the United States. This position does not provide sponsorship for work authorization.

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 discrimination or harassment.