Snowflake Data Engineer

Job Title:

Location:

Experience:

Key Responsibilities

Data Solution Design

• Create and implement data warehouses, data lakes, and robust data models on the Snowflake platform.
  

ETL/ELT Pipeline Development

• Design, develop, and optimize pipelines for extracting, transforming, and loading data from diverse sources.
  

Performance Tuning & Optimization

• Utilize Snowflake features such as micro-partitions, clustering, and virtual warehouses to enhance scalability and performance.
  

Data Modeling

• Design and maintain efficient data models and stored procedures to support reporting and analytics.
  

SQL Expertise

• Write complex, optimized SQL queries for data transformation, manipulation, and analytics.
  

Data Security & Governance

• Implement and manage security measures including Role-Based Access Control (RBAC) and encryption to maintain compliance.
  

Semi-structured Data Handling

• Work with JSON, XML, and Parquet using Snowflake's VARIANT attribute for flexible data storage.
  

Migration

• Develop strategies and execute migrations from on-premises databases or other platforms to Snowflake.
  

Collaboration & Mentorship

• Work with data engineers, analysts, and business stakeholders to translate requirements into technical solutions.
• Provide guidance and mentor junior developers to foster best practices and team development.
  

Documentation

• Maintain technical specifications, deployment procedures, and knowledge sharing materials for the team.
  

Required Skills & Tools

• Snowflake Platform: Expert in Snowflake architecture, features, and functionalities.
• SQL: Advanced proficiency in writing complex and optimized queries.
• Data Modeling: Strong understanding of data warehousing, star schema, and dimensional modeling.
• ETL/ELT Tools: Experience with dbt, Snowpark, PySpark, or AWS Glue for pipeline automation.
• Programming: Proficiency in Python for data processing and automation.
• Cloud Platforms: Familiarity with AWS or other cloud services for scalable solutions.
• BI Tools: Tableau, Power BI, or similar tools for analytics and visualization.
• Version Control: Experience with Git or other version control systems.
  

Primary Skills

• Liaise and communicate effectively with senior technical stakeholders.
• Perform analysis and data modeling required in Snowflake.
• Estimate implementation efforts and define technical plans.
• Lead and manage the implementation team (Data Engineers and Qlik report developers) on a day-to-day basis.
• Ensure deliverables meet quality, performance, and scalability standards.