Snowflake Engineer
Core
Designing and building Snowflake data warehouses, handling data migration, and developing complex SQL queries for OLTP and OLAP environments.
Role type
Senior Snowflake Data Engineer
Builds
Production data warehouses, migrated data pipelines, and data models
Domain
Cloud Data Warehousing (Snowflake)
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Snowflake architecture, SnowSQL, Snowpipe, Role-based access controls, ETL/ELT tools, CI/CD, monitoring, orchestration, data quality, complex SQL, Data modeling (STAR/Snowflake schema), OLTP/OLAP design
Preferred skills
PL/SQL, Azure/AWS, Databricks, Python, PySpark, Erwin, IBM InfoSphere
Technologies
Snowflake, SnowSQL, Snowpipe, Azure, AWS, Databricks, Python, PySpark, Erwin, IBM InfoSphere
Responsibilities
Execute data migration and initial loads into Snowflake; Build and maintain Snowflake environments including layers and database objects; Develop complex SQL queries for data analysis; Design conceptual, logical, and physical data models; Implement non-functional requirements like CI/CD and monitoring; Work with heterogeneous data migration projects.
Seniority
Mid-Senior, hands-on IC