Senior Snowflake Admin Architect - Intellectt INC

Poistion-Senior Snowflake Admin Architect

Location-Boston, MA

• Lead the data migration from SQL Server to Snowflake, ensuring smooth transition and best practices.
• Assess the current data infrastructure and identify the most appropriate solutions for the migration.
• Design and implement scalable data architecture and models within Snowflake.
• Collaborate with stakeholders to gather requirements, define scope, and set a clear migration roadmap.
• Establish data governance, security protocols, and performance optimizations for the Snowflake environment.
• Serve as the technical and strategic advisor to leadership, providing insights into Snowflake capabilities.
• Inspire and mentor team members, encouraging alignment with project goals.
• Work hands-on with data modeling, architecture, ETL/ELT pipelines, and Snowflake administration.
• Present technical findings and solutions to both technical and non-technical stakeholders.

• Proven experience with Snowflake architecture, administration, and data migration projects.
• Strong background in SQL Server and expertise in data migration to Snowflake.
• Proficiency in data modeling, data warehousing, and database design.
• Hands-on experience with ETL/ELT processes, using tools like Informatica, DBT, or Apache NiFi.
• Strong understanding of cloud platforms such as AWS, Azure, or GCP (especially in the context of Snowflake).
• Excellent interpersonal, leadership, and presentation skills must be able to communicate complex technical concepts effectively.
• Ability to work independently, problem-solve, and drive discovery processes with minimal oversight.
• Experience in setting up governance, security, and performance tuning in Snowflake.
• Experience working with various stakeholders, including business leaders, data engineers, and analysts.