Azure Consultant (Data Warehouse & ETL)

Job Title:

Location:

Duration:

Job Summary:

We are seeking an experienced Azure Consultant with strong expertise in Data Warehousing, ETL processes, and MS SQL development. The ideal candidate will be responsible for designing and implementing data integration solutions, optimizing data pipelines, and working extensively with SQL Server to develop stored procedures, facts, and dimension tables for business intelligence and analytics purposes.

Key Responsibilities:

• Design and implement Data Warehouse solutions on Azure.
• Develop and optimize ETL workflows using Azure Data Factory or similar tools.
• Write complex T-SQL queries and stored procedures for data processing and transformation.
• Create and manage fact and dimension tables for reporting and analytics.
• Collaborate with business stakeholders to understand data requirements and deliver solutions.
• Ensure best practices in data governance, security, and performance tuning.

Required Skills & Experience:

• Strong experience with

  Azure Data Services

  (Azure SQL Database, Azure Synapse, Azure Data Factory).
• Hands-on expertise in

  ETL development

  and Data Warehouse concepts.
• Proficiency in

  MS SQL Server

  including writing stored procedures, functions, triggers, and performance optimization.
• Experience creating and managing

  fact and dimension tables

  for analytics solutions.
• Excellent problem-solving and analytical skills.

Preferred Skills (Nice to Have):

• Knowledge of Power BI or other reporting tools.
• Experience with CI/CD and DevOps practices for data solutions.