Snowflake Consultant

Granite Solutions Groupe Inc

San Ramon, CA

JOB DETAILS
SKILLS
Access Control, Analysis Skills, Artificial Intelligence (AI), Atlassian JIRA, Best Practices, Business Model, Caching, Cloning, Communication Skills, Configuration Management, Consulting, Continuous Deployment/Delivery, Continuous Integration, Cookies, Cross-Functional, Data Analysis, Data Partitioning, Data Processing, Data Warehousing, Database Programming, Database Report Tools, DevOps, Diversity, Environmental Issues, Financial Services, Fortune 1000 Customers, Git, Human Capital, Identity Data Management, Knowledge Transfer, LinkedIn, Metadata, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Operations Planning, Oracle Database, Performance Tuning/Optimization, Problem Solving Skills, Project/Program Management, Proof of Concept, Query Optimization, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Scripting (Scripting Languages), ServiceNow, Snowflake Schema, Source Code/Configuration Management (SCM), Stored Procedures, Tableau, Team Player, Technical Writing, Test Plan/Schedule, Vendor/Supplier Diversity, Warehousing, Web Browsers
LOCATION
San Ramon, CA
POSTED
30+ days ago

Skip to content menu

About Us GSG Difference Our Purpose Our Values Contact Us Our Consultants Expertise Skillsets Careers Case Studies

About Our Firm: Granite Solutions Groupe

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 and display excellent communication skills. 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-like 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 401K. 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.

Contact Us

California Headquarters (415) 963-3999 26565 Agoura Road, #58 Calabasas, CA 91302

GSG Difference

Supplier Diversity Program Commitment to Community Careers Contact Us LinkedIn NGLCC Certified Diversity Supplier Terms of Service | Privacy Policy

This website use cookies to improve your experience. You accept the use of cookies by closing or dismissing this banner, by clicking a link or button, or by continuing to browse otherwise.

Cookie settings ACCEPT Privacy & Cookies Policy Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

Necessary Always Enabled Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

SAVE & ACCEPT

About the Company

G

Granite Solutions Groupe Inc

GSG provides recruiting and consulting solutions for the financial services industry. The company was founded in 1998 as a consulting firm. GSG now has 4 offices on 3 continents, with consultants deployed across the U.S. at Fortune 500 companies. We leverage our industry knowledge and passion for client priorities to deliver human capital solutions. GSG’s highly optimized recruiting and delivery model is designed to take projects from Vision to Execution efficiently and effectively. We view the world as our “bench”, and our continuous research process consistently identifies professionals with the right skills, motivations and career interests to deliver on client initiatives. GSG is different, and occupies the space between high volume staffing agencies and large national strategy and advisory firms. We deliver consultants that can ramp up quickly and execute. Our motto, “do the right thing, and then do the next right thing,” directly impacts the experience of our clients, consultants and employees. The entire GSG team takes pride in our ability to deploy top-tier talent, poised to roll up their sleeves and do the heavy lifting to deliver against long term strategic plans at a sustainable price point.
COMPANY SIZE
20 to 49 employees
INDUSTRY
Other/Not Classified
FOUNDED
1998
WEBSITE
http://www.granitesolutionsgroupe.com/