Senior Snowflake Developer

Fractal Analytics Ltd.; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Fractal Analytics Ltd. is seeking an experienced Snowflake Developer to design and maintain Snowflake data models in ACC environments, ingesting data from AWS S3 and other sources, and building scalable ELT/ETL pipelines for analytics.

The role emphasizes governance, RBAC, security, performance tuning, and data migration from Azure SQL. You will collaborate with enterprise teams to deliver reliable, source-aligned data products, leveraging Snowflake, SQL, and DBT.

Qualifications

• Must have Snowflake LSA data modeling experience.
• Strong SQL skills and Snowflake architecture knowledge.
• Experience with ETL/ELT processes and DBT.
• Experience migrating data from cloud sources (Azure SQL, AWS).
• Ability to work with large enterprise datasets and analytics apps.
• Good communication and problem-solving skills.

Responsibilities

• Design, develop, and maintain Snowflake data modelling as per LSA and warehouse solutions.
• Develop scalable ELT/ETL pipelines to load data from AWS S3 Bucket, Rest API’s and other sources into Snowflake (using Snowflake best practices).
• Create and manage Snowflake databases, schemas, tables, views, stages, tasks, streams, and stored procedures.
• Implement data quality frameworks, governance, lineage, and metadata management across multiple environments.
• Optimize Snowflake performance, query tuning, clustering, and warehouse sizing.
• Implement data sharing, security, masking policies, and role-based access control (RBAC).
• Work on Structured data, semi-structured data handling using JSON and manual files.
• Implement Row Level Security setup on snowflake.
• Migrate existing data from Azure SQL server to Snowflake.

Skills

Snowflake

SQL

DBT

ETL/ELT

Data Modeling

RBAC/Security

Tools

AWS

Python

CI/CD

Job description

It's fun to work in a company where people truly BELIEVE in what they are doing! We're committed to bringing passion and customer focus to the business. Job Description Note - Immediate to 30 Days only.

Project Context

Our team is currently setting up an Amazon Collaborative Commerce (ACC) data environment, extracting data through AWS APIs and storing it in Amazon S3, with plans to develop a dedicated AWS-based data lake. This data then will be loaded, processed and maintained in snowflake database.

Role Overview

We are looking for an experienced Snowflake Developer with strong expertise in Snowflake, SQL and ETL/ELT. Build and own Data Modelling as per Snowflake LSA, integration and ingestion from different sources into Snowflake, delivering clean, source-aligned datasets and data products that can be consumed by end users.

Key Responsibilities

• Design, develop, and maintain Snowflake data modelling as per LSA and warehouse solutions.
• Develop scalable ELT/ETL pipelines to load data from AWS S3 Bucket, Rest API’s and other sources into Snowflake (using Snowflake best practices.)
• Create and manage Snowflake databases, schemas, tables, views, stages, tasks, streams, and stored procedures.
• Implement data quality frameworks, governance, lineage, and metadata management across multiple environments.
• Optimize Snowflake performance, query tuning, clustering, and warehouse sizing.
• Implement data sharing, security, masking policies, and role-based access control (RBAC).
• Work on Structured data, semi-structured data handling using JSON and manual files.
• Implement Row Level Security setup on snowflake.
• Migrate existing data from Azure SQL server to Snowflake.

Mandatory/Required:

• Data Modelling – Snowflake LSA
• Proficiency in SQL, Snowflake DBT and ETL processes.
• Strong understanding of Snowflake architecture.
• Professional experience in data engineering and analytics engineering.
• Experience working with large enterprise datasets and analytics-driven applications
• Strong analytical, problem-solving, and communication skills

Good to have

• Experience with AWS services, DBT, Python.
• Knowledge of CI/CD tools.
• Understanding of data warehousing concepts.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

At Fractal

At Fractal, towards our goal of “powering every human decision in the enterprise”, our partnerships and alliances help in creating and delivering a compelling suite of solutions to unlock value. We partner with companies from around the globe, leaders in their respective fields. With Fractal’s expertise in artificial intelligence, design, engineering, and digital transformation, combined with the data, technology, and software platforms from our partners, we create cutting-edge solutions to problems in the business world. We understand how critical and timely decision triggers, and information, empower our clients to create, unlock, deliver, and realize value. Together with our partners, our goal is to serve each client in their end-to-end data-to-decision journey.