SQL Server Data Warehouse Developer - 6 Months

Transguard Workforce Solutions is the UAE’s leading provider of unique and innovative HR solutions. With a decade of experience in the region and a team that possesses extensive knowledge of the market, we provide a fully integrated HR solution. We are currently recruiting a SQL Server Data Warehouse Developer for a 6-month contract with our client in Abu Dhabi, UAE Job Summary: To design, develop, and maintain a scalable, production-grade data warehouse on Microsoft SQL Server. The successful candidate will transform raw data ingested from Oracle Fusion into a structured Medallion Architecture (Bronze, Silver, Gold), ensuring high data quality, robust governance, and optimized reporting for Power BI and SSAS. This is a hands-on development role requiring strong expertise in T-SQL, data warehousing, dimensional modeling, ETL processes, and performance optimization. Job Responsibilities: 1.Data Warehouse Development • Design and implement Bronze, Silver, and Gold data warehouse layers on SQL Server. • Develop and maintain fact tables, dimension tables, and star schema models. • Build and optimize stored procedures, views, functions, and ETL processes. • Implement incremental loading using watermark-based logic and MERGE/UPSERT techniques. • Develop SCD Type 1 and Type 2 dimension management processes. 2.Data Quality & Governance • Establish and maintain data quality controls, validation rules, and reconciliation processes. • Create error logging and audit frameworks to track data issues and load history. • Enforce data integrity through primary keys, foreign keys, constraints, and business rules. • Document data lineage, source-to-target mappings, and technical specifications. 3.Performance & Reporting • Optimize SQL queries, indexing strategies, and database performance. • Develop reporting-ready datasets, views, and aggregation layers for Power BI and SSAS. • Support BI teams by ensuring data models align with reporting and analytics requirements. • Maintain technical documentation, runbooks, and data dictionaries. Job Requirements: • 5+ years of hands-on SQL Server development in a data warehousing environment. • Proven experience building enterprise data warehouse solutions and layered architectures. • Strong experience designing and maintaining reporting-ready data models. • Demonstrated ability to develop scalable, high-performance SQL solutions. • Strong expertise in Microsoft SQL Server (2016+) and T-SQL. • Familiarity with Power BI reporting environments. • Experience using Git/version control and Agile delivery methodologies. Should have Advanced knowledge of: • Complex joins, CTEs, window functions, and subqueries • Stored procedures, views, functions, and triggers • MERGE/UPSERT statements and incremental loading • Indexing, query tuning, and performance optimization • Experience with: • Data warehousing and dimensional modeling • Medallion Architecture (Bronze, Silver, Gold) • Fact and dimension table design • SCD Type 1 & Type 2 implementation • Data quality frameworks, audit logging, and reconciliation controls Nice to Have: • Exposure to Oracle Fusion data models (Finance, Supply Chain, Procurement). • Knowledge of SSAS Tabular Models. • Experience with Python-based data orchestration tools such as Prefect. Show more Show less