Position: Senior Specialist Data Engineering
Location: Jersey City N.J
Job 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 SnowFlake 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 Addin 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