Data Architect - Azure/Snowflake DB

As an Azure/Snowflake Data Architect, you will be responsible for designing and implementing end-to-end data solutions on the Microsoft Azure platform. Your expertise in SQL Server, SSIS, Azure Data Factory (ADF), and Azure Synapse Analytics will be crucial in architecting scalable, secure, and high-performance data pipelines for enterprise-level environments. **Key Responsibilities:** - Design, develop, and implement data architecture solutions using 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 from 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:** - Advanced experience in Azure Data Factory (ADF) for pipeline design, mapping data flows, and orchestration. - Strong knowledge of distributed querying, data warehousing, and performance optimization in Azure Synapse Analytics. - Deep experience in SQL Server (T-SQL) for writing complex queries, stored procedures, and query optimization. - Experience in designing and maintaining ETL workflows using SSIS (SQL Server Integration Services). - Understanding of data architecture principles, data modeling, and data lakehouse patterns. - Familiarity with Azure Storage (Blob, Data Lake), Azure DevOps CI/CD pipelines, Power BI integration, and optional skills in Azure Databricks, Python, or Scala for data transformations. **Soft Skills:** - Excellent problem-solving and analytical skills. - Strong communication and stakeholder management abilities. - Proven experience in leading data projects and technical teams. - Ability to work effectively in agile and fast-paced environments. **Educational Qualifications:** - Bachelors or Masters degree in Computer Science, Information Technology, Data Engineering, or related field. - Microsoft Certified: Azure Data Engineer Associate or Azure Solutions Architect Expert certification preferred. Please note that the above job description is based on the provided details without any additional information about the company.,