What are the responsibilities and job description for the Snowflake Developer position at Tranzeal, Inc.?
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