Azure Data Architect

Weekday AI (YC W21); Bengaluru; On-site; INR 1,500,000 - 1,900,000; Full time

Job summary

Weekday AI seeks an experienced data migration architect to lead the end-to-end migration of Azure Synapse Analytics environments to Microsoft Fabric. You will develop migration strategies, design governance, and build scalable data pipelines to support enterprise-grade analytics across on-prem and cloud data assets.

Required 7+ years of hands-on experience in Azure Synapse migrations, strong SQL Server and T-SQL skills, and expertise with ADLS Gen2, CosmosDB, and Azure Data Factory.

Qualifications

• 7+ years of experience with Azure Synapse to Fabric migrations and related planning.
• Strong SQL Server and T-SQL proficiency.
• Hands-on ETL/data engineering using Azure Data Factory and Databricks.
• Experience with ADLS Gen2, CosmosDB, and governance tools.

Responsibilities

• Lead end-to-end migration of Azure Synapse Analytics to Microsoft Fabric with minimal business disruption.
• Develop migration strategies including planning, execution, validation, cutover, and post-migration optimization.
• Implement and optimize data pipelines using Azure Data Factory, Databricks, and related ETL technologies.
• Design, model, and maintain modern data warehousing leveraging SQL Server, ADLS Gen2, CosmosDB, and Blob storage.
• Monitor, troubleshoot, and tune performance of data integration and analytics solutions.
• Collaborate with cross-functional teams to ensure data integrity, security, and compliance.
• Utilize Purview and Azure Monitoring for governance, lineage, and observability.
• Document architecture, processes, and best practices for knowledge transfer.

Skills

Azure Synapse Analytics

SQL Server

T-SQL

Python

Databricks

CosmosDB

Azure Data Factory

Azure Data Lake Storage Gen2

Azure Monitoring

Purview

Data Explorer

Event Hub

Logic App

Microsoft Fabric

Education

Bachelor's degree in CS/IT/Data Engineering

Microsoft Certified: Azure Solutions Architect Expert

Microsoft Certified: Azure Data Engineer Associate

Tools

Azure Data Factory

Databricks

CosmosDB

ADLS Gen2

Microsoft Purview

Azure Monitor

Data Explorer

Job description

This role is for one of Weekday's clients

Min Experience: 7+ years

Location: Bengaluru, Karnataka, India, Pune, Gurugram, Haryana, India

JobType: full-time

Experience Range: 7 to 10 years of experience, including substantial hands-on expertise delivering Azure Synapse Analytics to Microsoft Fabric migration projects, with direct involvement in migration planning, execution, validation, performance tuning, cutover, and post-migration optimization.

Requirements

Key Responsibilities

• Lead the end-to-end migration of Azure Synapse Analytics environments to Microsoft Fabric, ensuring seamless transition and minimal business disruption
• Develop comprehensive migration strategies encompassing planning, execution, validation, cutover, and post-migration optimization
• Implement and optimize data pipelines using Azure Data Factory, Databricks, and related ETL technologies to support migration and ongoing operations
• Design, model, and maintain modern data warehousing solutions leveraging SQL Server, Azure Data Lake Storage Gen2, CosmosDB, and Blob storage
• Monitor, troubleshoot, and tune the performance of data integration and analytics solutions throughout the migration lifecycle
• Collaborate with cross-functional teams to ensure data integrity, security, and compliance across all stages of the migration
• Utilize Azure Monitoring and Purview to ensure robust governance, lineage, and observability of data assets during and after migration
• Document architecture, processes, and best practices to support knowledge transfer and operational excellence post-migration

Required Skills

• Hands-on experience with Azure Synapse Analytics to Microsoft Fabric migration projects
• Advanced proficiency in SQL Server and T-SQL
• Expertise in Azure Data Factory for ETL pipeline development
• In-depth knowledge of Azure Data Lake Storage Gen2 (ADLS Gen2)
• Experience with CosmosDB for data modeling and integration
• Strong skills in Python for data engineering tasks
• Proficiency in Databricks and Stream Analytics
• Experience with Event Hub and Logic App for event-driven data architectures
• Expertise in Microsoft Purview for data governance
• Working knowledge of Azure Monitoring and Data Explorer

Preferred Skills

• Experience with advanced data orchestration in Microsoft Fabric
• Knowledge of cloud-native data platform architectures
• Expertise in implementing stored procedures for complex data transformation
• Familiarity with large-scale data environment management

Desired Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline
• Microsoft Certified: Azure Solutions Architect Expert or equivalent certification
• Microsoft Certified: Azure Data Engineer Associate or similar certification

Must-have Skills

Microsoft Azure, Synapse, Fabric

Good-to-have Skills

PySpark, SQL, ETL