Senior Snowflake Developer

Fractal Analytics Inc.; Hinoba-an; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

Fractal Analytics Inc. is seeking an experienced Snowflake Developer to design and maintain data models, build scalable ELT/ETL pipelines, and manage Snowflake environments. The role focuses on delivering clean, source-aligned datasets and data products for end users.

You will work with AWS S3, REST APIs, and Snowflake to migrate and ingest data, ensure data quality, and optimize performance. Strong SQL, Snowflake, and DBT skills, plus experience with large enterprise datasets, are essential.

Qualifications

• Data modelling in 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.

Responsibilities

• Design, implement and maintain Snowflake data models per LSA.
• Build scalable ELT/ETL pipelines from AWS S3 and REST APIs into Snowflake.
• Create and manage Snowflake databases, schemas, tables, views, stages, tasks, streams and procedures.
• Implement data quality frameworks, governance, lineage and metadata management.
• Tune Snowflake performance, clustering and warehouse sizing.
• Implement data sharing, masking policies and RBAC.
• Handle structured and semi-structured data, including JSON and flat files.
• Migrate data from Azure SQL Server to Snowflake.

Skills

SQL

Snowflake

DBT

ETL/ELT

Data modelling

Data engineering

Analytics engineering

Problem solving

Communication

Tools

AWS

Python

DBT

CI/CD tools

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.