EPM Administrator

Job Description

Job Overview / Purpose

The EPM Administrator will play a key role in supporting our organization's transition from Oracle Hyperion to OneStream. This position is responsible for supporting the migration efforts, ensuring a smooth and successful transition, while continuing to support our existing Hyperion environments (including our Planning and Consolidation applications) during the migration process. The ideal candidate will ensure seamless operations across both systems during the migration and provide expertise on OneStream post-implementation.

Key Accountabilities

Migration and System Transition Support:

• Support the full migration from Oracle Hyperion to OneStream, ensuring minimal disruption to business operations.
• Collaborate with the project team to plan, test, and execute migration activities, including data flows, system configuration, and user transitions.
• Continue to provide operational support for legacy Hyperion environments during the migration phase.
• Develop and execute migration plans, including data validation and system cutovers, to ensure accuracy and system reliability.
• Assist in troubleshooting and resolving issues that arise during the migration from Hyperion to OneStream.

Post-Migration OneStream Support:

• Serve as the primary OneStream administrator post-migration, managing and supporting the OneStream environment for consolidation, reporting, and planning functions.
• Configure and maintain OneStream security and user roles.
• Perform data load, validation, and troubleshooting activities in the OneStream environment.
• Automate and monitor backup processes for OneStream.
• Ensure Testing and QA activities are completed in accordance with EPM system releases; planning and monitoring results of test cycles, to support system testing, user acceptance testing, and system go lives

Operational and Administrative Systems:

• Support Hyperion environments (e.g., HFM/Planning/Essbase) until the migration is complete.
• Assist various levels of the Finance group with both Hyperion and OneStream tasks during the transition.
• Provide ongoing technical support and resolve issues related to both Hyperion and OneStream systems during the migration phase.
• Ensure business delivery and operational effectiveness across both environments.
• Develop and maintain documentation for both Hyperion and OneStream, ensuring clarity for future reference.

Applications Architecture and Systems Integration Support:

• Manage architecture for both Hyperion and OneStream environments during the transition.
• Tune application and server settings for performance optimization in OneStream post-migration.
• Manage system integrations and automation for OneStream, ensuring seamless data flow and system performance.
• Review system logs, troubleshoot issues, and ensure archiving methodologies are in place for OneStream.
• Manage SQL DB tuning for Hyperion during the migration process.

Qualifications

Education:

• Post-secondary Diploma or University Degree in Computer Science, Finance, or a related discipline.
• OneStream certification and annual re-certification is a requirement.
• Accounting and/or Hyperion certification is a definite asset.

Experience:

• 3-5 years of professional experience (technical and financial experience preferred).
• Proven experience managing both Oracle Hyperion and OneStream systems in an administrator or developer role.
• Experience with OneStream implementation and migration projects is highly desirable.
• Experience in at least 2-3 Hyperion Planning implementations and OneStream implementations as an administrator or technical lead.
• Serve as a liaison between IT and business stakeholders, troubleshooting issues and supporting users across both systems during the migration.

Skills & Abilities:

• Deep understanding of interfaces between source systems (ERP, External legacy, etc.) and OneStream and Hyperion environments.
• Ability to utilize monitoring tools to evaluate general health of applications during the migration and for OneStream post-implementation.
• Effectively translate expertise in Hyperion to OneStream functionality such as consolidation, reporting, data integration, and security management.
• Knowledge of scripting languages (i.e. VB.Net, Python, Jython) and OneStream automation tools (e.g. Workflow).
• Strong project management skills to ensure smooth migration and minimize operational disruptions.
• Excellent communication skills with the ability to train and support end-users on the use of OneStream.
• Ability to manage multiple tasks across different systems during the migration and post-implementation phases. Process improvement and/or automation experience in the planning area is an asset
• Good verbal and written communicator
• Ability to communicate effectively with the end-users
• Excellent interpersonal communications and the ability to present ideas in a user-friendly format
• Ability to work with tight deadlines

Working Conditions

• Availability to work non-standard hours and be flexible concerning workdays.
• Irregular work hours required during peak deliverable periods such as Seasonal, Month-end and Budget cycles.
• Off-hour support requirements, based on on-going operational and project demands
• Work is generally performed in an office environment

About Us

At Chartwell, we're all about Making People's Lives BETTER: the lives of our residents and their families, and the lives of our employees. Join an exceptional group of diverse, inspiring, and caring people who are empowered to provide personalized, human experiences for our residents and staff through the connections they make every day within our communities.

Chartwell's commitment to diversity and inclusivity is a commitment to hiring people whose skills and abilities contribute the most to the success of the organization and who reflect the communities in which we live and work. We are an equal opportunity employer and welcome applications from a wide range of qualified candidates, including people with disabilities. If you have questions or require assistance with the application process, please email accessibility@chartwell.com or call 1-888-663-6448.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.