Snowflake Data Engineer

Berribot; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Berribot is seeking a senior Snowflake Data Architect/Engineer to lead cloud data warehouse initiatives across India. The role demands 5–10 years in data platforms with 3+ years hands-on Snowflake.

You will design scalable ELT pipelines, develop data models, implement Snowflake features, and guide migrations from legacy systems. Strong SQL, Python, DBT and data governance skills are essential.

Qualifications

• 5–10 years of data platform experience with 3+ years hands-on Snowflake.
• Experience designing scalable ELT pipelines and data models on Snowflake using SQL, DBT, and Python.
• Proficiency with Snowflake features: Snowpipe, Streams & Tasks, Time Travel, Data Sharing.

Responsibilities

• Strong experience and understanding of Data Warehouse and Data Lake platform architecture and design.
• Design and build scalable ELT pipelines and data models on Snowflake using SQL, DBT, and Python.
• Develop data warehousing solutions (star schema, SCD, Data Vault) supporting enterprise analytics and reporting.
• Implement Snowflake-native features — Snowpipe, Streams & Tasks, Time Travel, Data Sharing, and Cortex AI functions.
• Lead/support migrations from legacy platforms to Snowflake.
• Optimise workloads through warehouse sizing, query tuning, clustering, and cost-management best practices.
• Implement data security and governance — dynamic masking, RBAC, row/column-level security, and secure data sharing.
• Build CI/CD and automation for Snowflake deployments using DBT, Liquibase, and Git-based pipelines.
• Integrate Snowflake with ETL tools (Informatica, DataStage, Matillion) and BI tools (Power BI, Tableau).

Skills

SQL

Python

DBT

Snowflake

ELT pipelines

Data Warehousing

Cost optimization

Data security

Tools

Informatica

Matillion

Liquibase

Git

Job description

Location

Pan India

Experience

5–10 Years (role-dependent), including 3+ years hands-on Snowflake

Employment Type

Full-time

Key Responsibilities

• Strong experience and understanding of Data Warehouse and Data Lake platform architecture and design.
• Design and build scalable ELT pipelines and data models on Snowflake using SQL, DBT, and Python.
• Develop data warehousing solutions (star schema, SCD, Data Vault) supporting enterprise analytics and reporting.
• Implement Snowflake-native features — Snowpipe, Streams & Tasks, Time Travel, Data Sharing, and Cortex AI functions.
• Lead/support migrations from legacy platforms (Teradata, Oracle, Exadata, GreenPlum, Hadoop) to Snowflake.
• Optimise workloads through warehouse sizing, query tuning, clustering, and cost-management best practices.
• Implement data security and governance — dynamic masking, RBAC, row/column-level security, and secure data sharing.
• Build CI/CD and automation for Snowflake deployments using DBT, Liquibase, and Git-based pipelines.
• Integrate Snowflake with ETL tools (Informatica, DataStage, Matillion) and BI tools (Power BI, Tableau).

Mandatory Skills

• SQL, PL/SQL, Python; DBT for transformations
• Snowpipe, Streams & Tasks, Time Travel, Data Sharing
• Warehouse sizing, query tuning & cost optimisation
• Data security & governance (masking, RBAC)

Good to Have

• Migration from Teradata/Oracle/Exadata/GreenPlum
• Snowflake Cortex AI/GenAI for data