Senior Data Engineer - Snowflake & Azure

Granite Solutions Groupe Inc

San Ramon, CA

JOB DETAILS
SKILLS
Analysis Skills, Artificial Intelligence (AI), Atlassian JIRA, Best Practices, Caching, Cloning, Cloud Computing, Communication Skills, Configuration Management, Consulting, Continuous Deployment/Delivery, Continuous Integration, Cookies, Data Analysis, Data Management, Data Warehousing, Database Extract Transform and Load (ETL), Database Programming, DevOps, Diversity, Financial Services, Fortune 1000 Customers, Git, HTTP (HyperText Transport Protocol), Human Capital, Identify Issues, Identity Data Management, Information/Data Security (InfoSec), Knowledge Transfer, LinkedIn, Metadata, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Operations Planning, Oracle Database, Problem Solving Skills, Production Systems, Project/Program Management, Proof of Concept, SQL (Structured Query Language), SQL Databases, SQL Server Reporting Services (SSRS), Secure/SSH File Transfer Protocol (SFTP), Server Side Internet Programming, ServiceNow, Short Messaging Service (SMS), Snowflake Schema, Software Development, Source Code/Configuration Management (SCM), Stored Procedures, Tableau, Technical Writing, Test Plan/Schedule, Vendor/Supplier Diversity, Warehousing, Web Browsers, Wireless Multimedia Messaging Service
LOCATION
San Ramon, CA
POSTED
7 days ago

Skip to content

menu

  • About Us

  • GSG Difference

  • Our Purpose

  • Our Values

  • Contact Us

  • Our Consultants

  • Expertise

  • Skillsets

  • Careers

  • Case Studies

Senior Data Engineer - Snowflake & Azure

Job Category: Information Technology

Job Location:San Francisco, CA; San Ramon, CA

Consultant, Software Development

About Our Firm:

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're looking for a Senior Data Engineer - Snowflake & Azure with 10+ years of experience in database development and data engineering, including 4-5 years hands-on with Snowflake and building production data pipelines on Azure. The role covers the full data platform stack: Snowflake architecture and development, Azure Data Factory pipelines, cloud integration patterns, and CI/CD practices. The position requires close collaboration with data architects, application engineers, and business stakeholders across our San Francisco and San Ramon offices.

Note: Candidate should be local and work from one of our offices in San Francisco or San Ramon.

Responsibilities:

  • Design, develop, test, deploy, and maintain enterprise-grade data solutions on Snowflake and Azure.
  • Build and optimize ADF pipelines for ETL, data ingestion, and end-to-end orchestration between on-premises and cloud systems.
  • Configure and manage Azure Integration Runtime and Self-Hosted Integration Runtime (SHIR) for secure on-premises data movement.
  • Ingest and transform data from diverse sources including SFTP, File Shares, HTTP, SQL databases, Snowflake, and ADLS Gen2.
  • Write and optimize Snowflake SQL, stored procedures, and transformation logic for performance and cost efficiency.
  • Implement Snowflake best practices: clustering, partitioning, caching, micro-partition pruning, and Query Profiler-based tuning.
  • Manage Snowflake configurations including virtual warehouses, resource monitors, stages, integrations, and RBAC.
  • Automate data ingestion and metadata workflows using SnowSQL, Snowpipe, Streams, Tasks, and Dynamic Tables.
  • Develop Azure Function Apps for event-driven data integration scenarios.
  • Support CI/CD workflows using Flyway, Git, and Azure DevOps for version control and pipeline deployment.
  • Integrate Snowflake with reporting tools including SSRS and Tableau.
  • Use Cortex AI/SQL to embed AI operations directly into SQL for multimodal data analysis.
  • Use SnowConvert to migrate SQL scripts from SQL Server or Oracle to Snowflake.
  • Stay current with Snowflake and Azure developments; lead proof-of-concepts for new capabilities.
  • Write technical documentation and knowledge transfer plans for operational teams.

Requirements:

  • 10+ years in database development, data engineering, or analytics.
  • 5+ years of hands-on Snowflake development and administration.
  • 4-5 years building and maintaining ADF pipelines in production Azure environments.
  • Strong SQL and SnowSQL proficiency; extensive T-SQL stored procedure experience.
  • Deep knowledge of Snowflake internals: Time Travel, Zero Copy Cloning, Streams, Tasks, Dynamic Tables.
  • Solid grasp of data warehousing concepts, data modeling, and metadata management.
  • Expertise in identity and access management, data masking, and security best practices.
  • Demonstrated ability to diagnose and resolve performance and scalability issues in Snowflake and ADF.

Preferred:

  • SnowPro Advanced Architect or Advanced Data Engineer certification.
  • Experience with Azure SQL MI, ADLS Gen2, and broader Azure cloud services.
  • Familiarity with Snowflake Intelligence for natural language querying and agentic AI workflows.
  • Experience with Semantic Views, dbt Semantic Layer, and Gen2 Warehouses.
  • Familiarity with Jira, ServiceNow, Confluence, and Azure DevOps.
  • Strong communication skills, comfortable working across technical and business-facing 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.

Your Name:

Email Address:

Phone Number:

  • I consent to receive SMS and MMS messages from Granite Solutions Groupe about job opportunities and updates. Message and data rates may apply. Message frequency may vary. You can opt out at any time by replying STOP, or get help by replying HELP. Providing consent is not a condition of submitting an application.

Upload Resume File:

Upload Resume File:…

Attach a Resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

  • By submitting this application, you give us permission to store your personal information, and use it in the consideration of your fitness for the position, including sharing it with the hiring firm.

Review our Privacy Policy for more information.

  • By submitting this application, you agree to our Terms of Service.

Review Terms of Service

People looking for jobs should not put anything here.

We are uploading your application. It may take a few moments to read your resume. Please wait!

  • View all opportunities

California Headquarters

(415) 963-3999

26565 Agoura Road, #58

Calabasas, CA 91302

  • GSG Difference
  • Supplier Diversity Program
  • Commitment to Community
  • Careers
  • Contact Us
  • LinkedIn

2026 Granite Solutions Groupe. 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 settingsACCEPT

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

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/