Lead Analyst, Business Intelligence
Location: United States, US
Job Number: 36450
Employment Type: Full Time Associate
Position Title: Lead Analyst, Bus Intelligence
The primary responsibilities include:
- Working on an experienced team to develop and maintain Hyperion On-Prem and Oracle Planning Cloud (PBCS) applications.
- Partner with business owners, get requirements and build new solutions/ projects in Hyperion Essbase, Planning and in reporting tools.
- Creation of Excel models to validate calculations and transform data for loading into Hyperion.
- Work with Hyperion Essbase, Planning,PBCS, Financial Reporting, and SmartView to deliver value added solutions to our internal customers.
- Creation of Essbase databases, both ASO and BSO, for financial and operational data.
- Ability to create automations using a combination of ODI, MAXL and DOS scripts.
- Maintenance of Hyperion environment including security, data loads, exports, and troubleshooting.
- Setup test scripts for user acceptance and train end users on new and revised applications.
- Thoroughly test all development efforts. Ensure quality control in all aspects of development.
- Requirements and application development
- Testing of all development efforts
- Maintenance of existing environment
- Support of internal customers
Education & Qualifications (Required and Preferred):
- 3-5 years of Hyperion Essbase Administration Preferred
- 5 years of IT/Finance experience
- Strong ability to understand finance and accounting principles
- Expert level proficiency with Microsoft Excel
- Knowledge in Hyperion Essbase, Planning, Financial Reporting, SmartView
- Experience and Knowledge in Hyperion Financial Management (HFM), HFM and Oracle EPM Cloud solutions (Eg: Oracle Planning cloud) a plus
- Experience with SQL, Powershell / windows batch scripting a plus
- Team oriented with strong interpersonal skills
- Able to work in a dynamic environment with multiple priorities
- Bachelor Degree required
Community / Marketing Title: Lead Analyst, Business Intelligence
EEO Employer Verbiage:
EEO Employer Verbiage Displays here
Location_formattedLocationLong: United States, US