Snowflake Data Architect / Administrator
Global Soft Systems
Boston, United States of America
14 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Compensation
$ 101KJob location
Remote
Boston, United States of America
Tech stack
Agile Methodologies
Amazon Web Services (AWS)
Unix
Cloud Storage
Databases
Data Architecture
ETL
Data Security
Data Systems
Data Warehousing
Github
JSON
Python
Performance Tuning
Query Optimization
Standard Sql
PL-SQL
Parquet
Informatica Powercenter
Snowflake
Data Build Tool (dbt)
Data Lake
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