Job Description
We are looking for a talented Oracle EPM Consultant who excels in crafting advanced business analytics and customized solutions using Oracle EPM technologies. This role emphasizes utilizing both on-premises and SaaS (PBCS, HPCM) EPM platforms, including Essbase, Hyperion Planning, and Data Relationship Management (DRM). At this time, visa sponsorship is not offered for this position. Ideally, candidates should be based in White Plains, NY and available for onsite work. Consideration will also be given to candidates in the Eastern Time Zone, and others willing to align with East Coast hours.
Responsibilities
Key Responsibilities:
Design, develop, and implement sophisticated business analytics solutions leveraging Oracle Essbase, Hyperion Planning, FDMEE, DRM, and associated technologies.
Create and customize detailed business rules, calculation scripts, and reporting frameworks to meet specific business needs.
Establish integrations and automated processes between EPM applications and enterprise systems, utilizing MS SQL, PowerShell, and/or Python as necessary.
Engage closely with business users to capture requirements, deliver data-driven insights, and translate business objectives into efficient EPM solutions.
Enhance reporting capabilities through SmartView reports, dashboards, and ad-hoc analytic tools.
Provide expert support and troubleshooting for EPM platforms, focusing on system performance optimization and user satisfaction.
Collaborate with cross-functional teams to ensure data governance and maintain metadata accuracy with DRM.
Deliver comprehensive end-user training, documentation, and continuous support to promote the use of analytics solutions.
Stay updated on Oracle EPM best practices, analytics advancements, and related technologies.
Assist in system upgrades and migrations as necessary (experience with upgrades is beneficial, though not the primary focus).
Required Qualifications: At least 5 years of client-facing experience providing customized solutions with Oracle EPM products (Essbase, Hyperion Planning, DRM, PBCS/HPCM).
Extensive expertise in calculation scripts, business rules, and the use of Calc Manager.
Proven track record in creating analytical reports, dashboards, and tailored solutions within EPM environments.
Strong proficiency in MS SQL Server for data integration, preparation, and transformation.
Significant hands-on experience with SmartView for reporting and user assistance.
Ability to design and automate business processes through scripting, with experience in PowerShell and/or Python being highly desirable.
Excellent communication abilities and a collaborative approach to requirement gathering and solution development.
Bachelor's degree in Computer Science, Information Systems, Finance, or a related field or equivalent experience.
Experience in the financial services industry is preferred.
Preferred Skills: Proficiency in scripting with PowerShell and/or Python for automation and process enhancement.
Experience in supporting or managing EPM system upgrades.
Oracle certification in EPM, Essbase, Hyperion, or related technologies.
Familiarity with data integration tools, such as FDMEE.
Understanding of financial and regulatory best practices.
Agile or PMP certification is a plus.
Disclaimer: Certain US customer or client-facing roles may require compliance with applicable requirements, such as immunization and occupational health mandates. The compensation information provided in this posting is specific to the stated locations only US: Hiring Range in USD from $33.94 to $67.88 per hour; annual range from $70,600 to $141,200. May be eligible for equity. Oracle maintains broad salary ranges for its roles to account for variations in knowledge, skills, experience, market conditions, and locations, and to reflect Oracle's diverse products and industries. Oracle US provides a comprehensive benefits package, including: Medical, dental, and vision insurance, along with expert medical opinion services
Short-term and long-term disability coverage
Life insurance and AD&D
Supplemental life insurance options (Employee/Spouse/Child)
Flexible Spending Accounts for healthcare and dependent care
Pre-tax commuter and parking benefits
401(k) Savings and Investment Plan with company matching
Paid time off: Flexible Vacation for eligible salaried employees; accrued vacation for others
11 paid holidays
Paid sick leave: 72 hours upon hire, refreshing each calendar year, with carryover up to 112 hours
Paid parental leave
Adoption assistance
Employee Stock Purchase Plan
Financial planning and group legal assistance
Voluntary benefits including auto, homeowner, and pet insurance
The application window for this role will generally be at least three calendar days from the posting date or as long as the position remains posted. Career Level - IC3 About Us At Oracle, we bring together data, infrastructure, applications, and expertise to drive innovations and solutions that have a profound impact on lives. With AI integrated across our products and services, we empower customers to shape a better future. Join us in a dynamic environment that promotes inclusivity and competitive benefits tailored to support our employees. We also encourage community engagement through our volunteer initiatives. Our commitment to accessibility ensures all applicants are supported at every stage of our hiring process. If you require assistance or accommodation due to a disability, please reach out. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will be considered for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability status, or any other characteristic protected by law.
Create and customize detailed business rules, calculation scripts, and reporting frameworks to meet specific business needs.
Establish integrations and automated processes between EPM applications and enterprise systems, utilizing MS SQL, PowerShell, and/or Python as necessary.
Engage closely with business users to capture requirements, deliver data-driven insights, and translate business objectives into efficient EPM solutions.
Enhance reporting capabilities through SmartView reports, dashboards, and ad-hoc analytic tools.
Provide expert support and troubleshooting for EPM platforms, focusing on system performance optimization and user satisfaction.
Collaborate with cross-functional teams to ensure data governance and maintain metadata accuracy with DRM.
Deliver comprehensive end-user training, documentation, and continuous support to promote the use of analytics solutions.
Stay updated on Oracle EPM best practices, analytics advancements, and related technologies.
Assist in system upgrades and migrations as necessary (experience with upgrades is beneficial, though not the primary focus).
Required Qualifications: At least 5 years of client-facing experience providing customized solutions with Oracle EPM products (Essbase, Hyperion Planning, DRM, PBCS/HPCM).
Extensive expertise in calculation scripts, business rules, and the use of Calc Manager.
Proven track record in creating analytical reports, dashboards, and tailored solutions within EPM environments.
Strong proficiency in MS SQL Server for data integration, preparation, and transformation.
Significant hands-on experience with SmartView for reporting and user assistance.
Ability to design and automate business processes through scripting, with experience in PowerShell and/or Python being highly desirable.
Excellent communication abilities and a collaborative approach to requirement gathering and solution development.
Bachelor's degree in Computer Science, Information Systems, Finance, or a related field or equivalent experience.
Experience in the financial services industry is preferred.
Preferred Skills: Proficiency in scripting with PowerShell and/or Python for automation and process enhancement.
Experience in supporting or managing EPM system upgrades.
Oracle certification in EPM, Essbase, Hyperion, or related technologies.
Familiarity with data integration tools, such as FDMEE.
Understanding of financial and regulatory best practices.
Agile or PMP certification is a plus.
Disclaimer: Certain US customer or client-facing roles may require compliance with applicable requirements, such as immunization and occupational health mandates. The compensation information provided in this posting is specific to the stated locations only US: Hiring Range in USD from $33.94 to $67.88 per hour; annual range from $70,600 to $141,200. May be eligible for equity. Oracle maintains broad salary ranges for its roles to account for variations in knowledge, skills, experience, market conditions, and locations, and to reflect Oracle's diverse products and industries. Oracle US provides a comprehensive benefits package, including: Medical, dental, and vision insurance, along with expert medical opinion services
Short-term and long-term disability coverage
Life insurance and AD&D
Supplemental life insurance options (Employee/Spouse/Child)
Flexible Spending Accounts for healthcare and dependent care
Pre-tax commuter and parking benefits
401(k) Savings and Investment Plan with company matching
Paid time off: Flexible Vacation for eligible salaried employees; accrued vacation for others
11 paid holidays
Paid sick leave: 72 hours upon hire, refreshing each calendar year, with carryover up to 112 hours
Paid parental leave
Adoption assistance
Employee Stock Purchase Plan
Financial planning and group legal assistance
Voluntary benefits including auto, homeowner, and pet insurance
The application window for this role will generally be at least three calendar days from the posting date or as long as the position remains posted. Career Level - IC3 About Us At Oracle, we bring together data, infrastructure, applications, and expertise to drive innovations and solutions that have a profound impact on lives. With AI integrated across our products and services, we empower customers to shape a better future. Join us in a dynamic environment that promotes inclusivity and competitive benefits tailored to support our employees. We also encourage community engagement through our volunteer initiatives. Our commitment to accessibility ensures all applicants are supported at every stage of our hiring process. If you require assistance or accommodation due to a disability, please reach out. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will be considered for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability status, or any other characteristic protected by law.