Review and enhance the on-premises Data Warehouse environment and lead in the enhancement of the data warehouse performance, ETL / ELT optimizations, query optimizations, data partitioning, delta tables and capacity management
Architecture & Design:
Design and maintain a Modern Data Architecture using Microsoft Fabric, Azure Data Lake, OneLake, Synapse, Databricks, and Power BI etc.
Develop and enforce Medallion Architecture standards
Architect scalable ingestion pipelines for batch, streaming, and real-time data.
Define data modelling standards (star schema, modelling, semantic models).
Data Engineering & Integration:
Oversee ingestion from operational systems, APIs, databases, and third-party sources.
Implement ETL/ELT pipelines using Fabric Data Factory, Azure Data Factory. Synapse Pipelines and Databricks