What are the responsibilities and job description for the Sr. Snowflake Developer position at Tranzeal, Inc.?
Job Details
Sr. Snowflake Developer
Job Summary
We are seeking an experienced Snowflake Developer to support data engineering and analytics initiatives. This role focuses on building, optimizing, and scaling Snowflake-based data solutions while working closely with analytics, data science, and platform teams.
Responsibilities
Design, develop, and optimize Snowflake data models, schemas, and warehouses
Build and maintain ETL/ELT pipelines, including Fivetran integrations and cloud-native tools
Write and optimize complex SQL queries, views, and stored procedures
Implement Snowflake features such as Streams, Tasks, Time Travel, and Zero-Copy Cloning
Optimize performance, scalability, and cost of Snowflake workloads
Integrate Snowflake with APIs, data lakes, and BI tools
Collaborate with data engineering, analytics, and AI/ML teams to support advanced analytics use cases
Ensure data quality, governance, security, and compliance best practices
Monitor production workloads and support performance tuning and issue resolution
Required Qualifications
10 years of experience in data engineering or data warehousing
6 years of hands-on Snowflake experience
Advanced SQL skills, including performance tuning
Experience with Fivetran for data ingestion and ELT pipelines
Experience with cloud platforms (AWS, Google Cloud Platform, or Azure)
Strong understanding of data modeling (star and snowflake schemas)
Experience with ETL/ELT tools such as Fivetran, dbt, Airflow, or Matillion
Working knowledge of Python for data processing and automation
Familiarity with Snowflake security, RBAC, and governance
Strong communication and collaboration skills
Experience supporting AI/ML or analytics-heavy environments
Exposure to large-scale or real-time data processing
Experience with BI tools (Tableau, Looker, Power BI)
Snowflake or cloud certifications