Apply Now

Snowflake Data Architect / Administrator

Hybrid in Boston, MA, US • Posted 1 day ago • Updated 1 day ago

Contract W2

Hybrid

Depends on Experience

Lorvenk Technologies LLC

Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

Python
Snow Flake Schema
Amazon Web Services

Summary

Role : Snowflake Data Architect / Administrator
Location : Woodbridge, NJ or Boston, MA 4 days/week onsite(Near By Location is also fine)
Experience :12+
Contract : w2 & C2C
Visa: Any Visa No Opt
F2F interview is required

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

Go to company profile

Create job alert

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

Similar Jobs

Snowflake Data Architect

Hybrid in Boston, Massachusetts

•

Yesterday

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

Easy Apply

Contract

Depends on Experience

Snowflake Database Architect- Local to NJ or MA

Hybrid in Boston, Massachusetts

•

Today

Role: Snowflake Data Architect Location: Woodbridge, NJ or Boston, MA, USA (Hybrid) Duration: Long Term Exp: 12+ Yrs Interview: Two Rounds (Virtual + F2F) 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, an

Easy Apply

Full-time, Third Party

Depends on Experience

Snowflake Database Architect/Engineer

Boston, Massachusetts

•

Yesterday

Snowflake Database Architect/Engineer You will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms Activities will also include cross-functional collaboration with software development, security, and data warehouse teams. Essential Functions and Responsibilities: Maintain a Snowflake data warehouse, and data replication from various sources. Set up and maintain security and access for production. Development responsibilities i

Easy Apply

Contract

Depends on Experience

data scientist with AI/ML

Remote

•

Yesterday

Role: Data Scientist W2 contract Role Location: REMOTE Job Description: About the Role We re looking for a data scientist (minimum 2+ years of experience) who is passionate about Natural Language Processing (NLP), Generative AI, and traditional machine learning and who knows how to ship high-impact, production-grade models. This is a hands-on role where you ll work across the full ML lifecycle: from prototyping to deployment, with a strong emphasis on production-readiness, APIs, and scalable ar

Easy Apply

Contract, Third Party

Depends on Experience

Search all similar jobs