Snowflake Database Architect (Local to MA or NJ)

Role: Snowflake Database Architect

Location: Woodbridge, NJ or Boston, MA USA (Hybrid)

Duration: Long Term

Exp: 13+ Yrs

Employment: W2

Interview: Two Rounds (Virtual + F2F)

Overview

We are seeking a Snowflake Data Architect / Administrator to lead the design, implementation, and administration of a modern cloud data platform. This role will focus on Snowflake architecture, ETL modernization, and migration from legacy systems using DBT and Informatica.

Key Responsibilities

Architect and manage scalable, secure, and high-performance data solutions on Snowflake

Lead end-to-end migration from on-premise data platforms to Snowflake, including assessment, planning, and execution

Design and oversee ETL/ELT pipelines using DBT and Informatica PowerCenter

Define data models, architecture standards, and best practices for data warehousing and data lakes

Administer Snowflake environment, including performance tuning, resource optimization, and cost management

Implement and manage Snowflake features such as Snowpipe, Streams, Tasks, UDFs, and external tables

Design and enforce data security, governance, and access control policies

Oversee ingestion of structured and semi-structured data (CSV, JSON, Parquet) from cloud storage

Provide technical leadership, mentor developers, and guide architectural decisions

Collaborate with cross-functional teams in an Agile environment

Required Skills & Experience

Strong expertise in Snowflake architecture and administration

Hands-on experience with DBT (Data Build Tool) and Informatica PowerCenter (8.x/9.x/10.x)

Proven experience in data platform migration to Snowflake

Advanced knowledge of SQL, PL/SQL, and data warehousing concepts

Experience with Snowflake utilities (SnowSQL, Snowpipe, Streams, Tasks, UDFs)

Familiarity with AWS and/or Azure cloud platforms

Experience in performance tuning, query optimization, and cost control

Working knowledge of Python, Control-M, GitHub, and UNIX environments

Experience working in Agile methodologies

Preferred Qualifications

Experience converting legacy ETL workflows into DBT models

Strong understanding of modern data architecture patterns (ELT, lakehouse, real-time pipelines)

Prior experience in a lead or architect role