Job Description Overview
  • Skill: Snowflake, SQL, Data Warehouse Concepts, Power BI, Cloud Architecture, Data Modeling, Snowpipe, SnowSQL, RBAC, Virtual Warehouse, Data Migration, Streaming, Incremental Data Loads, Data Sharing, Lakehouse, Snowflake Features, Resource Monitoring, On-prem to Snowflake Migration
  • Location: Remote
  • Experience: 6

We are seeking a skilled Snowflake Data Engineer with a minimum of 4+ years of relevant experience in Snowflake and a total of 7+ years of experience in data engineering. The ideal candidate will have a deep understanding of database and data warehouse concepts, strong expertise in SQL, and experience with Power BI development. You will play a key role in designing and implementing Snowflake cloud data warehouse architectures, data migration from on-premise systems to Snowflake, and leveraging advanced Snowflake features. A solid understanding of incremental data loads, both batched and streaming, along with experience in managing Snowflake resources, is essential.

 

Key Responsibilities:

  • Snowflake Data Warehouse Design: Design and implement Snowflake cloud data warehouse architecture and data modeling to ensure scalability and efficiency.
  • SQL Expertise & Data Warehouse Concepts: Utilize advanced SQL skills to manage and optimize data warehouse operations, with a strong understanding of database concepts.
  • Data Migration: Manage and execute data migration projects, including the migration of data from on-premise systems to Snowflake.
  • Snowflake Advanced Features: Implement and optimize advanced Snowflake features like Snowpipe, RBAC controls, Virtual Warehouse sizing, and Zero Copy Clone for performance and security.
  • Data Streams & SnowSQL: Leverage Snowflake capabilities such as Streams, SnowSQL, and resource monitoring to automate and streamline data workflows.
  • Power BI Development: Develop Power BI dashboards and reports to provide actionable insights from Snowflake data.
  • Incremental Data Loads: Manage incremental extraction loads, both batched and streaming, to ensure efficient data processing.
  • Data Sharing & Event Patterns: Deploy Snowflake features such as data sharing, event-driven architectures, and lakehouse patterns to enable seamless collaboration and integration.

 

Good to Have:

  • Migration Experience: Prior experience with migrating data from on-premise systems to Snowflake and implementing cloud-based solutions.
  • Comprehensive Knowledge of Snowflake: A deep understanding of Snowflake's architecture and features, including resource monitoring, RBAC, and event-driven processing.
  • Power BI Reporting: Strong experience in Power BI development to create data visualizations and dashboards that help business teams make data-driven decisions.

 

We are looking for a proactive and detail-oriented professional who thrives in a cloud data environment, is skilled in Snowflake, and is passionate about optimizing and implementing robust data systems. If you have expertise in Snowflake, data migration, and cloud architecture, we encourage you to apply for this exciting opportunity.