Snowflake Data Architect / Administrator

Global Soft Systems
Boston, MA, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Compensation
$89,000.0 - $101,100.0
Working hours
Regular working hours
Job source

Tech stack

Agile Methodology Amazon Web Services Unix Cloud Storage Databases Data Architecture Extract Transform Load (ETL) Data Security Data Systems Data Warehousing Github JSON
+15 more
Python (Programming Language) Performance Tuning Query Optimization Standard Sql PL-SQL Parquet Informatica Powercenter Snowflake Data Build Tool (dbt) Data Lakes Semi-structured Data Data Management Data Pipelines Legacy Systems Control M

Job description

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, As a Database Administrator, you will play a crucial role in shaping the performance of next-generation AI systems. Your expertise will directly influence how models learn and reas…
  • 2 days ago
  • Apply easily, The Research Administrator is responsible for the management of the research portfolio(s) for one or more laboratories with direction and moderate supervision from their supervisor…
  • 2 days ago

Requirements

  • 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

Benefits & conditions

  • $89,000-101,100 per year

About the company

© 2026 Careerjet All rights reserved

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on careerjet.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · WWC Europe 2026

3:47 min

Exploring JSON, CBOR, and JOSE for data serialization

Aaron Russell · LIVE

2:03 min

Microsoft integrating native Unix coreutils into Windows environments

Chris Heilmann +2 · LIVE

2:15 min

Empowering domain teams with an open data platform

Sandhya Menon Sandhya Menon · WWC Europe 2026

2:03 min

Distinguishing type definition constructs from data validation routines

Clemens Vasters Clemens Vasters · WWC 2025

2:04 min

Defining timestamps and the international standard format

Denny Biasiolli Denny Biasiolli · Europe 2026 Virtual

Videos

See all

Related articles

See all