Snowflake Data Architect

Hybrid in Boston, MA, US • Posted 1 day ago • Updated 1 day ago
Contract W2
Hybrid
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

  • Data Build Tool
  • SQL

Summary

Snowflake Data Architect / Administrator

Plymouth Rock Assurance

Woodbridge, NJ or Boston, MA 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
  • 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)
  • Familiarity with AWS and/or Azure cloud platforms
  • 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91098630
  • Position Id: 8947994
  • Posted 1 day ago

Company Info

About Lorvenk Technologies LLC

Lorvenk Technologies , founded in Virginia-USA, is a leading provider of Custom Application Development and end-to-end IT Services to clients globally. We use a client-centric engagement model that combines local on-site and off-site resources with the cost, global expertise and quality advantages of off-shore operations. We deliver Custom Application Development, Application Modernization, Business Process Outsourcing and Professional IT Services from office locations in USA and India.

Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Boston, Massachusetts

Yesterday

Easy Apply

Contract

Depends on Experience

Boston, Massachusetts

Yesterday

Easy Apply

Contract

Depends on Experience

Hybrid in Boston, Massachusetts

Today

Easy Apply

Full-time, Third Party

Depends on Experience

Hybrid in Woodbridge Township, New Jersey

Today

Easy Apply

Third Party, Contract

Depends on Experience

Search all similar jobs