Oracle EPM Consultant

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

Job summary

Softclouds in San Diego, CA seeks an experienced Oracle EPM Hyperion/ODI professional to design, implement, and support Oracle EPM applications and integrations. You will collaborate with business users and stakeholders to document requirements, develop planning forms and dashboards, and automate deployment tasks.

The role covers end-to-end development, testing, deployment, production support, and continuous improvement of EPM processes and data integrations.

Qualifications

• Experience as a technical consultant or team member in Oracle EPM and/or Oracle Data Integration projects.
• Capability to deliver moderately to highly complex technical solutions.
• Experience supporting production environments and resolving critical incidents.
• Experience working directly 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, FreeForm, Planning, Essbase).
• Create and maintain planning forms, rules, calculations, dashboards, and reports.
• Develop Essbase scripts, member formulas, allocations, and data loads.
• Develop and maintain EPM Automate, MaxL, shell and batch scripts for automation.
• Develop and maintain EPM integrations using Data Integration, Data Exchange, Data Management, EPM Agents.
• Configure EDMCS apps with viewpoints, hierarchies, subscriptions, validations, and metadata integrations.
• Support metadata management, including member creation and hierarchy maintenance.
• Troubleshoot issues across application, calculation, data load, metadata, and reporting.
• Assist in deployments, migrations, releases, and post-production validation.
• Identify opportunities for process automation and data quality improvements.
• Establish data standards and data quality controls.
• Monitor data quality for reliable decision-making and resolve infra/connectivity issues.

Skills

Oracle EPM Cloud

Hyperion Planning

Essbase

EDMCS

Narrative Reporting

Oracle Data Integrator

SQL

PL/SQL

Data Integration & ETL

Shell & Batch Scripting

Tools

Oracle Data Integrator

Oracle EPM Cloud

Data Integration

Job description

San Diego, United States | Posted on 10/27/2026

• State/Province California
• Country United States

Job Description

Overview

We are seeking an experienced Oracle EPM Hyperion and ODIprofessional with strong technical expertise in Oracle EPM Cloud, HyperionPlanning, Essbase, EDMCS, Narrative Reporting, Oracle Data Integrator, andenterprise data integrations.

The candidate will be responsible for designing, developing,maintaining, supporting, and enhancing Oracle EPM applications andintegrations. The role requires strong analytical, troubleshooting, SQL,metadata management, and stakeholder communication skills.

Experience Expectations

• Experienceworking as a technical consultant or team member in Oracle EPM and/or OracleData Integration projects.
• Experiencedelivering technical solutions of moderate to high complexity.
• Experiencesupporting production environments and resolving critical incidents.
• Experienceworking directly with business users and stakeholders.
• Experiencewith end-to-end development, testing, deployment, and production supportactivities.

Preferred Qualifications

• OracleEPM Cloud certifications.
• OracleData Integrator certifications.
• Experiencewith Oracle Cloud Infrastructure (OCI).
• Experiencewith enterprise financial planning and reporting processes.
• Experiencewith Agile and DevOps-based delivery models.
• Experiencewith application migration and release management across EPM environments.

Requirements

Key Responsibilities – Oracle EPM / Hyperion

• Workclosely with business stakeholders to analyze and clearly document businessrequirements, processes, functional requirements, and business rules.
• Design,develop, configure, test, and deploy solutions using Oracle EPM EPBCS, EPMFreeForm, Hyperion Planning, Essbase, EDMCS, Narrative Reporting, and relatedOracle EPM technologies.
• Createand maintain Planning forms, business rules, calculation scripts, task lists,dashboards, reports, Smart View templates, and other EPM artifacts.
• Developand maintain Essbase calculation scripts, member formulas, allocations,aggregations, and data load processes.
• Designand develop EPM Automate scripts, MaxL scripts, shell scripts, and batchscripts to automate operational and administrative activities.
• Developand maintain EPM integrations using Data Integration, Data Exchange, Data Management, EPM Agents, and other Oracle integration capabilities.
• Configureand maintain EDMCS applications, viewpoints, hierarchies, subscriptions,validations, requests, and metadata integrations with EPBCS and other systems.
• Supportmetadata management activities, including member creation, hierarchymaintenance, validation, and metadata synchronization across source and targetsystems.
• Troubleshootapplication, calculation, data load, metadata, integration, and reportingissues.
• Supportproduction deployments, application migrations, release activities, andpost-production validation.
• Identifyopportunities for process automation and continuous improvement to improveapplication stability, performance, and operational efficiency.
• Establishand maintain data standards, naming conventions, consistent data definitions,and data quality controls.
• Monitorand audit data quality to ensure data is accurate, complete, consistent,andreliable for operational and strategic decision-making.
• Assistin resolving technical infrastructure, security, connectivity, andenvironment-related issues.

Key Responsibilities – Oracle Data Integrator (ODI)

• Design,develop, maintain, and support integrations using Oracle Data Integrator (ODI).
• Developand maintain ODI mappings, packages, scenarios, load plans, procedures, andschedules.
• Analyze,troubleshoot, and resolve ODI integration failures and performance issues.
• Developand optimize SQL and PL/SQL queries, procedures, and routines.
• Analyzedata and metadata-related issues involving source systems, stagingenvironments, and target applications.
• Designand support integrations across multiple data sources and target systems,including ERP systems, EPM applications, databases, flat files, and otherenterprise applications.
• Developand maintain data extraction, transformation, validation, and loadingprocesses.
• Supportintegrations with downstream reporting and analytical applications such asMainframe systems, SAP, Business Objects, FMIS, Essbase, PBCS/EPBCS, and otherenterprise reporting platforms.
• Work with FDMEE, Data Integration, load rules, SQL routines, ODI,and other technologies to support enterprise data integration requirements.
• Performroot cause analysis for data load, transformation, metadata, and integrationissues and implement permanent corrective actions.

Required Technical Skills

• OracleEPM EPBCS and EPM FreeForm
• HyperionPlanning and Essbase
• FDMEEand EPM load rules
• Essbasecalculation scripts
• BusinessRules and Groovy Rules
• SQLand PL/SQL
• SQLServer and relational databases
• Metadatamanagement and hierarchy maintenance
• Dataintegration and ETL processes
• Shellscripting and batch scripting

Functional and Professional Skills

• Stronganalytical and problem-solving skills.
• Abilityto analyze complex business and technical requirements.
• StrongSQL query development and query optimization skills.
• Abilityto troubleshoot complex data, metadata, calculation, and integration issues.
• Strongattention to detail and commitment to data quality.
• Abilityto communicate technical concepts effectively to both technical andnon-technical stakeholders.
• Abilityto work independently while also collaborating effectively within a team.
• Strongownership, accountability, and delivery orientation.
• Abilityto manage multiple priorities in a fast-paced consulting or supportenvironment.