Snowflake Consultant
Granite Solutions Groupe, San Francisco, California, United States, 94199
Consultant, Software Development
Granite Solutions Groupe provides financial services decision makers with people and solutions that deliver. Our clients count on us to deliver the right talent at the right time to achieve critical business results. We leverage our industry knowledge and passion for client priorities to deliver human capital solutions.
GSG was founded in 1998 as a consulting firm delivering project management and technology solutions for the financial services industry. GSG now has a global presence, with team members deployed across the U.S. at Fortune 1000 companies and high‑performing Fintech firms.
High‑caliber consultants are the face of GSG at our client organizations and offices. We value the deep relationships we have with our consultants that enable us to place them in roles where their skills will have an immediate impact. The GSG consulting team is comprised of diverse, experienced, driven, and dynamic contributors who excel at getting things done.
About the Opportunity We are looking for a Senior Snowflake Developer with a minimum of 10 years of experience in database development and 4–5 years of experience in Snowflake development and administration. This role involves leading the design, development, testing, deployment, and optimization of data warehouse solutions on the Snowflake platform.
The position requires close collaboration with data and application teams to deliver scalable, secure, and enterprise‑grade data solutions. Deep expertise in Snowflake architecture, performance tuning, and strategic implementation is essential.
Candidate should be local and work from offices in San Francisco or San Ramon.
Responsibilities
Design, develop, test, deploy, and maintain enterprise‑grade applications using Snowflake.
Optimize Snowflake SQL queries, stored procedures, and transformation logic for performance and cost‑efficiency.
Be the subject master expert on Snowflake and communicate effectively with other development teams.
Manage Snowflake configurations including resource monitors, virtual warehouses, stages, integrations, and role‑based access controls.
Implement best practices for partitioning, clustering, caching, and query performance tuning (e.g., Query Profiler, micro‑partition pruning, data spilling).
Experience with semantic layer tools such as dbt Semantic Layer is a plus.
Utilize Cortex AISQL to embed AI operations directly into SQL for multimodal data analysis.
Utilize SnowConvert to migrate SQL scripts from platforms like SQL Server or Oracle to Snowflake.
Automate data ingestion, metadata management, and monitoring using Snow SQL, Snow Pipes, Streams, Tasks, and Dynamic Tables.
Support CI/CD and DevOps workflows using tools like Redgate Flyway and Git for version control and pipeline orchestration.
Integrate Snowflake with reporting and data processing tools such as SSRS and Tableau.
Stay current with Snowflake innovations and lead proof‑of‑concepts for new features.
Create technical documentation and knowledge transfer plans for operational teams.
Requirements
10+ years of experience in database development, data engineering, or analytics.
4+ years of hands‑on experience with Snowflake architecture & development.
Strong proficiency in SQL and Snow SQL scripting.
Extensive experience with T‑SQL stored procedures and complex query development.
Deep understanding of Snowflake internals, including Time Travel, Zero Copy Cloning, Streams, Tasks, and Dynamic Tables.
Familiarity with Snowflake Intelligence for natural language querying and agentic AI workflows.
Expertise in identity and access management, data masking, and other security best practices.
Proven ability to resolve performance and scalability issues in Snowflake environments.
Solid grasp of data warehousing concepts, data modeling, and metadata management.
Preferred Qualifications
SnowPro Advanced Architect or Advanced Data Engineer certification.
Experience with Azure cloud services including Azure SQL MI, ADLS, and Azure Data Factory.
Familiarity with tools such as Jira, ServiceNow, Confluence, and Azure DevOps.
Experience with Semantic Views and Gen2 Warehouses for enhanced performance and business logic modeling.
Excellent communication skills and ability to collaborate with cross‑functional technical and business teams.
Employee Benefits GSG is excited to offer its consultants excellent compensation and a robust option of benefits which include comprehensive medical, dental, vision and prescription coverage. You will receive company‑paid life insurance. In addition, we hope you will take advantage of eligible commuter benefits—paying for work‑related public transit and parking with pre‑tax dollars. Save for your retirement with pre‑tax contributions that go directly into your 401(k). We also care about your pets with several options for pet insurance, discount card and prescriptions.
GSG’s Commitment to Diversity As a diverse‑owned business, GSG is committed to creating a diverse workforce, and we are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
#J-18808-Ljbffr
GSG was founded in 1998 as a consulting firm delivering project management and technology solutions for the financial services industry. GSG now has a global presence, with team members deployed across the U.S. at Fortune 1000 companies and high‑performing Fintech firms.
High‑caliber consultants are the face of GSG at our client organizations and offices. We value the deep relationships we have with our consultants that enable us to place them in roles where their skills will have an immediate impact. The GSG consulting team is comprised of diverse, experienced, driven, and dynamic contributors who excel at getting things done.
About the Opportunity We are looking for a Senior Snowflake Developer with a minimum of 10 years of experience in database development and 4–5 years of experience in Snowflake development and administration. This role involves leading the design, development, testing, deployment, and optimization of data warehouse solutions on the Snowflake platform.
The position requires close collaboration with data and application teams to deliver scalable, secure, and enterprise‑grade data solutions. Deep expertise in Snowflake architecture, performance tuning, and strategic implementation is essential.
Candidate should be local and work from offices in San Francisco or San Ramon.
Responsibilities
Design, develop, test, deploy, and maintain enterprise‑grade applications using Snowflake.
Optimize Snowflake SQL queries, stored procedures, and transformation logic for performance and cost‑efficiency.
Be the subject master expert on Snowflake and communicate effectively with other development teams.
Manage Snowflake configurations including resource monitors, virtual warehouses, stages, integrations, and role‑based access controls.
Implement best practices for partitioning, clustering, caching, and query performance tuning (e.g., Query Profiler, micro‑partition pruning, data spilling).
Experience with semantic layer tools such as dbt Semantic Layer is a plus.
Utilize Cortex AISQL to embed AI operations directly into SQL for multimodal data analysis.
Utilize SnowConvert to migrate SQL scripts from platforms like SQL Server or Oracle to Snowflake.
Automate data ingestion, metadata management, and monitoring using Snow SQL, Snow Pipes, Streams, Tasks, and Dynamic Tables.
Support CI/CD and DevOps workflows using tools like Redgate Flyway and Git for version control and pipeline orchestration.
Integrate Snowflake with reporting and data processing tools such as SSRS and Tableau.
Stay current with Snowflake innovations and lead proof‑of‑concepts for new features.
Create technical documentation and knowledge transfer plans for operational teams.
Requirements
10+ years of experience in database development, data engineering, or analytics.
4+ years of hands‑on experience with Snowflake architecture & development.
Strong proficiency in SQL and Snow SQL scripting.
Extensive experience with T‑SQL stored procedures and complex query development.
Deep understanding of Snowflake internals, including Time Travel, Zero Copy Cloning, Streams, Tasks, and Dynamic Tables.
Familiarity with Snowflake Intelligence for natural language querying and agentic AI workflows.
Expertise in identity and access management, data masking, and other security best practices.
Proven ability to resolve performance and scalability issues in Snowflake environments.
Solid grasp of data warehousing concepts, data modeling, and metadata management.
Preferred Qualifications
SnowPro Advanced Architect or Advanced Data Engineer certification.
Experience with Azure cloud services including Azure SQL MI, ADLS, and Azure Data Factory.
Familiarity with tools such as Jira, ServiceNow, Confluence, and Azure DevOps.
Experience with Semantic Views and Gen2 Warehouses for enhanced performance and business logic modeling.
Excellent communication skills and ability to collaborate with cross‑functional technical and business teams.
Employee Benefits GSG is excited to offer its consultants excellent compensation and a robust option of benefits which include comprehensive medical, dental, vision and prescription coverage. You will receive company‑paid life insurance. In addition, we hope you will take advantage of eligible commuter benefits—paying for work‑related public transit and parking with pre‑tax dollars. Save for your retirement with pre‑tax contributions that go directly into your 401(k). We also care about your pets with several options for pet insurance, discount card and prescriptions.
GSG’s Commitment to Diversity As a diverse‑owned business, GSG is committed to creating a diverse workforce, and we are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
#J-18808-Ljbffr