Damco Solutions
Financial Planning & Analysis (FP&A)
Damco Solutions, New York, NY, United States
Description
• The purpose of this position is to support FP&A reporting platforms and associated technical processes.
• 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
• Experience with this combination of software:
• Oracle Enterprise Performance Management System Workspace
• Hyperion Essbase
• Hyperion Planning
• Hyperion Shared Services
• Essbase
• Essbase Integration Services
• Excel Add-Ins
• Hyperion Financial Reporting Studio
• Interactive Reporting Studio
• Dashboard Reporting
• SaaS Reporting Tools
• Workflow / AI Machine Learning
• Familiarity with Board Enterprise Planning Platform would be a plus.
• The purpose of this position is to support FP&A reporting platforms and associated technical processes.
• 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
• Experience with this combination of software:
• Oracle Enterprise Performance Management System Workspace
• Hyperion Essbase
• Hyperion Planning
• Hyperion Shared Services
• Essbase
• Essbase Integration Services
• Excel Add-Ins
• Hyperion Financial Reporting Studio
• Interactive Reporting Studio
• Dashboard Reporting
• SaaS Reporting Tools
• Workflow / AI Machine Learning
• Familiarity with Board Enterprise Planning Platform would be a plus.