SQL & Snowflake Engineer
Core
Designing and implementing complex SQL queries and dbt models to build scalable ELT transformation pipelines.
Role type
Senior IC SQL & Snowflake Engineer
Builds
Scalable ELT data pipelines and Snowflake data infrastructure
Domain
Data Engineering / Cloud Data Warehousing
Deliverable
production ML models
Required skills
Snowflake architecture, dbt, Advanced SQL, ELT processes, Git
Preferred skills
AWS, Terraform, Python, semi-structured data (JSON, Parquet)
Technologies
Snowflake, dbt, AWS, Terraform, Python, Git, Liquibase
Responsibilities
Specify implementation of complex SQL queries and dbt models; Build, test, and maintain scalable ELT transformation pipelines; Manage and configure Snowflake data infrastructure (virtual warehouses, RBAC, resource monitors); Optimize SQL performance and Snowflake infrastructure costs; Analyze and map underlying data schemas; Participate in technical discussions, data quality reviews, and schema design sessions.
Seniority
Senior, hands-on IC