DAI Databricks Data Engineer

CACI International

3d•$75,200 - $158,100

About The Position

The Databricks Data Engineer will work on an Oracle E-Business Suite (EBS) integrated project team supporting a Department of War multi-Agency program. The role involves designing, developing, and optimizing data pipelines and analytics solutions for business intelligence reporting based on a federal enterprise Oracle ERP implementation. It combines modern data engineering with ERP financials expertise to provide reliable, scalable insights for federal stakeholders under strict security and compliance requirements. The team emphasizes complex problem solving and communication, and offers opportunities to grow while supporting changes in government software delivery. The position requires building and maintaining Databricks and Spark pipelines, integrating Oracle EBS modules, and ensuring data quality and traceability across reporting layers. The engineer will collaborate with Oracle EBS subject matter experts, apply federal governance and compliance controls, and document technical approaches for government review and audits.

Requirements

Bachelor’s degree or equivalent.
Seven years of Oracle ERP implementation and sustainment experience.
At least five years of hands-on experience with Databricks data model design, development, and integration.
Experience integrating Oracle EBS (R12 / Oracle ERP Cloud) into modern data platforms.
Proficiency writing optimized SQL and developing with Python and Spark transformations.
Understanding of ETL orchestration tools and methodologies.
Familiarity with data security, audit requirements, access controls, and PII handling in regulated programs.
Ability to interpret EBS data structures, including AP, AR, GL, PO, PA, INV, and HR.
Must be a U.S. citizen and able to obtain an IT-2 background investigation.

Nice To Haves

Experience with Oracle EBS OAF tables, ESSBASE cubes, or Oracle SaaS reporting APIs.
Knowledge of Advana, DAI, or other DoD financial/ERP ecosystems.
Experience working in Federal / DoD / DoW environments, including secure cloud enclaves.
Experience supporting audit readiness, traceability, and FOIA-compliant data products.
Familiarity with Databricks ML and AI tools/workflows.
Experience with Agile/SAFe methodologies.

Responsibilities

Build and maintain scalable Databricks/Spark ETL pipelines sourcing data from Oracle EBS.
Develop ELT/ETL jobs integrating EBS modules including Financials, Purchasing, Projects, and HR.
Ensure data quality, lineage, validation, and reconciliation between EBS and reporting layers.
Partner with functional Oracle EBS subject matter experts to translate federal business processes into robust data models.
Apply federal data governance, cybersecurity, and compliance controls.
Document integration patterns, data flows, and technical procedures for government review and audit needs.