Snowflake Data Architect Administrator

Global Soft Systems

Job Location:

Boston, NH - USA

Monthly Salary: Not Disclosed

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Job Summary

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

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 ...