Job Summary:

We are seeking a highly experienced Azure Data Architect with deep expertise in designing and implementing end-to-end data solutions on the Microsoft Azure platform. The ideal candidate will have a strong background in SQL Server, SSIS, Azure Data Factory (ADF), and Azure Synapse Analytics, with the ability to architect scalable, secure, and high-performance data pipelines for enterprise-level environments.

Key Responsibilities:

Design, develop, and implement data architecture solutions leveraging Azure Data Factory, Azure Synapse, and SQL Server.

Define and manage data integration, ETL/ELT frameworks, and data modeling strategies.

Architect and optimize data pipelines for performance, scalability, and reliability across multiple data sources.

Collaborate with business stakeholders, BI developers, and data engineers to align data solutions with business goals.

Oversee data migration and modernization from on-premises systems to Azure Cloud.

Implement data governance, security, and compliance best practices for cloud data environments.

Guide and mentor technical teams on best practices in Azure data services, performance tuning, and pipeline orchestration.

Stay updated with the latest Azure and data engineering advancements to recommend process improvements.

Technical Skills Required:

Azure Data Factory (ADF) – advanced experience in pipeline design, mapping data flows, and orchestration.

Azure Synapse Analytics – strong knowledge of distributed querying, data warehousing, and performance optimization.

SQL Server (T-SQL) – deep experience in writing complex queries, stored procedures, and query optimization.

SSIS (SQL Server Integration Services) – experience in designing and maintaining ETL workflows.

Strong understanding of data architecture principles, data modeling, and data lakehouse patterns.

Experience with Azure Storage (Blob, Data Lake) and Azure DevOps CI/CD pipelines.

Familiarity with Power BI integration, Azure Databricks, and Python or Scala for data transformations is a plus.

Soft Skills:

Excellent problem-solving and analytical skills.

Strong communication and stakeholder management.

Proven experience leading data projects and technical teams.

Ability to work in agile and fast-paced environments.

Educational Qualifications:

Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Engineering, or related field.

Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect Expert certification preferred.