More than 30 years ago, E*TRADE pioneered the online brokerage industry by executing the first-ever electronic individual investor trade. While the landscape of our industry has changed dramatically, our culture of innovation and drive to make online trading accessible to everyone continues to drive us forward. We believe in challenging the status quo, fostering an environment of curiosity and learning, and, above all, putting our customers first.
This is a hands on management position that will be responsible for managing the overall daily and monthly processing as scheduled and required. Additionally this position will be responsible for development of complex solutions utilizing Essbase Calc Scripts, Maxl, MDX, Hyperion Planning Business Rules, FDMEE and the underlying Jython scripting. The role collaborates with IT & Financial staff to ensure financial models are meeting organizational needs.
Monitor Hyperion system performance and troubleshoot systems and processes
Work with MIS and Finance to gather requirements on development needs that are in line with the enterprise-wide financial system strategy
Work with MIS to ensure all processing schedules and migrations are executed in compliance with MIS and FPA required standards
Work with MIS and Finance to leverage existing and new technology that will empower users to be as efficient as possible
Mentor business teams to support budgeting/forecasting and reporting best practices
Mentor other Financial Systems Analysts
Facilitate daily maintenance of Essbase and Planning applications, version 188.8.131.52 metadata, sub variables, allocations, calculation and report script development
Support the monthly financial consolidation process, in particular the daily loads and hierarchies from core source systems, as well as forecast and budget processes
Expert level knowledge in development of complex business rules and calculation scripts
Expert level knowledge working with FDMEE and extensive Jython scripting
Maintain and update security in Shared Services as well as Essbase, Financial Reporting (FR), Planning applications and FDMEE
Monitor application performance. Be able to quickly identify and communicate resolution of issues
Perform database optimization and tuning of Essbase cubes for retrieval and calculation performance
Develop and manage scheduled job routines within Essbase and between other reporting applications
Development new Hyperion applications and FDMEE Locations
Ability to leverage advanced analytical skills to challenge current processes, data, and reports for accuracy and improvements
Support end user audience with Hyperion Essbase, Planning, Smart View, HFR, HTP and FDMEE.
Execution and Support of the migration process when promoting changes from Non-Production environments to Production
BS or BA required, preferably in Information Systems, Accounting or Finance
5+ years of experience with Oracle Hyperion Planning, Essbase, FDMEE, Financial Reporting and all the supporting tools and utilities
Essbase BSO/ASO: metadata maintenance, calc scripts, MAXL, MDX, application optimization, partitioning
Planning: creating forms and business rules, calc manager
FDMEE: Development of FDMEE locations, maintenance and revisions to existing locations and a deep knowledge of the underlying Jython code.
Shared Services: LCM for migrations. Security for Planning, Essbase, FDMEE, HFM/HTP, HFR
Expert knowledge of the required EPM suite scripting languages: Essbase Calc Script, Hyperion Planning Rules, Maxl, MDX, Jython.
Hands On expertise with Shared Services and LCM is required
Advanced Working knowledge of ETL concepts
Understanding of Financial Planning processes and how they integrate with other areas of an organization
Exceptional customer service with focus on the end-user
Full technical understanding of Oracle EPM to include migrations and all components of migrations. There must be an ability to trace through all components as it appears throughout the objects and scripting to troubleshoot and to migrate to production
Understanding of finance, financial analysis, financial analysis terms
Solid technical and analytical skills in finance, general accounting, budgeting, financial analysis. An understanding of the basic business disciplines in order to develop, analyze and interpret financial data.
Advanced knowledge of Oracle EPM suite: Essbase BSO/ASO and partitioning, Smart View, Planning to include Workforce Planning, Report Writing Studio, FDMEE
Experience with general ledger systems and particularly with the Drill through feature utilizing FDMEE.
Previous experience with Hyperion Financial Management (HFM), Hyperion Tax Provisioning (HTP)
ODI: Oracle Data Integrator
We offer a competitive and comprehensive benefits package. Please visit https://www.etradecareers.com/why-work-at-etrade/employee-benefits/ to learn more about the opportunities.
E*TRADE Financial is an Equal Opportunity Employer who encourages diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, age, disability, citizenship, marital status, sexual orientation, gender identity, military or protected veteran status, or any other characteristic protected by applicable law.