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

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