Financial Systems Analyst - (US-NJ-Elmwood Park - 07407)

Minimum Education: Bachelors
Job Type: Full Time
Jobcode: EB-FA
Email this job to yourself or to a friend | Job Match Test | Resume Guide

RESPONSIBILITIES:

• Administration of Hyperion Financial Consolidation, Corporate KPI dashboard and Financial Planning systems.
? Enhancement, performance tuning and optimization of Hyperion Essbase Cubes and calculation scripts.
? Design and development of Enterprise/HFM environment to meet business needs.
? Hierarchy changes and update of substitution variables and business rules.
? Development and testing of changes / enhancements dashboard views, planning input forms and financial reports.
? Timely sourcing and update of data with automation where possible.
? Security Administration and software upgrades.
? Migration of changes between non-production and production environments.
• Supporting monthly, quarterly, and annual financial closing processes along with quarterly forecasting process and annual Budget. Proactively identify efficiency and quality improvements to current processes.
• Promote the use of standardized business intelligence tools and technologies.
• Collaborating with Infrastructure group to ensure reliable and responsive financial systems.
• Supporting various projects / initiatives as assigned by the Corporate Financial Systems Manager. Includes training and knowledge transfer initiatives with Finance group.
• Maintaining documentation on key systems and processes.
• Supporting SOX testing requirements for systems that directly support external reporting.

QUALIFICATIONS:
• Bachelor's degree in Finance, Accounting, Computer Science or related area.
• Minimum 3 years technical experience with Hyperion Essbase, Planning and Financial Management (HFM). Includes following: Essbase cube, calculation script and load rule development and performance tuning; Outline maintenance; Security Administration; Excel Add-in / SmartView; Essbase Administration Services, Essbase Integration Services, Shared Services.
• Experience implementing or upgrading Hyperion Enterprise and/or HFM.
• Experience with Windows Office applications along with advanced Excel skills (including macros) is required. Experience with Unix operating system is desirable.
• Experience with a multinational corporation using SAP ERP and BW is desirable.
• Experience with Hyperion System 9 BI Suite in following areas is desirable: Financial Reporting, Web Analysis, Interactive Reporting, Performance Scorecard & MaxL.
• Experience with Informatica ETL (Hyperion Data Integration Management - DIM), SAP BW and Business Objects Crystal Reports or Web Intelligence is desirable.
• Experience with relational databases (ie. Oracle, MS SQL, Access) is desirable.
• Strong technical and business acumen with proven interpersonal and communication skills. Able to work effectively both independently and with a broad range of business and IS counterparts.
• Strong analytic and problem-solving abilities showing initiative and customer focus in a deadline sensitive environment.