Part time

SoftClouds, LLC; San Diego (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

SoftClouds, LLC in San Diego, CA, seeks an experienced Oracle EPM Hyperion and ODI professional to design, implement, and support EPM solutions. You will work with stakeholders to translate requirements into scalable, automated EPM deployments.

The role requires deep hands-on expertise across Oracle EPM Cloud, Hyperion Planning, Essbase, EDMCS, Narrative Reporting, and ODI, plus strong SQL, data integration, and DevOps-aligned delivery.

Qualifications

• Experience as a technical consultant or team member in Oracle EPM/ODI projects.
• Deliver technical solutions of moderate to high complexity.
• Experience supporting production environments and resolving critical incidents.
• Experience working directly with business users and stakeholders.
• End-to-end development, testing, deployment, and production support activities.

Responsibilities

• Work with stakeholders to analyze and document business requirements, processes, and rules.
• Design, configure, test, and deploy solutions using Oracle EPM EPBCS, EPM FreeForm, Hyperion Planning, Essbase, EDMCS, Narrative Reporting, and related technologies.
• Create and maintain Planning forms, business rules, calculation scripts, dashboards, reports, and Smart View templates.
• Develop and maintain Essbase calculation scripts, members, allocations, and data load processes.
• Develop and maintain EPM Automate scripts, MaxL scripts, shell scripts, and batch scripts.
• Develop and maintain EPM integrations using Data Integration, Data Exchange, Data Management, EPM Agents.
• Configure and maintain EDMCS applications, viewpoints, hierarchies, and metadata integrations with EPBCS.
• Assist in metadata management, including member creation, hierarchy maintenance, validation, and synchronization.
• Troubleshoot application, calculation, data load, metadata, integration, and reporting issues.
• Support production deployments, migrations, release activities, and post-production validation.
• Identify opportunities for automation and process improvement to enhance stability and efficiency.
• Establish and maintain data standards and data quality controls.
• Monitor and audit data quality for decision-making.
• Assist in resolving infrastructure, security, connectivity, and environment-related issues.

Skills

Oracle EPM Cloud

Hyperion Planning

Essbase

EDMCS

Narrative Reporting

ODI

Data Integration

SQL

PL/SQL

Stakeholder comms

Tools

Oracle EPM Cloud

Hyperion Planning

Essbase

ODI

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.