Snowflake Developer

Nforce One LLC

Quincy, MA, United States

19 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

2 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Microsoft Azure Cloud Computing Cloud Database Extract Transform Load (ETL) Data Masking Data Sharing Python (Programming Language) Performance Tuning Role-Based Access Control Workflow Management Systems Freeform SQL

+4 more

Google Cloud Sql Optimization Snowflake Data Pipelines

Job description

Data Modeling & Architecture: Build schemas, tables, dynamic tables, and views tailored for business analytics.
Pipeline Development: Create robust ELT/ETL workflows using tools like dbt, Fivetran, or Snowpark.
Performance Tuning: Optimize complex SQL queries, micro-partitioning, clustering keys, and virtual warehouse sizes.
Security & Governance: Implement role-based access control (RBAC), data masking, and row-level security.
Migration & Integration: Connect legacy or cloud databases into Snowflake and migrate historical data.

Requirements

Technical Stack: Advanced SQL

SnowSQL

Python/Snowpark

and orchestration tools.

Platform Knowledge: Mastery of Snowflake features like data sharing

zero-copy cloning

and streams/tasks.

Cloud & ETL: Experience with AWS/Azure/Google Cloud Platform environments and modern data stack tools.

Certifications: SnowPro Core or Advanced certifications are heavily preferred.

Key Responsibilities:Data Modeling & Architecture: Build schemas

tables

dynamic tables

and views tailored for business analytics.

Pipeline Development: Create robust ELT/ETL workflows using tools like dbt

Fivetran

or Snowpark.

Performance Tuning: Optimize complex SQL queries

micro-partitioning

clustering keys

and virtual warehouse sizes.

Security & Governance: Implement role-based access control (RBAC)

data masking

and row-level security.

Migration & Integration: Connect legacy or cloud databases into Snowflake and migrate historical data.

Required Skills:

Technical Stack: Advanced SQL, SnowSQL, Python/Snowpark, and orchestration tools.
Platform Knowledge: Mastery of Snowflake features like data sharing, zero-copy cloning, and streams/tasks.
Cloud & ETL: Experience with AWS/Azure/Google Cloud Platform environments and modern data stack tools.
Certifications: SnowPro Core or Advanced certifications are heavily preferred.