JobRialto
Oracle Hyperion/Essbase EPM Consultant
JobRialto, Jersey City, New Jersey, United States, 07390
Role Description:
The purpose of this position is to support FP&A reporting platforms and associated technical.
Responsible for all techno functional support aspects of current FP&A applications (with ERP/GL experience) while we migrate to a new SAAS vendor platform.
Must be a strategic thinker and demonstrate leadership elements and considerable independent judgment and initiative in carrying out project objectives.
Develop strategies for effective data analysis and reporting by working closely with Corporate Finance FP&A Controllers and managing a team of data engineers to ensure data accuracy and leading to optimal processes and procedures for analytics employees to follow.
Should have the aptitude to learn newly introduced Financial ERP Cloud applications and ancillary Finance platforms.
Must have Dimensional Reporting Knowledge, with the ability to develop complex SQL scripts and stored procedures with Hyperion, Essbase, Smart View, web forms and reports.
Experience with financial statements, including income statements, balance sheet, P&L, and cash flow is a must.
Qualifications:
Minimum 10 years Hands on experience with implementation, development, and support experience with various Reporting Platforms, preferably gained within one or more financial institution.
Deep Financial management reporting, forecasting and budgeting experience in the Financial Services arena.
Preferred knowledge in both Oracle Database Schema and Snow-Flake Schema data modeling techniques
Create and maintain data forms, calculation scripts, MAXL automation, schedule jobs using batch scripts and business rules
Develop and maintain Block Storage Outline / Aggregate Storage Outline (BSO/ASO) cubes
Knowledge of Reporting Tools Hyperion BI+ (Web Analysis) Hyperion Reports 7.x/9.x, Hyperion Analyzer 7.x, Hyperion Excel Add-in, Smart View.
SQL Loader functionality to interact with Essbase Cubes to and from with Oracle Database
Excellent communication and presentation skills, both verbal and written
Education:
Bachelors Degree
The purpose of this position is to support FP&A reporting platforms and associated technical.
Responsible for all techno functional support aspects of current FP&A applications (with ERP/GL experience) while we migrate to a new SAAS vendor platform.
Must be a strategic thinker and demonstrate leadership elements and considerable independent judgment and initiative in carrying out project objectives.
Develop strategies for effective data analysis and reporting by working closely with Corporate Finance FP&A Controllers and managing a team of data engineers to ensure data accuracy and leading to optimal processes and procedures for analytics employees to follow.
Should have the aptitude to learn newly introduced Financial ERP Cloud applications and ancillary Finance platforms.
Must have Dimensional Reporting Knowledge, with the ability to develop complex SQL scripts and stored procedures with Hyperion, Essbase, Smart View, web forms and reports.
Experience with financial statements, including income statements, balance sheet, P&L, and cash flow is a must.
Qualifications:
Minimum 10 years Hands on experience with implementation, development, and support experience with various Reporting Platforms, preferably gained within one or more financial institution.
Deep Financial management reporting, forecasting and budgeting experience in the Financial Services arena.
Preferred knowledge in both Oracle Database Schema and Snow-Flake Schema data modeling techniques
Create and maintain data forms, calculation scripts, MAXL automation, schedule jobs using batch scripts and business rules
Develop and maintain Block Storage Outline / Aggregate Storage Outline (BSO/ASO) cubes
Knowledge of Reporting Tools Hyperion BI+ (Web Analysis) Hyperion Reports 7.x/9.x, Hyperion Analyzer 7.x, Hyperion Excel Add-in, Smart View.
SQL Loader functionality to interact with Essbase Cubes to and from with Oracle Database
Excellent communication and presentation skills, both verbal and written
Education:
Bachelors Degree