Snowflake Architect

Job Description We are seeking a highly skilled Snowflake Architect with extensive experience in Snowflake, Azure, and Azure Data Factory (ADF) to join our growing team. This role will involve designing and implementing large-scale data solutions on the cloud platform, leading the architecture of the data ecosystem, and ensuring high levels of data integration, optimization, and governance. The ideal candidate will have a deep understanding of Snowflake data warehouse architecture and be ready to work closely with clients to deliver scalable data solutions. The role requires a leader who can guide teams and manage projects effectively while ensuring seamless integration of data systems across different platforms. Key Responsibilities: - Lead the design and architecture of data solutions using Snowflake and Azure technologies. - Oversee the development and optimization of ETL pipelines using Azure Data Factory (ADF), ensuring - smooth data movement, transformation, and integration. - Architect data workflows and ensure alignment with best practices for data governance, security, and - compliance. - Monitor, troubleshoot, and optimize data pipelines, ensuring performance, scalability, and reliability in - Snowflake and Azure environments. - Work closely with cross-functional teams to design end-to-end data solutions that meet business needs and - ensure seamless integration with existing systems. - Lead data validation efforts and ensure data integrity and quality across multiple systems. - Collaborate with stakeholders and clients to understand business requirements and deliver innovative - solutions in line with project goals and timelines. - Mentor and provide technical leadership to junior developers and team members, fostering a culture of - knowledge sharing and best practices. - Act as the primary architect for Snowflake solutions, ensuring they are scalable, secure, and perform - optimally. - Travel to client locations as necessary to support project delivery and engage with stakeholders on-site. - Skills and Qualifications: - 10+ years of hands-on experience in Snowflake architecture, Azure technologies, and data management. - Deep expertise in Snowflake architecture, data modeling, and data warehousing best practices. - Extensive experience with Azure Data Services (Azure Data Lake, Azure Synapse Analytics, etc.) and Azure - Data Factory (ADF). - Strong experience in designing and developing ETL processes, ensuring high performance and scalability in - cloud environments. - Proficiency in SQL, data modeling, and working with both structured and semi-structured data. - Strong understanding of data governance, data privacy, and security in cloud-based solutions. - Proven ability to solve complex problems and optimize data workflows for large-scale cloud environments. - Ability to collaborate and communicate effectively with both technical and non-technical teams. - Bachelor's degree in Computer Science, Information Technology, or a related field. - Excellent leadership and mentoring skills, with a proven track record of managing teams and projects - successfully. - Preferred Skills: - Experience with other Azure services such as Azure SQL Database, Power BI, and Azure Synapse Analytics. - Familiarity with data governance tools, data pipeline orchestration, and advanced data integration - techniques. - Strong expertise in performance tuning and query optimization in Snowflake. - Why Join Us: - Work with cutting-edge technologies like Snowflake, Azure, and ADF in the cloud data space. - Opportunity to work on complex, large-scale data projects across diverse industries. - Collaborative and innovative work environment that encourages continuous learning and professional - growth. - Competitive salary and benefits package. - Opportunities for career advancement and leadership roles within the organization. - Note: - The candidate must be willing to travel to client locations as part of project delivery and engagement.