Snowflake Data Architect / Administrator

Snowflake Data Architect / Administrator

Open in Boston, MA or Woodbridge, NJ (4 days/week onsite)

F2F Interview is required

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 in AWS
• 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)
• 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