Snowflake Consultant

Required Skills & Experience

• 3-5+ years of hands-on Snowflake experience; deeper production expertise is strongly preferred. o Demonstrated experience implementing Snowflake solutions in production environments.
• Advanced SQL development skills, including the ability to create, troubleshoot, and maintain complex scripts.
• Experience designing and building data warehouses and/or data lakes.
• Ability to manage end-to-end implementation activities, from data ingestion and database configuration through deployment and support.
• Strong understanding of database architecture principles, data modeling concepts, and implementation best practices.
• Ability to work independently, solve complex technical problems, and drive project deliverables.

Nice to Have Skills & Experience

• Experience configuring Snowflake security, user roles, permissions, and data access controls.
• Experience migrating data warehouse workloads from Amazon Redshift to Snowflake.
• Knowledge of ETL/ELT processes and hands-on experience supporting data migration projects.
• Experience with Sigma and/or Amazon QuickSight.

Job Description

Insight Global is seeking a hands-on Snowflake Consultants to support multiple data warehouse and data lake initiatives. In this role, you will implement Snowflake solutions, build and maintain databases, develop advanced SQL scripts, ingest data, establish access controls, and support continued expansion of the data platform across multiple departments. The engagement is expected to last approximately 6-12 months, with the potential for longer-term project work based on performance, project success, and future roadmap needs.

Key Responsibilities

• Implement and maintain Snowflake-based data warehouse and data lake solutions in production environments.
• Create, maintain, and optimize SQL scripts for database setup, data ingestion, transformation, and ongoing platform operations.
• Load and manage data from source files and S3-based sources within Snowflake environments.
• Configure and administer user roles, permissions, data access, and visibility controls.
• Support automated data refreshes, nightly data loads, and reliable operational processes.
• Collaborate with internal teams on data architecture, implementation, and platform expansion decisions.
• Assist with migration initiatives, including moving existing data warehouse workloads from Amazon Redshift to Snowflake.
• Support integrations with reporting and analytics platforms, including Sigma and Amazon QuickSight where applicable.
• Develop scalable, reusable solutions that can be deployed across multiple departments and environments.
• Provide practical architectural guidance while remaining hands-on throughout implementation and delivery.