Oracle EPM Consultant

Seeking a skilled Oracle EPM Consultant who specializes in developing advanced business analytics and tailored solutions using Oracle EPM technologies. This on-site role centers around leveraging both on-premises and SaaS (PBCS, HPCM) EPM platforms—including Essbase, Hyperion Planning, and Data Relationship Management (DRM).

Qualifications:

Disclaimer:

Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.

Range and benefit information provided in this posting are specific to the stated locations only

US: Hiring Range in USD from $33.94 to $67.88 per hour; from: $70,600 to $141,200 per annum. May be eligible for equity.

Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle’s differing products, industries and lines of business.
Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.

Oracle US offers a comprehensive benefits package which includes the following:
1. Medical, dental, and vision insurance, including expert medical opinion
2. Short term disability and long term disability
3. Life insurance and AD&D
4. Supplemental life insurance (Employee/Spouse/Child)
5. Health care and dependent care Flexible Spending Accounts
6. Pre-tax commuter and parking benefits
7. 401(k) Savings and Investment Plan with company match
8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
9. 11 paid holidays
10. Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
11. Paid parental leave
12. Adoption assistance
13. Employee Stock Purchase Plan
14. Financial planning and group legal
15. Voluntary benefits including auto, homeowner and pet insurance

The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.

Career Level - IC3

Responsibilities:

Key Responsibilities:

•  Design, develop, and implement advanced business analytics solutions using Oracle Essbase, Hyperion Planning, FDMEE, DRM, and related technologies. 
• Build and customize complex business rules, calculation scripts, and reporting frameworks to address unique business requirements.
• Develop integrations and automated processes between EPM applications and other enterprise systems, leveraging MS SQL, PowerShell, and/or Python where appropriate.
• Work closely with business users to gather requirements, provide data-driven insights, and translate business goals into robust, actionable EPM solutions.
• Support and enhance reporting capabilities, including SmartView reports, dashboards, and ad-hoc analytic tools.
• Provide subject matter expertise and troubleshooting support for EPM platforms, with a focus on optimizing system performance and user experience.
• Collaborate with cross-functional stakeholders to foster data governance and maintain metadata accuracy using DRM.
• Deliver end-user training, documentation, and ongoing support to drive adoption of analytics solutions.
• Stay current on Oracle EPM best practices, analytics trends, and related technologies.
• Assist with system upgrades and migrations as needed (experience with upgrades is a plus, but not the primary responsibility).

 

Required Qualifications:

•  Minimum 5 years of client-facing experience delivering customized solutions with Oracle EPM products (Essbase, Hyperion Planning, DRM, PBCS/HPCM).
• Extensive technical experience with calculation scripts, business rules, and use of Calc Manager.
• Proven expertise creating analytical reports, dashboards, and custom solutions in EPM environments.
• Proficiency with MS SQL Server for data integration, preparation, and transformation.
• Strong hands-on experience with SmartView for both reporting and user support.
• Demonstrated ability to design and automate business processes using scripting (PowerShell and/or Python experience is desirable).
• Excellent communication skills and a collaborative approach to gathering requirements and translating them into solutions.
• Bachelor’s degree in Computer Science, Information Systems, Finance, or a related field, or equivalent experience.
• Financial services industry background preferred.

 

Preferred Skills:

•  Scripting proficiency in PowerShell and/or Python for automation and process improvement.
• Experience supporting or managing EPM system upgrades.
• Oracle certification in EPM, Essbase, Hyperion, or related technologies.
• Familiarity with data integration tools (such as FDMEE).
• Knowledge of financial and regulatory best practices.
• Agile or PMP certification is a plus.

 

Location: Position will be onsite at client in Purchase, NY. 

 

#LI-RR2

Salary : $34 - $68