Snowflake Data Architect (San Francisco) Job at GSPANN Technologies, Inc, San Francisco, CA

aGV5T1dDTkZYb21JeDVMekNtOERqZFU9
  • GSPANN Technologies, Inc
  • San Francisco, CA

Job Description

Headquartered in Milpitas, California (U.S.A.), GSPANN provides consulting and IT services to global clients, ranging from mid-size to Fortune 500 companies. With our experience in retail, high-technology, and manufacturing, we help our clients to transform and deliver business value by optimizing their IT capabilities, practices, and operations. Counting on our ten offices, including four global delivery centers, and approximately 1400 employees globally, we offer the intimacy of a boutique consultancy with capabilities of a large IT services firm.

Duration: Long Term

Key Responsibilities

  • Design and architect end-to-end data solutions leveraging Snowflake as the primary data warehouse.
  • Build and optimize ETL/ELT pipelines using Matillion, ensuring scalability, performance, and reliability.
  • Develop data models (conceptual, logical, and physical) addressing business and analytical requirements.
  • Define and enforce data governance, data quality, and metadata management standards.
  • Work closely with product, BI, analytics, and engineering teams to translate business needs into architectural blueprints.
  • Optimize Snowflake performance: clustering, micro-partitioning, caching, warehouse sizing, and cost governance.
  • Integrate data from various structured and unstructured sources.
  • Review existing data systems and recommend modernization opportunities.
  • Ensure security best practices including role-based access control, encryption, and compliance.
  • Create documentation, architectural diagrams, and data flow maps.
  • Drive best practices for CI/CD, data testing, and DevOps for data pipelines.

Required Skills

  • 10+ years of experience in data engineering or data architecture roles.
  • Strong handson expertise in Matillion ETL/ELT (jobs, orchestration, components, transformations).
  • Deep understanding of Snowflake warehouses, schema design, streams, tasks, materialized views, performance tuning.
  • Proficiency in SQL, data modeling , and data warehouse concepts (Kimball/Inmon).
  • Experience with cloud platforms (AWS/Azure/GCP), especially AWS services like S3, Lambda, EC2, IAM.
  • Strong understanding of batch and realtime data processing patterns.
  • Knowledge of data governance, master data management, and metadata frameworks.
  • Experience with version control (Git) and CI/CD workflows.
  • Ability to create architecture diagrams using tools like Lucidchart, Draw.io, or Visio.

Working at GSPANN

GSPANN is a diverse, prosperous, and rewarding place to work. We provide competitive benefits, educational assistance, and career growth opportunities to our employees. Every employee is valued for their talent and contribution. Working with us will give you an opportunity to work globally with some of the best brands in the industry.

The company does and will take affirmative action to employ and advance in the employment of individuals with disabilities and protected veterans and to treat qualified individuals without discrimination based on their physical or mental disability status. GSPANN is an equalopportunity employer for minorities/females/veterans/disabled.

Seniority Level

MidSenior level

Employment Type

Contract

Job Function

Information Technology

Referrals increase your chances of interviewing at GSPANN Technologies, Inc by 2x.

#J-18808-Ljbffr

Job Tags

Full time, Contract work,

Similar Jobs

Priority Physicians

Dermatology Physician Assistant Job at Priority Physicians

 ...Buffalo Grove Join an established and reputable Dermatology practice. Full schedule from day one See a mix of General & Cosmetics EMR is Nextech W2 position Earn in the top 5% nationally for mid-levels Benefits package prefer a minimum of 1-2... 

Sittercity

Northern Liberties Family Seeking Full-Time Nanny (40 Guaranteed Hours) Job at Sittercity

 ...Northern Liberties looking for a reliable full-time nanny to become part of our home. The position...  ...from 7:007:30am to 5:005:30pm, with 40 hours guaranteed weekly at $25/hour and the...  ...primary responsibility is caring for our sweet 15-month-old, along with childrens laundry,... 

Metova

Senior MuleSoft Developer (L4) Job at Metova

 ...Mulesoft Developer (L4) We are seeking a MuleSoft Developer (L4) to help build a modern, unified digital experience platform for a large multi-venue hospitality and entertainment organization. In this senior, hands-on integration role, you'll architect and deliver... 

jobgether

Data Analyst - REMOTE Job at jobgether

 ...behalf of a partner company. We are currently looking for a System Data Analyst - REMOTE. In this role, you will significantly contribute to...  ...ensure the integrity and flow of data. This position involves working closely with data modelers and engineers, making your... 

10-4 Truck Recruiting

CLASS A RECENT GRAD TRUCK DRIVER POSITION -NO EXPERIENCE NEEDED! Job at 10-4 Truck Recruiting

 ...Class A CDL Solo Truck Driver - RECENT GRADUATES OK!*****Please read to make sure you qualify :) POSITION DETAILS: ~...  ...Regional positions available ~ Gain 3 months of experience and transfer to local ~ No touch freight ~ Weekly Pay via Direct Deposit...