Snowflake

Key Responsibilities

• Strong hands-on experience with SQL and/or Python for data analysis and ad hoc query development.
• Develop and optimize ETL/ELT processes, translating business requirements into dimensional models, facts, and dimensions while considering Change Data Capture (CDC).
• Design and implement scalable data pipelines and architectures using Snowflake.
• Develop complex SQL queries and scripts for data transformation, aggregation, and analysis.
• Apply strong data modelling principles, particularly for data science projects involving large historical snapshot tables and multiple features.
• Optimize data flows and solutions to support cross-functional data requirements.
• Implement data security, governance, and compliance in line with industry standards.
• Work with Snowflake architecture, data warehousing, administration, and Snowpipe.
• Evaluate emerging technologies and contribute to scalable and distributed data architecture solutions.

Required Skills

SQL and/or Python

ETL/ELT and CDC

Data Modelling

Snowflake Data Warehouse

Snowpipe

Data Pipelines & Architecture

Data Transformation & Analysis

Data Security & Governance

Preferred: Experience with cloud data warehouse technologies, particularly Snowflake.