Senior Principal Business Analyst - Finance - Hyperion Financial Planning
May 21, 2018
Full Time - Experienced
The Financial Industry Regulatory Authority (FINRA) is seeking a well-qualified individual for our Senior Principal Business Analyst opening in Rockville, MD To be considered for this position, please submit your resume through our career site at www.finra.org/careers – no phone calls, please.
This position is responsible for oversight of the design and administrative functions of Hyperion Planning and Essbase as part of Oracle Enterprise Performance Management System (EPM). This position leads the strategic implementation of ongoing and future enhancements to the existing EPM applications and development of any new EPM applications. This position also has primary responsibility for all analysis, design, implementation, maintenance and operational aspects of the EPM applications. In addition to a strong technology background, this role requires knowledge in multiple financial processes (such as forecasting, budgeting, month-end close process, financial reporting and cost allocation models) and proficiency in creating and documenting solutions for complex financial and data intensive systems. This role requires high proficiency of other Oracle Hyperion tools including Hyperion Financial Data Quality Management (FDM), Enterprise Performance Management Architect (EPMA), Essbase Studio and SmartView.
Essential Job Functions:
Business Job Responsibilities:
Lead the design, development, enhancements and maintenance of business requirements and implementation for Oracle Hyperion applications and databases to meet forecasting, budgeting, month-end close processing and financial reporting requirements with minimal supervision.
Prepare high level status reports and briefings for management on the status of implementation projects to ensure that enhancements efforts are communicated to the team, are delivered in a timely manner, and to measure anticipated benefits.
Develop, test and maintain application outlines, business rules, and calculation scripts in multiple environments.
Manage application outlines for multiple applications and application types using EPMA.
Create, modify and maintain web forms and embedded calculation logic in Hyperion Planning based on Finance user needs.
Working with Finance, business and technology resources, maintain and lead the development of complex cost allocation models.
Ability to maintain and troubleshoot complex allocation logic and work with Technology and Finance users to resolve issues in a timely manner.
Modify, create, and maintain Hyperion business rules using Hyperion Calculation Manager.
Design, develop, modify and maintain standard financial reports using Hyperion Financial Reports through working with Finance users to understand business needs and requirements.
Maintain user guides and operational documentation and train users as needed.
Perform and co-ordinate User Testing for system upgrades and implementation of new functionality.
Document and maintain Standard Operating Procedures and Process Flows for SOX 404 compliance.
Technology Job Responsibilities:
Leverage working knowledge of both Essbase ASO and BSO cubes to performance tune and optimize the applications for faster calculations, data movements, and retrievals.
Perform and maintain data integrations and mappings with FDM including understanding of FDM batch processing.
Manage and maintain batch routines that include a combination of windows batch and MAXL scripts to calculate and move data among numerous Essbase cubes.
Manage the development and maintenance of data integrations using Hyperion Data Synchronizer.
Coordinate with Technology resources to maintain drill through capabilities of financial data with Essbase Studio.
Document and implement data integration requirements and test and coordinate source-system updates to Hyperion applications.
Troubleshoot technical issues and work with Oracle Support to resolve Service Requests.
Manage and coordinate systems upgrades and maintain system documentation as needed.
Follow FINRA change control procedures and tools for changes to the applications in compliance with SOX controls.
Bachelor's degree in Accounting Information Systems, Accounting, Finance, or related field and seven years of relevant experience.
Knowledge of forecasting and budgeting process and general financial knowledge
5+ years in Essbase administration including designing, developing and administering the Hyperion Essbase and Hyperion Planning software
Extensive knowledge of end user tools including SmartView, Essbase Add-in for Excel and Financial Reporting
Knowledge of Microsoft Office Excel, Word, PowerPoint and Access
Knowledgeable of PeopleSoft General Ledger, Asset Management, Accounts Payable and Accounts Receivable systems a plus
Knowledgeable of the financial services industry and financial systems
Understanding of financial statements and financial related data
Strong analytical and problem solving skills, particularly with financial data
Strong project management skills, including the ability to manage details through to completion and ensure project deadlines are met
Customer service oriented with strong verbal and written communication skills
Ability to collaborate with others and act in an objective manner in order to effectively solve problems and stay on track towards accomplishing organizational goals
Internal Number: 006601
FINRA is dedicated to investor protection and market integrity through effective and efficient regulation of the securities industry.
FINRA is not part of the government. We’re an independent, not-for-profit organization authorized by Congress to protect America’s investors by making sure the securities industry operates fairly and honestly.
We do this by:
writing and enforcing rules governing the activities of 3,917 securities firms with 639,680 brokers;
examining firms for compliance with those rules;
fostering market transparency; and
Our independent regulation plays a critical role in America’s financial system—by enforcing high ethical standards, bringing the necessary resources and expertise to regulation and enhancing investor safeguards and market integrity—all at no cost to taxpayers.
Every investor in America relies on one thing: fair financial markets. That's why FINRA works every day to ensure that:
every investor receives the basic protections they deserve;
anyone who sells a securities product has been tested, qualified and licensed;
every securities product advertisement used is truthful, and not misleading;
any securities... product sold to an investor is suitable for that investor's needs; and
investors receive complete disclosure about the investment product before purchase.
In 2015, through our aggressive vigilance, we brought 1,512 disciplinary actions against registered brokers and firms. We levied $95.1 million in fines. And we ordered $96.6 million in restitution to harmed investors. We also referred more than 800 fraud and insider trading cases to the SEC and other agencies for litigation and/or prosecution.
Learn more about what we do to protect investors and ensure market integrity.