What are the responsibilities and job description for the Snowflake Architect position at Lorvenk Technologies?
Role: Snowflake Data Architect
Location: Woodbridge, NJ or Boston, MA, USA (Hybrid)
Duration: Long Term
Exp: 12 Yrs
Employment: W2
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, 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