Snowflake Data Architect / Administrator

Job ID : 39625

Location : Boston, MA

Company Name : Arche Resource LLC

Job Type : Full-Time

Industry : Information Technology

Salary : $60 - $70 per hour

No. of Positions : 2-4

Required Skills : Snowflake architecture and administration in AWS.

Benefits : Medical Insurance, 401K

Job Description :

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

• View JobQA Automation Engineer / Business Analyst

  Arche Resource LLC Plano, TX

  Responsibilities : Summary Job Title: QA Automation Engineer / Business Analyst (Playwright) Location: Plano, TX Experience Required:

• View JobBusiness Analyst

  Jhex Tempe, AZ

  Responsibilities : We are looking for a motivated and detail-oriented Business Analyst to join our team. The ideal candidate should have strong analytical skills, communication abilities, and experience working with

• View JobAI Platform Engineer

  Get2Uni New York

  Responsibilities : AI Platform Operations: Operating, monitoring, and further developing modern AI platform components for chat, assistant systems, agents, workspaces, and tool integrations. Containers &

• View JobCyber Security

  Arche Resource LLC Kenosha, WI

  Responsibilities : Description Our client is looking to add two Cyber Security Engineers to their organization. This client has traditionally had a smaller Engineering team with a bunch

• View JobRegistered Nurse

  THRIVE Talent Idaho Falls, Idaho

  Responsibilities : Registered Nurse (Open to New Grads) Idaho Falls Community Hospital (IFCH) is a physician-led acute care hospital in Eastern Idaho, known for its patient

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.