About the Job:
Ready to apply for roles like this?
Unlock the company name and direct application link. Subscribers get instant access to fresh jobs across Dubai, Abu Dhabi and Riyadh, many with visa support.
Unlock employer & apply directly
The Data Engineer role at the company focuses on designing, building, and optimizing data pipelines and data products within the enterprise Data Lakehouse (DLH) hosted on Oracle Cloud Infrastructure (OCI). The engineer will collaborate with various business units, including actuarial, underwriting, and claims teams, to create new data assets, ingestion frameworks, and transformation pipelines that support analytics, regulatory reporting, and artificial intelligence/machine learning (AI/ML) initiatives.
Key Responsibilities:
- Build and maintain scalable data ingestion and transformation pipelines using OCI Data Flow, Oracle Data Integrator (ODI), and AI Data Platform (AIDP).
- Develop optimized data models and marts on Oracle Autonomous Data Warehouse (ADW) for analytics and downstream consumption.
- Manage structured and unstructured data in OCI Object Storage, ensuring efficient organization, lifecycle policies, and cost optimization.
- Implement Delta Lakehouse patterns for ingestion, curation, and consumption layers within the DLH.
- Collaborate with architects to design high-performance, reusable ingestion frameworks for new projects.
- Translate business requirements into technical specifications and data pipelines.
- Ensure data quality, lineage, and governance standards are integrated into all pipelines.
- Optimize performance of ETL/ELT jobs, SQL queries, and ADW workloads.
Good to Have:
- Experience with Oracle GoldenGate for real-time replication and change data capture (CDC) pipelines.
Required Skills & Experience:
- Strong hands-on experience with OCI services:
- Autonomous Data Warehouse (ADW)
- Object Storage
- Data Flow (Apache Spark on OCI)
- Oracle Data Integrator (ODI)
- AI Data Platform (AIDP)
- Solid SQL and Python development and performance tuning skills.
- Understanding of insurance domain data (policies, claims, finance, underwriting) is an advantage.
- Experience building data pipelines in cloud environments, preferably OCI.
- Familiarity with Delta Lakehouse concepts, medallion architecture, and data versioning.
- Good communication skills and the ability to work with cross-functional teams.
