SQL SERVER DATA WAREHOUSE DEVELOPER

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 ...