TM1/OLAP Administrator

This is a Full Time Job

We have an opportunity for a CognosTM1 Systems Administrator for system administration of the TM1 planning, forecasting, and reporting software, coordinating across FP&A and accounting. This role is focused on the administration and support for the Cognos TM1 and improving the system support processes. The preferred skillset for OLAP toolset is TM1. Experience with comparable technologies such as hyperion, Essbase etc will be considered.
Job Responsibilities include, but are not limited to: Synthesizes analyses, identifies root causes, and develop and recommend key work products. Provides guidance in evaluating technical proposals and serve as the subject matter expert. Assembles key participants and guides and facilitates teams in the development and implementation of key initiatives. Provide insight to management on issues. Serve as a resource to team members on escalated issues of an unusual nature.

Support business as usual processing and set up of budgeting, forecasting, Staff planning, Cape ex modeling and Financial reporting systems. Process day to day data loads for reporting, manage user set ups, monitor system environment for optimal performance. Perform system changes and set up required to commence budget and forecast cycle. Primary responsibility includes managing TM1 and related tools in order to ensure data integrity for management reporting and assisting Accounting and FPA business users in planning, analysis, and decision making in order to meet business needs.

Business knowledge of finance and/ or accounting functions is required. Thorough understanding of TM1 or comparable OLAP technology including development and maintenance of complex allocation models and database management is required. Presentation and training skills required. This role may require 24 hour (on-call) availability during critical periods.

The candidate will be expected to play a leadership role in the development and implementation of solutions leveraging Oracle and SQL Server systems. While maintaining a focus on quality deliverables, the candidate must be able to effectively manage project tasks, participate in project analysis, prepare/deliver presentations and training and provide guidance and direction to business users.

Expected to build and maintain positive relationships with key business users and exhibit a solid understanding of basic business concepts and practices. Required to play a key role in designing and testing assigned applications both as stand-alone and as integrated modules and obtains responsibility for the applications as a central point-of-contact.

QUALIFICATIONS:

The ideal candidate will have background in accounting/finance background coupled with experience in technology and system interfacing.

* Experience implementing and managing Hyperion/Essbase and/or TM1 (Preferred) applications within large and complex environments.
* Prior experience with Cognos BI and TM1 is highly desirable
* Solid understanding of the development lifecycle, including data modeling, dimensional and relational modeling, requirements analysis, ETL, and report creation and delivery
* Prior experience with ERP systems (J.D. Edwards/MS Dynamics preferred)
* Must have solid understanding of financial planning and reporting processes along with their impact on technologies and systems.
* Must have completed at least 2 to 4 planning and reporting implementations using structured project methodologies and tools that support requirements, design, development, validation, deployment and training.
* Must have experience with OLAP technology Planning, TI processes including Business Rules, Web Analysis, Financial Reporting, ODI/FDM, TI processes, Rules and general OLAP administration
* Must have solid communication (verbal / written) and organizational skills

Education:
Bachelors in Finance, Accounting, or Computer Science.
MBA or CPA preferred