Location
Dubai, United Arab Emirates, United Arab Emirates
Posted
July 21, 2026
Job Description
ROLE OVERVIEW
We are looking for a hands-on SQL Server Data Warehouse Developer to design and build a structured, production-grade data warehouse on Microsoft SQL Server. Data from Oracle Fusion has already been ingested into SQL Server via Python-based REST API pipelines. Your role is to take this raw ingested data and architect a robust Medallion (Bronze, Silver, Gold) layered warehouse, implement dimensional models, enforce data quality, and deliver clean, reliable data to the BI reporting layer.
This is a hands-on development role. You must be comfortable writing complex SQL, building stored procedures, designing fact and dimension tables, and owning data quality end-to-end.
KEY RESPONSIBILITIES
1. Bronze Layer — Raw Staging
- Receive raw ingested data from source SQL Server tables populated by the existing Python pipeline.
- Define and enforce primary keys, foreign keys, and constraints at the ...