Responsibilities:
• Lead the assessment, documentation, and re-architecture of the legacy ETL integration layer connecting Oracle EBS to Oracle Cloud EPM.

• Design and implement a modern integration architecture using Oracle Data Management, EPM Automate, and an ETL tool (Databricks or Oracle-native equivalent).

• Own the end-to-end data flow - metadata governance through EDM, transactional actuals through Data Management, and reporting outputs through OAS/OAC.

• Resolve the structural BSS/EPM hierarchy mismatch that is causing parent-level OAS reporting failures.

• Drive EDM implementation as the metadata governance hub.

• Establish proper dependency management, job monitoring, alerting, and error handling across all agency data loads.

• Collaborate directly with agency technical leads, the DBA team and Oracle Support on infrastructure-level issues.

• Produce and present program documentation and briefings to PMO leadership.

Qualifications:

• Bachelor’s degree or equivalent
•  10+ years in enterprise application integration, including 5+ years in the Oracle ecosystem
•  5+ years of DoD/Federal financials and sustainment experience
•  Hands on Oracle integration expertise—able to architect and build (not just advise)
•  Experience as a solution architect implementing and supporting complex Oracle EPM solutions
•  Oracle Data Management (EDM/DRM): building integration rules, data loads, and metadata transformations
•  Oracle EBS integration: sourcing GL, Projects, and Purchasing data into downstream planning/analytics systems
•  Oracle EPM Automate: scripting, scheduling, chaining, and orchestration of Cloud EPM jobs
•  Oracle Analytics Server / OBIEE: understanding star schemas, EPM data exposure, and hierarchy alignment
•  Enterprise Data Management (EDM): implementing or governing metadata distribution across EPM applications
•  Integration technologies: JDBC connectivity, REST/SOAP APIs, Unix/Linux scripting, SQL/PLSQL
•  ETL tools: experience with Databricks, ODI, Informatica, or similar
•  Ability to read, maintain, and modernize legacy scripts and PL/SQL packages
•   Strong documentation and presentation skills for program-level solution architecture
•    Must be a U.S. citizen and able to obtain an IT II background investigation.

Desired:
• Oracle Cloud EPM Planning: Essbase concepts (BSO, Hybrid BSO, ASO), dimension design, and data mapping
• Groovy scripting for business rules, automation, and save rules within Oracle EPM
• Oracle Cloud Infrastructure (OCI): tenancy, OAM/OID configuration
• Experience supporting DoD financial programs (DoW, DLA, or similar defense agencies)
•  Familiarity with PPBE budget cycles, fund accounting, and NGRMS reporting
• Experience with DoW SDLC processes: gated reviews, Dimensions, change management workflows.

Pay Range:

There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is: