Data Architect

As an Azure/Snowflake Data Architect at our company, you will play a crucial role in designing and implementing end-to-end data solutions on the Microsoft Azure platform. Your deep expertise in Azure Data Factory, SQL, Oracle, and Snowflake will be instrumental in creating 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:** - Advanced experience in pipeline design, mapping data flows, and orchestration using Azure Data Factory (ADF). - Strong knowledge of distributed querying, data warehousing, and performance optimization with Azure Synapse Analytics. - Deep experience in writing complex queries, stored procedures, and query optimization using SQL Server (T-SQL). - Experience in designing and maintaining ETL workflows with SSIS (SQL Server Integration Services). - Strong understanding of data architecture principles, data modeling, and data lakehouse patterns. - Familiarity with Azure Storage (Blob, Data Lake) and Azure DevOps CI/CD pipelines. - Experience 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:** - 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.,