Data Engineer OCI Data Lakehouse (DLH) Projects

About the role

We are seeking a highly skilled Data Engineer to join our Data Management Office and drive Oracle Cloud Infrastructure (OCI) Data Lakehouse initiatives. The role focuses on designing, developing and optimizing scalable data pipelines and data products that enable analytics, regulatory reporting and AI/ML innovation across multiple business domains.

Key responsibilities

• Design, build and maintain scalable data ingestion, transformation and orchestration pipelines using OCI Data Flow, Oracle Data Integrator (ODI) and AIDP.
• Develop robust ETL/ELT processes to support enterprise data integration and analytics requirements.
• Implement and manage Delta Lakehouse architectures, including ingestion, curation and consumption layers.
• Design and optimise analytical data models, data marts and datasets on Oracle Autonomous Data Warehouse (ADW).
• Collaborate with Actuarial, Underwriting, Claims, Finance and Business teams to translate requirements into reusable data products.
• Manage structured and unstructured datasets in OCI Object Storage, applying lifecycle, governance and cost‑optimisation strategies.
• Partner with data architects to embed data quality, lineage, metadata management and governance controls into all pipelines.
• Tune SQL workloads, Spark jobs and ADW performance, monitoring efficiency and resolving bottlenecks.

Required profile

• Minimum 7 + years of experience in data engineering and enterprise data platforms.
• Proven ability to work with cross‑functional stakeholders and deliver high‑value data assets.
• Strong understanding of data lakehouse concepts and Oracle Cloud services.

Required skills

• OCI Data Flow
• Oracle Data Integrator (ODI)
• AIDP
• Delta Lakehouse
• Oracle Autonomous Data Warehouse (ADW)
• OCI Object Storage
• SQL
• Apache Spark
• ETL / ELT processes
• Data modeling
• Data governance
• Metadata management
• Performance tuning