ORACLE EPM TECHNICAL CONSULTANT – DAI EPM INTEGRATION

Remote Position
Pay Rate: Open
Employment Options: W-2 or Corp-to-Corp
Position Type: Multiyear Contract
Federal Experience: Strongly Preferred

ROLE SUMMARY

eAccounting is seeking a senior, hands-on Oracle EPM Technical Consultant to support the Defense Agencies Initiative (DAI) EPM rollout across approximately 25 DoD agencies. The consultant will design, configure, develop, integrate, test, deploy, and support Oracle EPM applications used for DoD budget formulation, spend planning, forecasting, funds management, and plan-versus-actual execution reporting.

The ideal candidate combines strong Oracle EPM Cloud technical expertise with an understanding of federal financial data and the DoD PPBE lifecycle. The role requires advanced experience with EPM Planning, Essbase, calculations, Groovy, integrations, metadata, reporting, security, migrations, and environment operations.

This is not an entry-level or training role. The selected consultant must be able to assess technical requirements, recommend scalable solutions, and contribute immediately to a complex, multi-agency implementation.

KEY RESPONSIBILITIES

• Design, configure, develop, and maintain Oracle EPM Cloud Planning applications supporting the DoD PPBE lifecycle.
• Build and maintain multidimensional planning models, dimensions, hierarchies, metadata, forms, dashboards, task lists, workflows, approval units, and security.
  Develop and optimize complex calculations, allocations, validations, and business rules using Calculation Manager, Essbase, Groovy, and MDX.
• Configure planning logic for budget formulation, annual financial plans, spend plans, funding distributions, phasing, forecasting, and plan-versus-actual comparisons.
• Design and support data integrations between Oracle EPM and DAI/Oracle EBS.
• Develop integrations using EPM Data Integration, Data Exchange, Data Management, REST APIs, EPM Automate, ODI, or other approved integration tools.
• Load and reconcile Oracle EBS financial data, including budgets, commitments, obligations, expenditures, disbursements, and general-ledger actuals.
• Develop metadata mappings and transformation logic for agency organizations, funds, appropriations, programs, projects, activities, object classes, fiscal periods, and other financial dimensions.
• Create and maintain EPM reports, dashboards, Smart View templates, management reports, and Narrative Reporting solutions.
• Implement validation controls, audit capabilities, error handling, logging, and reconciliation procedures to ensure data completeness and accuracy.
• Configure and administer role-based security, user provisioning, access controls, and separation-of-duties requirements.
• Support application snapshots, migrations, deployment packages, release management, environment refreshes, cloning, and disaster-recovery procedures.
• Develop reusable technical components and deployment standards to support implementation across multiple DoD agencies.
• Monitor application performance and optimize calculations, data loads, integrations, forms, reports, and Essbase queries.
• Troubleshoot application, calculation, data, integration, metadata, reporting, security, and performance issues.
• Coordinate issue resolution with Oracle Support, DAI teams, IBM/IntelliPoint personnel, infrastructure teams, and agency stakeholders.
• Support system integration testing, user acceptance testing, regression testing, performance testing, and production validation.
• Prepare technical design documents, configuration workbooks, interface specifications, deployment plans, runbooks, test scripts, and operating procedures.
• Provide technical knowledge transfer and support to functional consultants, agency administrators, and production-support teams.