Snowflake Developer - SNFKDEV 25-33929

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
No Travel Required

Skills

Transact-SQL
RDBMS
Reporting
SQL
Snow Flake Schema
Storage
Technical Support
Microsoft Power BI
Identity Management
Information Technology
Management
ELT
Database
Database Design
DevOps
Dimensional Modeling
Documentation
Continuous Improvement
Data Architecture
Data Engineering
Data Integration
Authentication
Authorization
Big Data
Business Intelligence
Cloud Architecture
Modeling
Optimization
Performance Tuning
Problem Solving
Version Control
Encryption
Extract
Transform
Load
Extraction
GitHub
IDP
Microsoft Azure
Data Loading
Data Modeling
Data Security
Data Visualization
Data Warehouse
Cloud Computing
Collaboration
Communication
Computer Science
Conflict Resolution
Access Control
Amazon Web Services
Analytical Skill
Analytics
Artificial Intelligence

Job Details

Job Title: Snowflake Developer / Architect

Job Type: Contract

Duration: 12 Months

Location: Boston, MA 02116

Job Summary

The Technology division of a large organization is seeking a highly skilled and motivated Snowflake Developer/Architect to join its data platform team. This role focuses on designing, developing, optimizing, and supporting scalable cloud data solutions using Snowflake. The ideal candidate will have strong expertise in data warehousing, ETL/ELT pipelines, cloud architecture, and performance optimization, and will collaborate closely with architecture, engineering, and analytics teams.

Key Responsibilities

  • Performance Tuning:

    • Monitor and optimize query performance, resource utilization, and storage management

  • User & Access Management:

    • Manage users, roles, and permissions to ensure data security and compliance

  • Data Integration:

    • Support and manage data loading, transformation, and extraction processes (ETL/ELT)

  • Troubleshooting & Support:

    • Provide technical support for Snowflake-related issues, including performance bottlenecks and query optimization

  • Documentation & Reporting:

    • Maintain detailed documentation of system configurations, procedures, and changes

    • Produce regular reports on system performance and usage

  • Collaboration:

    • Work closely with data engineers, analysts, and IT teams to ensure seamless integration and optimal performance

  • Best Practices & Optimization:

    • Stay current with Snowflake best practices and industry trends

    • Recommend and implement enhancements, upgrades, and continuous improvements

Qualifications & Experience

  • Education:

    • Bachelor s degree in Computer Science, Information Technology, or a related field (minimum)

  • Experience:

    • 5+ years of experience in data architecture, data engineering, or database development

    • 2+ years of hands-on experience with Snowflake, including data modeling, performance tuning, and security

  • Experience with source control tools (GitHub preferred)

  • Experience with ETL/ELT tools and cloud platforms (AWS preferred)

  • Exposure to or experience with AI tools

  • Strong understanding of data warehousing concepts, dimensional modeling, and analytics

Required Skills

  • Strong proficiency in Snowflake architecture, features, and capabilities

  • Advanced SQL skills, including Snowflake-specific query optimization

  • Proficiency in Python

  • Strong database design and data modeling experience (including modeling tools)

  • Experience with ETL tools, data pipelines, and data integration processes

  • Knowledge of Snowflake security features, including access control, authentication, authorization, encryption, masking, and secure views

  • Experience working in AWS cloud environments

  • Experience with Power BI and other BI, data visualization, and reporting tools

  • Strong analytical, problem-solving, and troubleshooting skills

  • Ability to identify and drive continuous improvement initiatives

  • Strong communication skills with the ability to explain technical concepts to non-technical stakeholders

  • Ability to work independently and collaboratively in a fast-paced environment

Preferred / Nice to Have

  • Snowflake certifications (e.g., SnowPro Core or Advanced)

  • Experience integrating Snowflake with BI and reporting tools

  • Experience with identity and access management solutions (e.g., Azure IDP)

  • Experience with other RDBMS, cloud data warehouses, or big data platforms

  • Knowledge of T-SQL, DevOps practices, and scripting

  • Strong experience gathering business requirements and aligning solutions to delivery

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.