Snowflake Engineer

What you'll do

• Lead the design of enterprise-scale data warehousing and cloud integration strategies on Snowflake.
• Build scalable ELT pipelines using Snowflake features like Snowpipe, Streams, Tasks, and Snowpark.
• Implement data modeling frameworks such as Dimensional or Data Vault using dbt.
• Optimize query performance and manage warehouse compute costs through clustering, caching, and sizing.
• Integrate orchestration tools like Apache Airflow or Prefect to manage complex dependency graphs.
• Develop and maintain scalable data pipelines for both streaming and batch requirements.
• Write and perform data unit and integration tests to ensure data quality and completeness.
• Apply secure software and systems engineering practices to protect data from threats and vulnerabilities.

What we're looking for

• Must be a Certified Snowflake Engineer focused on Snowflake architecture and implementation.
• Requires 6 to experience with data quality rules, data management standards, and practices.
• Requires 1 to experience developing compelling stories and distinctive visualizations.
• Requires advanced skills in SQL, Python (including PySpark or Snowpark), and modern transformation tools like dbt.
• Requires deep knowledge of Snowflake RBAC, zero-copy cloning, time travel, and performance tuning.
• Requires experience in data warehousing, statistical analysis, data models, and queries.
• Requires undergraduate studies in computer science, management information systems, business, statistics, math, or a related field (preferred).
• Requires graduate studies in business, statistics, math, computer science, or a related field (preferred).