Snowflake Developer

  • San Francisco, CA
  • Posted 13 hours ago | Updated 13 hours ago

Overview

Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

snowflake
fivetran

Job Details

Job Title: Snowflake Developer

Location: San Francisco, CA (Hybrid / Onsite as per client needs)

The primary focus would be compensation and equity data models and understand Fivetran. Below are skills needed:

  • Build and own canonical People data models (employee, org/role, movement, recruiting funnel, comp history, mobility) in dbt with SCD handling, tests, docs, and data contracts.
  • Define a metrics/semantic layer and ship curated marts for the Head of People Analytics; enable self-serve via BI (Looker/Mode/Hex/Tableau).
  • Implement privacy-by-design (PII minimization, RBAC), lineage, and governance in partnership with Legal/Privacy/Security.
  • Manage Fivetran connector

Job Summary

We are seeking an experienced Snowflake Developer to support data engineering and analytics initiatives for OpenAI. The ideal candidate will have strong hands-on experience with Snowflake data warehousing, SQL optimization, and cloud-based data pipelines, working closely with analytics, data science, and platform teams.

Key Responsibilities

  • Design, develop, and optimize Snowflake data models, schemas, and warehouses

  • Build and maintain ELT/ETL pipelines using Snowflake and cloud-native tools

  • Write complex, high-performance SQL queries and stored procedures

  • Implement and manage Snowflake features such as Streams, Tasks, Time Travel, and Zero Copy Cloning

  • Optimize performance, cost, and scalability of Snowflake workloads

  • Integrate Snowflake with upstream/downstream systems (APIs, data lakes, BI tools)

  • Collaborate with data engineers, analysts, and AI/ML teams to enable advanced analytics use cases

  • Ensure data quality, governance, security, and compliance best practices

  • Support production issues, monitoring, and performance tuning

Required Skills & Qualifications

  • 5+ years of experience in data engineering or data warehousing roles

  • Strong hands-on experience with Snowflake (minimum 2 3 years)

  • Advanced SQL skills (query optimization, performance tuning)

  • Experience with cloud platforms: AWS, Google Cloud Platform, or Azure

  • Strong understanding of data modeling (star/snowflake schemas)

  • Experience with ETL/ELT tools (dbt, Airflow, Matillion, Fivetran, or similar)

  • Familiarity with Python for data processing and automation

  • Knowledge of data security, RBAC, and governance in Snowflake

  • Excellent communication and collaboration skills

Nice to Have

  • Experience supporting AI/ML or analytics-heavy environments

  • Exposure to real-time or large-scale data processing

  • Experience with BI tools (Tableau, Looker, Power BI)

  • Snowflake or cloud certifications

Why Join This Role

  • Opportunity to work with OpenAI, supporting cutting-edge AI and data initiatives

  • Exposure to large-scale, high-impact data platforms

  • Work in a highly collaborative, fast-paced, innovation-driven environment

  • Competitive compensation and long-term growth potential

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.