Oracle EPM Architect: Hyperion, ODI & Cloud Expert

SoftClouds; San Diego (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

SoftClouds is seeking an experienced Oracle EPM Hyperion and ODI professional to design, develop, and maintain Oracle EPM applications and integrations. The role requires strong analytical, troubleshooting, SQL, metadata management, and stakeholder communication skills.

The candidate will work on EPBCS, Hyperion Planning, Essbase, EDMCS, Narrative Reporting, and ODI integrations, collaborating with business users across projects. Prior OCI experience and certification are preferred for this role.

Qualifications

• Experience as a technical consultant or team member in Oracle EPM and/or Oracle Data Integration projects.
• Delivering technical solutions of moderate to high complexity.
• Supporting production environments and resolving critical incidents.
• Collaborating with business users and stakeholders.
• Experience with end-to-end development, testing, deployment, and production support.

Responsibilities

• Analyze and document business requirements, processes, and rules with stakeholders.
• Design, develop, configure, test, and deploy EPM solutions (EPBCS, EPM Cloud, Hyperion).
• Create and maintain Planning forms, rules, calculation scripts, dashboards, and reports.
• Develop and maintain Essbase calculations, data loads, and aggregations.
• Develop EPM Automate, MaxL, and shell scripts for automation.
• Create and maintain EPM integrations using ODI, Data Management, and related tools.
• Configure EDMCS applications, viewpoints, subscriptions, and metadata sync.
• Support metadata management, data quality, and production deployments.
• Identify opportunities for automation and process improvements.

Skills

Oracle EPM Cloud

Hyperion Planning

Essbase

EDMCS

Narrative Reporting

ODI

Data Integration

Automation scripting

SQL/PLSQL

Troubleshooting

Education

Oracle EPM Cloud certifications

ODI certifications

OCI certifications

Tools

ODI

FDMEE

Data Management

Data Exchange

EPM Automate

MaxL

Job description

SoftClouds is seeking an experienced Oracle EPM Hyperion and ODI professional to design, develop, and maintain Oracle EPM applications and integrations. The role requires strong analytical, troubleshooting, SQL, metadata management, and stakeholder communication skills.

The candidate will work on EPBCS, Hyperion Planning, Essbase, EDMCS, Narrative Reporting, and ODI integrations, collaborating with business users across projects. Prior OCI experience and certification are preferred for this role.